DAConsult Forums
DAConsult Forums
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Windows
 SQL Server
 Reset the MSDE 'sa' password to blank

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert Email Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
1029usr078198 Posted - February 19 2010 : 15:40:52
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,
David

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