mikedopp.net

doppNet
posts - 56, comments - 8, trackbacks - 1

MSSQL 2000 Tip of the day

So I get this email.

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

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

Source

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

Login to the SQL Server computer 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'

Print | posted on Monday, January 21, 2008 8:13 AM | Filed Under [ Links Database ASP.NET (Web Development) General ]

Feedback

No comments posted yet.

Post Comment

Title  
Name  
Email
Url
Comment   
Please add 4 and 6 and type the answer here:

Powered by: