Lost "SA" password (SQL 2000) - Powered by Kayako SupportSuite Helpdesk Software

09 Sep 2010

Support Center » Knowledgebase » Lost "SA" password (SQL 2000)

	Lost "SA" password (SQL 2000)

Article Database:

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.

Article Details

Article ID:

620

Created On:

06 Jul 2009 1:32 PM