If you’ve forgotten the sa password for your SQL server, you are probably in a panic. Fear not, for you can reset SA password for your MS SQL Server with two methods:
First one: Reset SA Password with MS SQL Server Password Unlocker
The most easy and efficient way to reset SA password is to take use of the third part utility - MS SQL Server password Unlocker. Viewing the video about how to reset MS SQL Server 2008 password instantly:
And then please follow the instruction and learn how to reset SQL Server password with MS SQL Server Password Unlocker.Step 1. Download MS SQL Server Password Unlocker on your local PC, install and launch it.
Step 2. Access to master.mdf file, which is default at C:\Program Files\Microsoft SQL Server\MSSQL\Data\master.mdf
Step 3. Select SA account and change SA password
Now, Reset SA password successfully!
Second one: Reset SA Password with query window in the Management Studio
You can reset SA password once again have access to the powers of the sa account by using the query window in the Management Studio.
Step 1. Open the SQL Server Management Studio.
Step 2. Open a New Query.
Step 3. Copy, paste, and execute the following:
GO
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'NewPassword' MUST_CHANGE
GO
where NewPassword is the password you wish to use for the sa account.
You can now breathe easier, and once again access the sa account.