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:
- Osql -S yourservername -E
- EXEC sp_password NULL, ‘yourpassword’, ‘sa’
Of course, you can reset your other sql account password, just by changing the ‘sa’ to your another sql account name.