If you have tried to access the database too many times with the wrong password, the SA account may be locked out. Do the following to unlock the account from a command prompt (cmd):

sqlcmd –S SQLSERVER\INSTANCE

Once in the interface for sqlcmd, which is represented by a 1>, type the following on separate lines:

ALTER LOGIN sa WITH PASSWORD = ‘newpassword’ UNLOCK
go
exit

Reference:
http://www.pressleypress.com/blog/?p=785

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