Unable to unlock user account in SQL server 2005

Question

Post reply

Unable to unlock user account in SQL server 2005

radhas

SSC Veteran

Points: 200
More actions
June 18, 2008 at 12:58 am

#183583

I am unable to unlock user account in sql server 2005.
I searched in google and many forums suggest to use Alter login with password='Password' unlock in Management studio.
But the problem is I could not even login to the management studio express and the window was closed once the login failed.
Please help to resolve this.

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 1

Are you logging on with the account that is locked or with a different account?

K. Brian Kelley
@kbriankelley

radhas SSC Veteran Points: 200 More actions · Answer 2

I am logging in with the account that is locked.I dont have the admin username and password.

Is there any other way to unlock ?

Shane Miller SSC Eights! Points: 827 More actions · Answer 3

I am having the same issue. I have a sql-authenticated id that is locked out due to numerous incorrect passwords. I go in as the system admin, change the password, and check that password must be changed at next login. However, once I hit ok with the Password Policy in place, I look at the user id, and the check is there for "Account is Locked" again. It's like I cannot unlock the id. :unsure:

bonaovox SSC Journeyman Points: 82 More actions · Answer 4

Same as grasshopper. The solution was to delete and recreate the account. Stupid. Very stupid.:unsure:

Shane Miller SSC Eights! Points: 827 More actions · Answer 5

That's exactly what I wound up having to do. And, yes, you're right. That's stupid! :crazy:

george sibbald SSC Guru Points: 104210 More actions · Answer 6

from memory the solution to this is something unexpected like untick the enforce password policy opton before unlocking the account on the status tab in login properties

---------------------------------------------------------------------

Greg Charles SSC-Forever Points: 45403 More actions · Answer 7

After going through this pain ourselves we've found the most straightforward way to unlock an account is to run this TSQL as sysadmin:

ALTER LOGIN TestLogin WITH PASSWORD = 'Test^123' UNLOCK

This changes the password and unlocks the account. Unchecking the "Login is locked out" box in SSMS is useless.

As for the OP, he'll have to find another admin login to use so he can unlock the account. If the Dedicated Administrator Connection is configured, the OP could use that to connect to the instance and unlock the login. See "Dedicated Administrator Connection" in BOL.

Greg

bonaovox SSC Journeyman Points: 82 More actions · Answer 8

I managed to unlock an account today using SSMS. I first unlocked the account (I had to uncheck the password policy verification). The account was unlocked but I kept receiving failed login messages. Then I decided to retype the password and it worked. It seems that SSMS resets the password when you unlock and account. So you have to unlock and retype the password in a way very similar to the ALTER LOGIN command.

aravind_0404 Say Hey Kid Points: 680 More actions · Answer 9

connect as an sysadmin to the SSMS collapse the security folder in the login folder right click on your particular login which is locked select the properties option.you see a select page pane.in the select page pane select the status and you see the status pane in that at the bottom you find an option login is locked out.check this option and the login which is locked gets unlocked.

Shane Miller SSC Eights! Points: 827 More actions · Answer 10

I've just been jumping through hoops as another user locked his id. I found the following method to work: Uncheck the "Login is locked out" and uncheck "Enforce Password Policy". Click Ok. Then, go back into the id, change the id's password to a temporary one and enable the password policy, allowing the user to change the password upon initial login. Ridiculous, yes, but it works. :rolleyes:

jaybaylow SSC Enthusiast Points: 177 More actions · Answer 11

Try the following.

ALTER LOGIN [login name] WITH CHECK_POLICY = OFF;

go

ALTER LOGIN [login name] WITH CHECK_POLICY = ON;

go

Gane SSC Journeyman Points: 78 More actions · Answer 12

in my case i got the message :Login failed for user 'Config_Admin'.

i see the lockoutoption is unchecked . any other idea how to unlock the account.

Steve Jones - SSC Editor SSC Guru Points: 736063 More actions · Answer 13

How are you logging into SQL Server (which account) and what are you running to unlock the account?

Kenneth.Fisher SSC-Insane Points: 20396 More actions · Answer 14

This is probably a stupid question but are you going to the status tab and checking that it is enabled and the locked out check box is unchecked?

Kenneth

Kenneth FisherI was once offered a wizards hat but it got in the way of my dunce cap.--------------------------------------------------------------------------------For better, quicker answers on T-SQL questions, click on the following... http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]For better answers on performance questions, click on the following... http://www.sqlservercentral.com/articles/SQLServerCentral/66909/[/url]Link to my Blog Post --> www.SQLStudies.com[/url]