So currently my webpage is set up with windows authentication so it identifies my username when I log in.
I had my dba add me as the admin to my database stored on the sqlserver. When I try to connect from my
local box it runs fine but when I pushed it out to IIS it gave me the webserver's machine name and stated it wasn't
authorized. My next step was to add impersonation into web.config to try to pass the users credentials down to sql server
but got
Error: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
Anonymous login is turned off at IIS so im not sure why it is trying to login as anonymous.
Here is web.config code and the sql connection string below if that helps:
<configuration>
<system.web>
<authentication mode="Windows">
</authentication>
<authorization>
...
Go to the complete details ...