Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How can I unlock the sa account on SQL SERVER 2005?

Posted on 2013-11-18
1
Medium Priority
?
549 Views
Last Modified: 2013-11-19
I have administrator privilege.  When I try to login into SQLSever 2005 Management Studio, it say the account is lock.  Could you give me the steps to unlock the sa account?

Do I use the SQL Server Surface Area tool?  How do I unlock the account using this tool?
0
Comment
Question by:cookiejar
1 Comment
 
LVL 38

Accepted Solution

by:
Mahesh earned 2000 total points
ID: 39657261
Try below.
For unlocking SA, you just have to connect as a machine administrator to the server. The machine administrators are by default granted access to SQL Server. Once you connect as an administrator, you can issue:
 ALTER LOGIN sa WITH PASSWORD = 'new_password' UNLOCK
 OR
via the registry:
Default instance:
"HKEY_LOCAL_MACHINE\Software\Microsoft\MSSqlserver\MSSqlServer\LoginMode"
to 2 for mixed-mode or 1 for integrated.
After restarting the service you should be able to logon with a local administrator and reactivate the sa account again.
Thanks
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…

926 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