Hello,
I am trying to configure a web service to connect to SQL Server. While I was testing, I was running the web service on my local machine with a version of SQL Server Developers on my machine, and I was connecting using a Trusted Connection.
Now I am wanting to move this to production, and I have done some reading about the best way to connect to SQL Server with a web service. I am authenticating on a Windows Domain throughout my application, web service, and IIS using a Windows Group. I would like that Windows group to also control my authentication with SQL Server.
I can't seem to be able to connect to SQL Server using impersonation. I have a login set up on SQL Server of my Group Name. How do I formulate a connection string that uses the impersonated user name?
Thanks.