Sql-server – ODBC connection for Active Directory user who doesn’t log in to Windows

active-directoryauthenticationsql server

Do you think it is possible to create a SQL Server ODBC Connection for an Active Directory user who doesn't log in to Windows.

Ideally this type of users will be used in a batch process. So, another person logs in and creates a batch process and runs it with another user.

Note: I don't want to enable SQL Server authentication. Instead would like to use Active Directory.

Best Answer

Although you cannot login to SQL Server unless you use either a SQL Server Login or a Windows Account with permissions to connect to the SQL Server, you could create a low-permission user that can EXEC certain stored procedures. Those stored procedures could then contain code that switches into the context of another, more highly privileged account. 

EXECUTE AS Login = 'DOMAIN\User';
SELECT * FROM sys.databases;
REVERT

Read more about EXECUTE AS on MSDN.

Related Question