Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL SERVER 2005 keeps "locking out the SA account"

Posted on 2010-08-13
2
Medium Priority
?
714 Views
Last Modified: 2012-05-10
My main instance of SQL 2005 keeps locking out the SA account.  I logged into SQL using the Management Studio using Windows authencation and cleared the checkbox and them saved it.  When I called the SA login up again it was stilled checked.  What gives?

Thanks SA Account Lockout
0
Comment
Question by:chasmx1
[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 Comments
 
LVL 12

Expert Comment

by:NormanMaina
ID: 33433205
does the account you used have sys admin privilleges?
0
 
LVL 12

Accepted Solution

by:
NormanMaina earned 2000 total points
ID: 33433223
Run this T-SQL statement:
ALTER LOGIN sa WITH PASSWORD = 'yourpassword' UNLOCK
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

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
This article explains how to install and use the NTBackup utility that comes with Windows Server.
This tutorial will walk an individual through locating and launching the BEUtility application and how to execute it on the appropriate database. Log onto the server running the Backup Exec database. In a larger environment, this would generally be …
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…

688 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