>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.
You do not. You still use trusted_connection. In SQL server however you define groups and/or users who have rights.
Cetin