Solved

SQL SERVER 2005 keeps "locking out the SA account"

Posted on 2010-08-13
2
706 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 500 total points
ID: 33433223
Run this T-SQL statement:
ALTER LOGIN sa WITH PASSWORD = 'yourpassword' UNLOCK
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
LDAP Setup 6 65
Change Exchange 2010 Namespace 6 71
Tracking Problematic Page Splits 1 50
domain controller shut down question 6 70
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

710 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