Error: 18487, Severity: 14, State: 1
Login failed for user ‘loginname’. Reason: The password of the account has expired.
Condition : The password for the login used in your application has expired. SQL Server 2005 introduced ‘Enforce password policy’ and ’Enforce password expiration’ configurations which use the local policies for password length, complexity and expiration…! Continue reading
Filed under: ADMINISTRATION, INSTALLATION, MCDBA, MCITP, Quick DBA | Tagged: enforce password policy, error 18487 Login failed for user loginname, Get Password Expiration Date, Local Security Policy, LOGINPROPERTY DaysUntilExpiration PasswordLastSetTime isexpired ismustchange, Reason The password of the account has expired | Leave a comment »