[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

SQL Server SA Account

Posted on 2014-03-20
7
Medium Priority
?
298 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
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 
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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

656 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