mikedopp

Geekswithblogs (edition)

  Home  |   Contact  |   Syndication    |   Login
  68 Posts | 0 Stories | 46 Comments | 0 Trackbacks

News

Twitter












Tag Cloud


Archives

My Blogs

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

Feedback

# re: MSSQL 2000 Tip of the day 1/22/2008 10:52 AM Joomla Components
its really fantastic !
i like the way you have worked and written . fantastic!

Post Feedback

Title:
Name:
Email: (never displayed)
Url:
Comments: 
Please add 6 and 7 and type the answer here: