User jb51net Login Failed. Cause: the password of the Account must be changed,
"/" Indicates a server error in the application. User 'jb51net' Login Failed. Cause: the password of the Account must be changed.
Note: An unhandled exception occurs during the execution of the current Web request. Check the stack trace information for details about the error and the source of the error in the code.
Exception details: System. Data. SqlClient. SqlException: the user 'jb51net' fails to log on. Cause: the password of the Account must be changed.
Source error:
An unhandled exception is generated during the execution of the current Web request. You can use the following exception stack trace information to determine the cause and location of the exception.
Stack trace:
[SqlException: the user 'jb51net' fails to log on. Cause: the password of the Account must be changed.] System. data. sqlClient. connectionPool. getConnection (Boolean & isInTransaction) + 552 System. data. sqlClient. sqlConnectionPoolManager. getPooledConnection (SqlConnectionString options, Boolean & isInTransaction) + 372 System. data. sqlClient. sqlConnection. open () + 384 BoojobNet. components. systems. system_Parameter_Title (String Subid) BoojobNet. person. index. efb3613fecfd25e8 () BoojobNet. person. index. de97676d01739ced (Object e0292b9ed559da7d, EventArgs fbf34718e704c6bc) System. web. UI. control. onLoad (EventArgs e) + 67 System. web. UI. control. loadRecursive () + 35 System. web. UI. page. processRequestMain () + 750:
SQL Server 2005 and 2008 user security mechanisms have been upgraded.
When creating a user, if you select SQL Server Authentication, three optional policies will be added,
1. enforce a password policy,
2. Force password expiration,
3. the user must change the password upon next login
Are these policies similar to windows server user policies?
If you remove these policies and the created users are directly used for the website, the following error occurs: cause: the password of this account must be changed.
It is easy to correct this error:
1. Use Management Studio to change the user password (You need to log in with the created account password. You cannot log in with windows identity verification and then modify it. If you cannot log in, take the next step)
2. log on to sa or windows and re-create a new user name (it must be a new user name, and all the three policy options of the password cannot be used before, in this way, the user password will not be changed. You can directly access it.
In addition, the system login password and Database Password cannot be the same.
If still not recommended reference this article: http://www.bkjia.com/article/70809.htm