It is not possible to create a connection string so that you can open a connection to the mssql server using other Windows user credentials. It seems that you are limited to specifying either the sql server account, or you do not specify any credentials at all that pass through the current set used in the domain.
What workarounds are effective ways around this limitation?
A bit of background:
The company I am deploying would like to set up Windows credentials for every application accessing shared databases. This works well for background tasks like daemons, but for desktop applications this seems a bit complicated.
I was asked NOT to skip user accounts in the database, but instead to transfer the set of Windows accounts reserved for the application itself ... not the sql server credentials, but the account in the domain for the application.
I considered using Runas to run an application (written in Python) using this Windows account of the application.
Maybe someone out there can suggest a better way?
source
share