Knowledgebase: SQL Server 2000
Lost "SA" password (SQL 2000)
Posted by Matt Kuebler on 16 November 2009 05:44 PM

SQL Server 2000:

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.