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 dont want to reinstall the SQL server, Thanks in advance.
I lost sql server password, how i can reset sql sa password?
Collapse
X
-
-
reset sql sa password
Hi, you can try to use command prompt to reset your lost password. I have used it to reset sql sa password successfully on sql server 2000/2005.
First, open a command prompt (Start -> Run -> cmd)
Then, type the follow commands, and press Enter after each line:
Osql –S yourservername –E
1> EXEC sp_password NULL, 'yourpassword', 'sa'
2> GO
It could help you.Last edited by Niheel; Sep 5 '11, 09:00 AM.
Comment