Use command prompt is also an easy way to reset lost sa password. See the commands below:

Method: Use Command Prompt to reset your lost SQL sa password

Step 1. Open a admin command prompt (Start -> Run -> cmd)
Step 2. Type the follow commands, and press Enter after each line:
Osql -S yourservername -E
1> sp_password NULL, ‘yourpassword’, ‘sa’
2> GO

Reference:
http://forums.asp.net/t/1604697.aspx?How+to+reset+lost+sql+sa+password+

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s