How to Reset a SQL Server sa Password

First off, you need to log into the machine as a user with local admin rights.

Next, you should open Management Studio on the local sql server machine and change the default startup condition so that it doesn't automatically launch the object explorer.  You do this by opening Tools - Options (Environment - General) and selecting something other than Open Object Explorer in the At startup: option.

For instance, you can set it to Open new query window.

We're disabling the object explorer because it will make a connection to the local database, and we're going to be setting the database to use Single User Mode.  In that mode, as the name implies, only one connection can be made to the database at a time.  If our object explorer has already used up that connection (even if it didn't authenticate correctly), then our query window won't have an available connection and will fail.  So, we're avoiding that issue.

After making the change, close SQL Server Management Studio.

Next, stop all SQL Server services on the server.  The easiest way to do so is to open up the SQL Server Configuration Manager.

Right-click on each Running service and select 'Stop'.  When done, hit F5 or click on the Refresh icon to confirm that all services are in fact stopped.

Now open a command window as an administrator and type in the following:

NET START MSSQLSERVER /f /T3608

Read more: ASP alliance
QR:

Posted via email from Jasper-net