Shulou(Shulou.com)06/03 Report--

This article mainly introduces how to solve the problem of asp.net user ASPNET login failure, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

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 'XXXASPNET' login failed.

After migrating the website today, I found this problem. After groping, it is found that the reason is that the role of our login database does not have enough permissions on the database.

Solution:

1. Open the database enterprise manager, and then select database-security-find the 'XXXASPNET'' that just reported the error-right-click "Properties"

two。 Select the "user mapping" option-select the database we want to access

3. Don't click OK first-then select which database we just selected. Select "db_owner" permission in "Database role membership" below.

At this point, the problem is solved.

Thank you for reading this article carefully. I hope the article "how to solve the problem of ASPNET login failure of asp.net users" shared by the editor will be helpful to everyone. At the same time, I also hope that you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.