sql 2005 Login failed for user '登录名'. Reason: The password of the account has expired.

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

今天网站访问报错，查看日志 是上述提示信息，原来是sql 2005的强制密码策略的问题。创建登录的时候默认设置如下

把enforce password policy 复选框取消即可了。