Reset SA account on MS SQL Server 2008

Go back to Knowledge Base

When you do not have access to the SQL Server Database or lost the SA password, you can reset the settings or password if you have admin permissions on the server. To do this, you need to follow these steps:

1. Logon on the server as local administrator
2. Stop "SQL Server (MSSQLSERVER) service"
3. Execute "F:\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Binn\sqlservr.exe" -m
4. Open "SQL Server Management Studio" and make the required modifications, like:
   1. Unlock SA account and reset password
   2. Add sysadmin permission
5. Close the DOS Window
6. Start "SQL Server (MSSQLSERVER) service"

Here you are, you now have access to the SQL Database, enjoy it.

Go back to Knowledge Base

Details

Written by Nicolas Buache

Created on Saturday, 14 January 2012

Last Updated on Saturday, 14 January 2012

Hits: 426