Please consider support for SQL Server Application Roles which enables an application to run with its own, user-like privileges. Application Roles are activated by executing the sp_setapprole stored procedure after a connection is made and providing a password known by the application.