Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / General / Security / July 2006

Tip: Looking for answers? Try searching our database.

User Account Settings/Properties (question)

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
SteveS - 20 Jul 2006 21:59 GMT
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.
Sue Hoegemeier - 27 Jul 2006 18:07 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.