Link to home
Start Free TrialLog in
Avatar of TonyEF
TonyEF

asked on

SQL Server SA Account

I have  SQL server 2012 that only has the "sa" account as administrator and the account is locked.

Can someone tell me how to go about unlocking the "sa" account???
SOLUTION
Avatar of Anthony Perkins
Anthony Perkins
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of TonyEF
TonyEF

ASKER

Anthony

Do I run this on a command prompt screen?
In SQL Server Management Studio
if you are an admin on the server, the following procedure can be followed to unlock sa account

http://technet.microsoft.com/en-us/library/dd207004.aspx
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
My previous comment is applicable only if , you don't have any other sysadmin account available to connect to SQL server.  If you have other sysadmin accounts, Anothony's solutions should work.
Avatar of TonyEF

ASKER

Thank you for the assistance...