Lost "SA" password (SQL 2000)
Posted by - NA - on 06 July 2009 01:32 PM

Follow the steps below to reset the "SA" password if you have forgotten what it was set to:

Step 1: * Go to the server that SQL Server is running on. * Open Enterprise Manager(Start -> Programs -> Microsoft SQL Server) * Right click on the SQL Server and select "Edit SQL Server Registration Properties" * Select "Use Windows authentication" and select OK.

Step 2: * Once connected, select Security * Right click on sa and select properties * Reset the password.