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

Query to determine if Enforce Password Policy is on Expand / Collapse
Author
Message
Posted Thursday, September 6, 2007 2:43 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, October 9, 2008 10:58 AM
Points: 111, Visits: 66
I think this is only relevant to SQL Server 2005, but I would like to write a query to determine is the Enforce Password Policy is on...what table is this stored in? Do any of you have a query that already does this. Thanks
-Kyle
Post #397068
Posted Thursday, September 6, 2007 2:53 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 5:47 AM
Points: 6,266, Visits: 2,029
select name, is_policy_checked
from sys.sql_logins
--where name ='LoginName'




* Noel
Post #397073
Posted Thursday, September 6, 2007 2:55 PM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, October 9, 2008 10:58 AM
Points: 111, Visits: 66

Is it a correct assumption that the password policy is new to 2005?

-Kyle

Post #397074
Posted Thursday, September 6, 2007 2:56 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 5:47 AM
Points: 6,266, Visits: 2,029
YES



* Noel
Post #397076
Posted Friday, September 7, 2007 7:46 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Thursday, October 9, 2008 10:58 AM
Points: 111, Visits: 66
select name, is_policy_checked
from sys.sql_logins

-When I use this query, it doesn't pick up the windows authenticated users.
-Kyle
Post #397269
Posted Friday, September 7, 2007 12:07 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 5:47 AM
Points: 6,266, Visits: 2,029
Windows users are *always* bound by windows password policies




* Noel
Post #397387
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse