Exception details: System. Data. SqlClient. SqlException: User 'nt AUTHORITY \ iusr' logon Failure solution, ntauthorityiusr
Recently. net project, because I used to do a lot of java, so. net is not familiar with, after the project is completed deployed to the IIS server, there are many problems, one of the above, if there is time, in the update of other problems solution!
Exception details: System. data. sqlClient. sqlException: User 'nt AUTHORITY \ iusr' logon failed or exception details: System. data. sqlClient. sqlException: User 'sa 'logon failed,
For various methods, such as web. if the user name and password configured in config are correct, or if windows Identity Authentication in IIS manager is enabled, try the following method.
(Note: If the IIS service of win10 Home edition control panel is not installed with windows identity authentication, you must upgrade the professional edition or above.
My solutions are as follows:
I am using Sqlserver 2015. After connecting to the database, double-click NT AUTHORITY \ SYSTEM in security-> Logon Name and set its attributes.
In the following user ing, select the database you want to connect to (my database is Teacher), and then check db_owner at the bottom to confirm.
If sa fails to log on, make sure that IIS's windows identity authentication is enabled. If you can't solve it, don't draw circles and curse me. Continue searching. After all, there is no problem with one of my two different computers, and the other is the ton problem! The exception persists.