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

password expiration and password policy Expand / Collapse
Author
Message
Posted Tuesday, November 18, 2008 2:22 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, October 24, 2014 3:21 PM
Points: 266, Visits: 716
Hi All,

How would be able to query any of the system table to check whether the SQL Log has the enforce password policy and enforce password expiration check boxes on/off.

Can some one suggest me the way to find that ? As I have more than 20 login in 50 servers and it will be tedious to do one after the other.

Thanks,
Ganesh



Post #604703
Posted Tuesday, November 18, 2008 2:31 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Friday, November 14, 2014 7:14 AM
Points: 6,625, Visits: 1,876
This is will tell you what SQL Server logins have either turned off:

SELECT name 
FROM sys.sql_logins
WHERE is_policy_checked = 0
OR is_expiration_checked = 0



K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #604708
Posted Tuesday, November 18, 2008 3:22 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, October 24, 2014 3:21 PM
Points: 266, Visits: 716
Thanks....I missed those columns.

Thanks for your help



Post #604740
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse