Geeks With Blogs
mikedopp Geekswithblogs (edition)

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'

Posted on Monday, January 21, 2008 8:13 AM | Back to top


Comments on this post: MSSQL 2000 Tip of the day

# re: MSSQL 2000 Tip of the day
Requesting Gravatar...
its really fantastic !
i like the way you have worked and written . fantastic!
Left by Joomla Components on Jan 22, 2008 10:52 AM

Your comment:
 (will show your gravatar)


Copyright © mikedopp | Powered by: GeeksWithBlogs.net