User jb51net Login Failed. Cause: the password of the Account must be changed,

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.