Server error in the ‘/’ application. User ‘jb51net’ login failed. Reason: the password for this account must be changed.
Description: an unhandled exception occurred during the execution of the current web request. Check the stack trace information for details about the error and the source in the code that caused it.
Exception details: System.Data.SqlClient . sqlexception: user ‘jb51net’ login failed. Reason: the password for this account must be changed.
An unhandled exception was generated during the execution of the current web request. You can use the following exception stack trace information to determine information about the cause and location of the exception.
[sqlexception: user ‘jb51net’ login failed. Reason: the password for this account must be changed. ] System.Data.SqlClient . ConnectionPool.GetConnection (Boolean& isInTransaction) +552 System.Data.SqlClient .SqlC onnectionPoolManager.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 causes and solutions are as follows:
The user security mechanism of SQL Server 2005 and 2008 has been upgraded.
When creating users, if SQL server authentication is selected, three optional policies will be added,
1. Enforce password policy,
2. Force password expiration,
3. The user must change the password at the next login
Are these policies similar to the user policies of Windows Server?
To create a user, these policies are checked by default. If you remove these policies and use the created user directly for the website, the error mentioned in the title will appear: Reason: the password of the account must be changed.
It’s easy to fix this mistake
1. Modify the user’s password through Management Studio (you need to log in with the created account password, you can’t log in with windows authentication, if you can’t log in, take the next step)
2. SA or windows login to create a new user name (must be a new user name, previously used can not be used), and the password three policy options are all cancelled, so that there will be no need to change the user password problem, you can directly access
In addition: system login password and database password cannot be the same.
If you still can’t, please refer to this articlehttps://www.jb51.net/article/70809.htm