asked on

how do I use the windows user in a webservice?

I have a project with a webserice. I was using a hardcoded username in my connection string. My tables in my db have a createdby and modified by field. I don't pass them in, since the default value is (suser_sname()). Basically it would fill in the username for me. It worked on my dev machine, but not on the server.

I changed the iis settings to use Integrated Windows. When I run my app, it says I can't connect to the db
for user "mydoman\the computer name the webservice is running on". How do I get the webservice to use the username of the person using the app?

raterus

Turn back on Integrated Windows Authentication, this is what you need to use.

Is your DB on a different computer than your webserver? If that is the case, you need to enable Delegation on your webserver. This is the "ok" in active directory for the webserver to pass along the credentials of your user to another server.

http://support.microsoft.com/default.aspx?scid=kb;en-us;810572

jackjohnson44

ASKER

My db is on a different server. I have active directory and tried the suggestion in the link that mentioned but it looks like the webservice is trying to use it's computer name as the username in sql server. Do you have any more advice?

ASKER CERTIFIED SOLUTION

raterus

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial