Saturday, September 29, 2012

login failed for user ‘rob’ reason the account has expired



Promoting this error message my application has stopped working.The reason for that is expiration of the user which i have use to connect to sql server.later on i have investigate the user account in sqlserver and identified the root cause for that.

when i was creating the user i have checked the Enforce Password Expiration Check


Finally i uncheck the check and changed the password its work fine