Connection String to connect a SQL Server using another windows account

Question

How to create a SQL connection string to connect a SQL Server instance using another Windows account? I need to provide the Windows user name (not SQL Server login) and password and force the server to use this credentials while creating a connection.

Integrated Security=SSPI picks my PC user account and password

Is there a way to accomplish this?

Please advise.

Thanks, KihtraK

Answer 1

Yes, and quite trivial.

• Do NOT put username and password into your connection string.
• Use username and apssword to impersonate the other user How to specify the user in a C# Thread
• Connect from that thread.

Finished. Internal security will now work with the impersonated user. Impersonation is explicitly done to NOT have to deal with username and password.