how do I use the windows user in a webservice?
Posted on 2008-06-23
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?