• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 302
  • Last Modified:

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???
0
TonyEF
Asked:
TonyEF
  • 2
  • 2
  • 2
  • +1
2 Solutions
 
Anthony PerkinsCommented:
Can someone tell me how to go about unlocking the "sa" account???
ALTER LOGIN sa WITH PASSWORD = 'sapasswordgoeshere' UNLOCK
0
 
TonyEFAuthor Commented:
Anthony

Do I run this on a command prompt screen?
0
 
Tony303Commented:
In SQL Server Management Studio
0
NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

 
Anoo S PillaiCommented:
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
0
 
Anthony PerkinsCommented:
As indicated it is best to use SSMS, however you can do it from the command prompt if you use SQLCmd as in:
sqlcmd -S YourServerName -E -Q "ALTER LOGIN sa WITH PASSWORD = 'sapasswordgoeshere' UNLOCK"

Open in new window

0
 
Anoo S PillaiCommented:
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.
0
 
TonyEFAuthor Commented:
Thank you for the assistance...
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now