Shulou(Shulou.com)05/31 Report--

This article is about how to solve the problem of user jb51net login failure in web, the editor thinks it is very practical, so I share it with you to learn. I hope you can get something after reading this article, without saying much, let's take a look at it.

Server error in "/" application. Login failed for user 'jb51net'. 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 more information about the error and the source in the code that caused the error.

Exception details: System.Data.SqlClient.SqlException: user 'jb51net' login failed. Reason: the password for this account must be changed.

Source error:

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. Stack trace:

[SqlException: user 'jb51net' login failed. Reason: the password for this account must be changed.] System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) + 552System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection (SqlConnectionString options, Boolean& isInTransaction) + 372System.Data.SqlClient.SqlConnection.Open () + 384BoojobNet.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 () + 750reasons and solutions are as follows: Sql Server 2005, 2008 user security mechanism has been upgraded.

When creating a user, if you choose Sql Server authentication, three optional policies will be added: 1, to enforce the password policy, 2, to force the password to expire, and 3. The user must change the password when logging in next time. Are these policies similar to the windows server user policy? When you create a user, these policies are ticked by default, and if you remove these policies and use the created user directly to the site, there will be an error mentioned in the title: the password of the account must be changed. It is very simple to correct this error: 1. Change the user's password through Management Studio (you need to log in with the account password you created. You cannot change it after logging in with windows authentication. If you cannot log in, take the next step) 2. Log in to sa or windows to create a new user name (it must be a new user name, none of the previously used ones can be used). And cancel all three password policy options, so that there will be no problem of changing the user's password, and you can access it directly.

In addition: the system login password and database password cannot be the same.

The above is how to solve the problem of jb51net login failure of users in web. The editor believes that there are some knowledge points that we may see or use in our daily work. I hope you can learn more from this article. For more details, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.