Friday, January 18, 2013

Logon Login failed for user 'login_name'. Reason: The password of the account has expired.


The password for user which is used for application has expired.

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

Below parameters can be reviewed and changed to state how SQL Server uses configurations. For reviewing and changing the sql server security configuration, please follow below steps.

Step 1: Open Start menu
Step 2: Click All Programs
Step 3: Click Administrative Tools
Step 4: Click Local Security Policy



Step 5 : After clicking security policy you can find something like below popup box, here you can change "enforce password policy" and "maximum password age" as per your application functionality.



For enabling these password policy to any individual login in sql server, then follow below steps.

Step 1 :  Connect to Sql Server management studio.
Step 2 :  Expand securities.
Step 3 :  Expand Logins.
Step 4 : Right click on desired login and click properties.
Step 5 : The property box looks like below and here I have highlighted with red mark where you can actually check / unchecked these two options as per your requirement to implement above two password policies. 



The password of the account has expired. SQL Server Login Properties to Enforce Password Policies. Enforce Password Policies and Password Expiration for SQL Server. Login failed for user 'UserName'. Reason: The password of the account has expired. The password of the account has expired. Logon Login failed for user 'loginname'. Reason: The password of the account has expired. . Login failed for user 'DOESNT EXIST'.. Enforce Password Policies and Password Expiration for SQL Server Logins. sql server 2012. sql server 2000. sql server 2008 r2. sql server 2005.

0 comments:

Post a Comment