First let me say that I my computer is in a domain. The DC + my computer
both have strong password policy in effect and an account lockout threashold.
I have SQL 2005 express installed (mixed mode). I've created a new user and
pointed it to a test DB I have. Gave the user db_owner rights (since I'm
experimenting here). On the status section where it says "Status | SQL
Server Authentication" and has the checkbox "Login is locked out" - mine is
grayed out so I can't check or uncheck it.
How or what can I do to get it so I can check/uncheck at will? I thought
enableing a password lockout threashold on the computer itself and being
passed down from my domain controller would play a part in that..but it's
not. Any ideas?
Thanks in advance.
It's that way by design. It will be enabled when the SQL
login is locked out. You use the option to unlock SQL Logins
that have been locked where password policies are turned on
and you are running under Windows Server 2003.
If you want to change the access at will, you can change the
enabled, disabled property for the login.
-Sue
>First let me say that I my computer is in a domain. The DC + my computer
>both have strong password policy in effect and an account lockout threashold.
[quoted text clipped - 11 lines]
>
>Thanks in advance.
SteveS - 31 Jul 2006 05:48 GMT
Thanks Sue...your answer gave me exactly what I was looking for.
> It's that way by design. It will be enabled when the SQL
> login is locked out. You use the option to unlock SQL Logins
[quoted text clipped - 20 lines]
> >
> >Thanks in advance.
Sue Hoegemeier - 31 Jul 2006 17:06 GMT
No problem...glad it helped.
-Sue
>Thanks Sue...your answer gave me exactly what I was looking for.
>
[quoted text clipped - 22 lines]
>> >
>> >Thanks in advance.