Learn more about SQL Server tools

   
   























Latest from MSSQLTips














SQL Server Login Properties to Enforce Password Policies and Expiration

MSSQLTips author Jeremy Kadlec By:   |   Read Comments (1)   |   Related Tips: More > Auditing and Compliance

Problem
For some reason your web site is up, but none of the data is loading on your web site?  Is your SQL Server up and running?  Are you able to access the data with either your Windows account or sa?  What does your SQL Server error log report?  What is the culprit?

Solution
Chances are if the SQL Server error log reports messages of:

Logon Error: 18487, Severity: 14, State: 1.
Logon Login failed for user 'loginname'. Reason: The password of the account has expired. [CLIENT: <named pipe>]

Then the password for the login used in your web application has expired.  SQL Server 2005 introduced 'Enforce password policy' and/or the 'Enforce password expiration' configurations which use the local policies for password length, complexity and expiration.  Depending on how Active Directory, the local policies and your rights are setup, these parameters can be reviewed and changed to dictate how SQL Server uses configurations.

Where can I find the login properties?

  1. Open Management Studio and the object browser.
  2. Navigate to the Security | Logins folder.
  3. Find the login you are interested in reviewing.
  4. Right click on the login and select 'Properties' option.
  5. On the General tab, review the 'Enforce password policy' and the 'Enforce password expiration' configurations.

Where can I find the password policies?

Navigate to Start | All Programs | Administrative Tools | Local Security Policy and to review the local policies on the machine.

Next Steps



Last Update: 10/18/2006





About the author
MSSQLTips author Jeremy Kadlec
Since 2002, Jeremy Kadlec has delivered value to the global SQL Server community as an Edgewood Solutions SQL Server Consultant, MSSQLTips.com co-founder and Baltimore SSUG co-leader.

View all my tips
Related Resources


print tip Print  
Become a paid author


Learn more about SQL Server tools








Post a comment or let the author know this tip helped you.

       All comments are reviewed, so stay on subject or we may delete your comment.

*Name   *Email Notify for updates



       Note: your email address is not published. Required fields are marked with an asterisk (*)


Get free SQL tips:

*Enter Code refresh code     



Tuesday, July 08, 2014 - 11:26:07 AM - shruthi Read The Tip

Hello,

 

The Maximum password age is 42 days .Does it mean the password expires in 42 days

 

Thanks,

shruthi

 




 
More SQL Server Solutions



 

Follow

Get Free SQL Tips

Twitter

LinkedIn

Google+

Facebook

Pinterest

RSS

Learning

DBAs

Developers

BI Professionals

Careers

Q and A

Today's Tip

Resources

Tutorials

Webcasts

Whitepapers

Tools

Search

Tip Categories

Search By TipID

Authors

Community

First Timer?

Pictures

Free T-shirt

Contribute

Events

User Groups

Author of the Year

More Info

Join

About

Copyright

Privacy

Disclaimer

Feedback

Advertise

Copyright (c) 2006-2015 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.