Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Monday, April 25, 2016 9:28 AM
Points: 97, Visits: 446
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: Wednesday, May 25, 2016 1:11 PM
Points: 2,365, Visits: 1,865
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: Monday, April 25, 2016 9:28 AM
Points: 97, Visits: 446
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: Wednesday, May 25, 2016 1:11 PM
Points: 2,365, Visits: 1,865
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: Monday, April 25, 2016 9:28 AM
Points: 97, Visits: 446
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 @ 7:34 AM
Points: 44,911, Visits: 42,942
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, MVP, M.Sc (Comp Sci)
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: Monday, June 8, 2015 7:12 AM
Points: 206, Visits: 777
Use the LOGINPROPERTY method to find all the infos you need (http://msdn.microsoft.com/en-us/library/ms345412.aspx).
Post #998407
Posted Tuesday, April 12, 2016 8:34 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Monday, July 4, 2016 6:50 PM
Points: 156, Visits: 463
Thank you, the link worked for me.

Jeff
Post #1777048
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse