1
I have a Webservice application running on IIS, but how much I try to consume from this error:
System.Exception: Login failed for user 'IUSR NT AUTHORITY'
I tried to add this user in the database, but I can’t, from this error:
The Windows NT AUTHORITY IUSR user or group was not found. Check the name again.
When I try to add any other user:
How do I fix this? I’m using Windows 8 and IIS 8
3
Go to the IIS Application Pool that runs your application and change the user to "Networkservice".
Application Pools -> Right click on chosen -> Advanced Settings -> Identity
From there in Sqlserver Management Studio, adds the user "NT AUTHORITY NETWORK SERVICE"
Where does the NT AUTHORITY IUSR come from ?
does not have this user in SQL SERVER. It has the network service, but when I add, it gives the same error that is described in the question
Already changed in IIS ?
@gmsantos changed what at IIS?
"Go to the IIS Application Pool that runs your application and change the user to "Networkservice"."
Browser other questions tagged c# sql-server web-service
You are not signed in. Login or sign up in order to post.
Have you tried adding this user through the root account of SQL server ? "sa" ? Maybe you’re not getting the permission in your account.
– Érik Thiago
@Érikthiago already tried yes, I am logged in with her! And I also ran the program as system administrator
– Leonardo
Look @Exception according that link the error may be happening because the computer name may be wrong. Have you looked if the names are right? Maybe this user exists but on another machine.
– Érik Thiago