Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Unable to unlock user account in SQL server 2005 Expand / Collapse
Author
Message
Posted Monday, November 10, 2008 1:22 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, April 11, 2014 8:15 AM
Points: 71, Visits: 43
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.
Post #600167
Posted Friday, January 22, 2010 9:19 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, October 3, 2012 8:33 AM
Points: 125, Visits: 178
Try the following.

ALTER LOGIN [login name] WITH CHECK_POLICY = OFF;
go

ALTER LOGIN [login name] WITH CHECK_POLICY = ON;
go
Post #852133
Posted Thursday, December 30, 2010 12:11 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, August 6, 2014 10:51 PM
Points: 36, Visits: 50
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.
Post #1041117
Posted Thursday, December 30, 2010 12:19 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Saturday, December 20, 2014 3:11 PM
Points: 31,368, Visits: 15,837
How are you logging into SQL Server (which account) and what are you running to unlock the account?






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1041121
Posted Wednesday, January 5, 2011 1:39 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 10:32 AM
Points: 3,467, Visits: 1,842
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 Fisher
I strive to live in a world where a chicken can cross the road without being questioned about its motives.
--------------------------------------------------------------------------------
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Link to my Blog Post --> www.SQLStudies.com
Post #1043332
Posted Tuesday, March 20, 2012 8:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 4, 2012 11:20 AM
Points: 1, Visits: 5
Kenneth.Fisher (1/5/2011)
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



Thanks!
Post #1269592
Posted Friday, April 11, 2014 5:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 11, 2014 6:38 AM
Points: 1, Visits: 1
Try this Tool to reset SQL Password relaibly from here :- http://www.sqlmdfviewer.org/sql-password-recovery-freeware.html
Post #1560826
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse