DAConsult Forums
DAConsult Forums
Home | Profile | Register | Active Topics | Members | Search | FAQ
Save Password
Forgot your Password?

 All Forums
 SQL Server
 Reset the MSDE 'sa' password to blank
 New Topic  Reply to Topic
 Send Topic to a Friend
 Printer Friendly
Author  Topic Next Topic  

Forum Admin

333 Posts

Posted - February 19 2010 :  15:40:52  Show Profile  Email Poster  Visit 1029usr078198's Homepage  Click to see 1029usr078198's MSN Messenger address  Reply with Quote
If you've forgotten your sa password, you can easily blank it out.

  1. Open a Command Prompt

  2. Type cd c:\program files\microsoft sql server\80\tools\binn and press enter.

  3. Type osql -E -S SQLNamedInstance or blank

  4. If you get a 1 prompt, then type sp_password NULL,new_sa_password,sa and press enter

  5. Type go and press enter. If you get a message that the password was changed...

  6. Type exit and press enter to exit from osql.
    [*]Verify that the change took by typing: osql -Usa -S SQLNamedInstance or blank. If you can get past the password prompt, you're good to go.

Hope it helps,
   Topic Next Topic  
 New Topic  Reply to Topic
 Send Topic to a Friend
 Printer Friendly
Jump To:
DAConsult Forums © 2007-2010 David Anderson Consulting Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000 Version 3.4.06