Solved

SQL Server SA Account

Posted on 2014-03-20
7
292 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 500 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
Turn Insights Into Action

You’ve already invested in ITSM tools, chat applications, automation utilities, and more. Fortify these solutions with intelligent communications so you can drive business processes forward.

With xMatters, you'll never miss a beat.

 
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 500 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

The Ultimate Checklist to Optimize Your Website

Websites are getting bigger and complicated by the day. Video, images, custom fonts are all great for showcasing your product/service. But the price to pay in terms of reduced page load times and ultimately, decreased sales, can lead to some difficult decisions about what to cut.

Question has a verified solution.

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

Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

691 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