reset ms sql sa password

Published on Author bloggerzeroLeave a comment

How to reset ms sql sa password

Use command prompt is an easy way to reset ms sql sa password.

Step 1. Open a command prompt (Start -> Run -> cmd)

Step 2. Type the follow commands, and press Enter after each line:

  1. Osql -S yourservername -E
  2. EXEC sp_password NULL, ‘yourpassword’, ‘sa’
  3. GO

Of course, you can reset your other sql account password, just by changing the ‘sa’ to your another sql account name.



Leave a Reply

Your email address will not be published. Required fields are marked *