Solved

SQL SERVER 2005 keeps "locking out the SA account"

Posted on 2010-08-13
2
701 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
  • 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Redirected folders in a windows domain can be quite useful for a number of reasons, one of them being that with redirected application data, you can give users more seamless experience when logging into different workstations.  For example, if a use…
New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
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 …
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

776 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