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

How do i Set Password Expiration days for a SQL Login Expand / Collapse
Author
Message
Posted Friday, December 21, 2007 12:09 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 10:20 AM
Points: 83, Visits: 391
Hi,

I am creating a Login in code while Installation. I have a requirement now that Login should have Password expiration policy. How do i set this? Please help.

Thanks

Chelladurai
Post #435492
Posted Friday, December 21, 2007 4:45 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 4:53 AM
Points: 2,366, Visits: 1,844
Hi

If you are creating logins from SSMS you check the checkbox which says "Enforce password policy".

If you are using a script use the CHECK_EXPIRATION option of the "Create login" statement.



"Keep Trying"
Post #435562
Posted Sunday, December 23, 2007 10:40 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 10:20 AM
Points: 83, Visits: 391
Hi,

Thanks for your response. How can i set the Interval for Password Expiration.
Post #436083
Posted Sunday, December 23, 2007 11:05 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 4:53 AM
Points: 2,366, Visits: 1,844
Hi

check this out

http://www.mssqltips.com/tip.asp?tip=1088



"Keep Trying"
Post #436088
Posted Sunday, December 23, 2007 11:38 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, July 15, 2014 10:20 AM
Points: 83, Visits: 391
Hi,

Thanks a lot!
Post #436096
Posted Monday, December 24, 2007 1:30 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 3:14 AM
Points: 42,460, Visits: 35,520
As far as I know, if the SQL Server is on a domain, the domain's password policy is the one that's enforced. If the server's not on a domain, then the local password policy is enforced.


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #436114
Posted Tuesday, October 5, 2010 8:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 7, 2010 3:20 AM
Points: 4, Visits: 5
Hi! I just read this thread (3 years later). Does anybody know how I can get a notification that someone's password will expire in another n days? or to trigger an SP to take action n days before expiry? I'm assuming an SQL server login with Enforce Password Policy and Enforce Password Expiration. Thanks in advance ...
Post #998385
Posted Tuesday, October 5, 2010 8:32 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 7:21 AM
Points: 206, Visits: 764
Use the LOGINPROPERTY method to find all the infos you need (http://msdn.microsoft.com/en-us/library/ms345412.aspx).
Post #998407
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse