?
Solved

SQL Server SA Account

Posted on 2014-03-20
7
Medium Priority
?
295 Views
Last Modified: 2014-03-21
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
Comment
Question by:TonyEF
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 2000 total points
ID: 39944015
Can someone tell me how to go about unlocking the "sa" account???
ALTER LOGIN sa WITH PASSWORD = 'sapasswordgoeshere' UNLOCK
0
 

Author Comment

by:TonyEF
ID: 39944188
Anthony

Do I run this on a command prompt screen?
0
 
LVL 12

Expert Comment

by:Tony303
ID: 39944221
In SQL Server Management Studio
0
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 
LVL 7

Expert Comment

by:Anoo S Pillai
ID: 39944236
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
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 2000 total points
ID: 39944238
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
 
LVL 7

Expert Comment

by:Anoo S Pillai
ID: 39944246
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
 

Author Closing Comment

by:TonyEF
ID: 39945706
Thank you for the assistance...
0

Featured Post

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question