How do i Set Password Expiration days for a SQL Login

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » How do i Set Password Expiration days for a...

How do i Set Password Expiration days for a SQL Login

Rate Topic

Display Mode

Topic Options

Author

Message

haichells

Posted Friday, December 21, 2007 12:09 AM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, November 14, 2012 6:42 AM
Points: 78, Visits: 375

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

ChiragNS

Posted Friday, December 21, 2007 4:45 AM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365, Visits: 1,825

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

haichells

Posted Sunday, December 23, 2007 10:40 PM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, November 14, 2012 6:42 AM
Points: 78, Visits: 375

Hi,

Thanks for your response. How can i set the Interval for Password Expiration.

Post #436083

ChiragNS

Posted Sunday, December 23, 2007 11:05 PM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 5:02 AM
Points: 2,365, Visits: 1,825

Hi

check this out

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

"Keep Trying"

Post #436088

haichells

Posted Sunday, December 23, 2007 11:38 PM

SSC Journeyman

Group: General Forum Members
Last Login: Wednesday, November 14, 2012 6:42 AM
Points: 78, Visits: 375

Hi,

Thanks a lot!

Post #436096

GilaMonster

Posted Monday, December 24, 2007 1:30 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 4:11 PM
Points: 37,741, Visits: 30,020

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

mike.stone.email

Posted Tuesday, October 05, 2010 8:18 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, October 07, 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

Oliiii

Posted Tuesday, October 05, 2010 8:32 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 8:17 AM
Points: 197, Visits: 688

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 »

Permissions