Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

NT AUTHORITY\IUSR user issue Expand / Collapse
Author
Message
Posted Friday, June 4, 2010 3:29 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 26, 2014 2:36 PM
Points: 189, Visits: 688
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.
Post #933074
Posted Friday, June 4, 2010 3:45 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, November 14, 2014 4:49 PM
Points: 1,093, Visits: 1,175
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
Post #933079
Posted Monday, June 7, 2010 8:03 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 26, 2014 2:36 PM
Points: 189, Visits: 688
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.
Post #933524
Posted Monday, June 7, 2010 5:11 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, November 14, 2014 4:49 PM
Points: 1,093, Visits: 1,175
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
Post #933734
Posted Monday, February 3, 2014 10:49 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, July 12, 2014 5:55 AM
Points: 1, Visits: 13

Hi,

Thanks for your solution, its works fine...!
Post #1537614
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse