CODEWITHSUNDEEP
c#visual-studioiisiis-expressiis-8
Jake Steffen
Jake Steffen

Reputation: 415

App runs in VS iis express but not in IIS 8

I am having an interesting issue with IIS 8. I can run the app just find. However after triggering a sql query I get the dreaded "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'".

The real kicker to all of this is that when I run in IIS Express with Visual Studio 2013 it works fine.

IIS Authentication Settings

Web.Config: 

<system.web>
    <authentication mode="Windows" />
    <identity impersonate="true" />
    <authorization>
      <deny users="?" />
    </authorization>
</system.web>

Any/All help is appreciated!

Upvotes: 0

Views: 1557

Answers (2)

Jake Steffen
Jake Steffen

Reputation: 415

Thanks everyone for the help.

What ended up happening is that we just used a local sql account.

We are going to use AD to control who has access to the page.

Using the <deny roles="DOMAIN\Domain Users"/>

option in web config file.

Upvotes: 0

Connor Christie
Connor Christie

Reputation: 41

Make sure the account that is running the app pool in IIS has access to SQL server. If that doesn't work then try changing the account that the app pool is running under to like NetworkService or LocalService and see if that has any effect.

Also try changing some of the other app pool settings in the "Advanced Settings..." dialog such as the managed pipeline mode and enable 32-bit applications.

Upvotes: 1

Related Questions