Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raul11
Starting Member
48 Posts |
 Posted - 2011-09-10 : 07:08:13
|
| the sql login account locks out quite frequently. i check whwn entering the password. but the problem still occurs. any help apreciated |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-10 : 07:10:52
|
| it might be saving some earlier password in some of web config or other places. can you check if this is happening when you're trying to connect through an application?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
raul11
Starting Member
48 Posts |
Posted - 2011-09-10 : 07:31:51
|
| im trying to login from management studio using the sql authentication but gets locked out |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2011-09-10 : 07:39:41
|
| is the check_policy enabled for the account(s)?save the password so you don't need to type it again in ssms and risk getting it locked out again if that is the case--------------------keeping it simple... |
|
|
|
raul11
Starting Member
48 Posts |
Posted - 2011-09-10 : 08:10:09
|
| ru refering the enforce password policy checkbox. its is enabled(tick mark against it) |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2011-09-10 : 09:12:16
|
yes, either unmark it if you are unable to remember the passwords or just register the sql instance in ssms and save the login credentials  or perhaps investigate why the account(s) get locked out frequently--------------------keeping it simple... |
|
|
|
|
|
|
account locks out frequently