Databases
StackOverflow2013
Postsdbo
POweb app losing credentials when calling database
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POweb app losing credentials when calling database
    primarykey
    data
    text
    <p>I have a Web server and a separate database server. This is an internal web page only so is not on an external DMZ. IIS Settings for the web site authentication are Anonymous Disables, ASP.Net enabled, forms disabled, windows enabled.</p> <p>If I get the current user name using the below code on the web page it renders correctly from the client machine:</p> <pre><code>lblUserName.Text = System.Web.HttpContext.Current.User.Identity.Name.ToString() </code></pre> <p>When I run the web site locally on the web server the database connection works perfectly, but when I run from the client machine for some reason it loses the current user and tries to use anonymous credentials to connect rather than passing through the current windows credentials. The error message presented is: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. (when making the DB connection).</p> <p>My DB connection string is set in web.config and has Integrated Security="SSPI". In my web.config I also have authentication mode="windows" and identity impersonate = "true".</p> <p>Not sure if it makes a difference (I am not great at IIS, having usually had someone else in the company deal with this, and where I am now there is no-one who really seems to know what they are doing with IIS) but in IIS on the App Pool I have the advanced settings process model identity set to 'ApplicationPoolIdentity' and load user profile set to True. I have also tried, on advice from Tim (thank you), using a known used instead of the ApplicationPoolIdentity, and have entered the credentials used to run the SSRS reports so I know they have the right permissions, but still get the same error.</p> <p>Am I missing something really obvious in IIS or in the web.config which is needed to pass through the current user credentials?</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USElatesummer
    1. USElatesummer
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COYou either need to set the app pool in IIS to run under an account that has permissions to log-in to the SQL server, or pass a user name and password in your configuration file. I'd suggest the former.
      singulars
      1. POweb app losing credentials when calling database
      1. USTim
    2. COOk, thank you. I was really hoping to use the windows credentials so that I could capture which user was calling what in the DB level but I will look at other ways to achieve this.
      singulars
      1. POweb app losing credentials when calling database
      1. USElatesummer
    3. COI have set this app pool identity to a user with access but I still get the error at the client computer of the web app trying an anonymous logon.
      singulars
      1. POweb app losing credentials when calling database
      1. USElatesummer
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload