Mar 01, 2012 03:07 PM|JohnWack34|LINK
"I forgot my sql server password, and i need to get the sql sa password back, how can i retrieve my sql sa password? its SQL server 2005. Any advice is ok, I don't want to reinstall the SQL server, Thanks in advance."
There are many more similar situations that people forgot the SA password shortly after installing the MS SQL Server. This article shows you 3 methods to help you change forgotten SA password for your SQL Server 2000/2005/2008 database installation.
If you've forgotten the sa password for your SQL server, you are probably in a panic. Fear not, for you can change the password and once again have access to the powers of the SA account using Windows Authentication mode.
In Object Explorer, open Security folder, open Logins folder. Right click on SA account and go to
Change SA password, and confirm it. Click OK.
Copy, paste, and execute the following:
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]
ALTER LOGIN [sa] WITH PASSWORD=N'NewPassword' MUST_CHANGE
where NewPassword is the password you wish to use for the sa account.
Click the Open File button. Select the SQL Server master database file (master.mdf). Typically it is located in the folder: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data.
The program will automatically decrypt the master database file and display all user accounts in your SQL Server. Select the SA account, click the
Change Password button. Type a new password and click OK.