IIS 6 passing server rather than user security profile to SQL Server

C

cfs

We are developing a web app using II6, ASP .Net 2.0 on a Win2003 box.
We are using VS2005 and building for .Net 2.0 framework.

We set IIS up to use integrated security. However when I access the
application through IE, it cannot connect to the server. When I check
the SQL Server logs, I see a failed attempt to login by <domain
name>\<web server name>. It looks like it is using the credentials
under which the web server is running.

The desired behavior is to use the profile of the domain user who is
using IE.

When I give <domain name>\<web server name> explicit access to the SQL
Server DB it, *can* connect.

This reeks of a misconfiguration. What could we be doing wrong?

TIA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Impersonation with SQL Server SSPI 3
IIS integrated windows authentification suddenly failes for some ? 3
Is the Certficate I "see" from my IE Broswer the "actual " server certificate ? 1
Connecting from dll to SQL Server via Integrated Security. 4
Server Security 1
Access to remote SQL server 14
ASP.Net/SQL Server Authentication 1
Access 2007 Application for Reports Only – SQL Server Security 3

Top