Monday, January 21, 2008 10:49 PM mikedopp

Reset sa Password in MSSQL 2000

So I get this email.

I forgot/lost the sa password. What to do?

So I scrub the google database. Looking for an answer:

Forgot or lost your sa password? Don't worry, there is a way out.

Login to the SQL Server  as the Administrator of that computer.

Open Query Analyzer and connect to SQL Server using Windows NT authentication.

Run sp_password as show below to reset the sa password: 

sp_password @new = 'will_never_forget_again', @loginame = 'sa'
 
and wham-o there you go a password you will never forget again.
 

Filed under: ,

Comments

No Comments

Leave a Comment

(required) 
(required) 
(optional)
(required)