Post reply

NT AUTHORITY\IUSR user issue

  • June 4, 2010 at 3:29 pm

    #233336

    I am trying to finding the user IUSER after looking at the following article.

    Login failed for user 'NT AUTHORITY\IUSR'

    If you encountered this error while running your published website or web service in IIS7:

    Message: Sys.WebForms.PageRequestManagerServerErrorException: Cannot open database "[DB_NAME]" requested by the login. The login failed.

    Just follow these simple steps to solve the problem.

    1. Open SQL Server Management Studio.

    2. On the left menu, expand Security then Logins. Check if 'NT AUTHORITY\IUSR' exists. If not then that is the cause of the problem.

    3. Right-click on Logins then click New Login...

    4. On the General page, click Search...

    5. On the next popup window, click Advanced...

    6. Then on the following window, click Find Now and find IUSR on the Search Results. Then click OK.

    Here I am not able to find this user. So can I add this user manually?

    Thanks.

  • June 4, 2010 at 3:45 pm

    #1176739

    Generally I think it's better to create a specific account that you want to use for your web application to access your SQL Server rather than using the built-in machine account for anonymous IIS access.

    └> bt


    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • June 7, 2010 at 8:03 am

    #1177087

    Yes, I created an sqlserver login to access the application. I was able to query data from all the tables but not able to access one table and getting this error.

    Thanks.

  • June 7, 2010 at 5:11 pm

    #1177261

    If you're getting the error "Login failed for user 'NT AUTHORITY\IUSR'", then your app is not using the account that you set up. It's passing along the user credentials from IIS, which in the case of allowing anonymous access is IUSR.

    Other than making sure the account you set up has the appropriate access, this isn't really a SQL question. It's a matter of fixing your connection properties in your app.

    └> bt


    Forum Etiquette: How to post data/code on a forum to get the best help[/url]

  • February 3, 2014 at 10:49 pm

    #1685733

    Hi,

    Thanks for your solution, its works fine...!:-)

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply