This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 64%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHR%3C/text%3E%3C/svg%3E)
We are trying to connect to a SQL DB from an SSIS package. We were asked to use Service account (AAD Account) for the connection. We are prohibited from logging into a machine/VM using service accounts (login restricted).
The only other option we have is using a SQL ID. I do not want to use SQL ID as it can be a channel for breach.
Is there any way we can establish the connection? Is there a way I can use Service account credentials without logging onto the machine/VM?
Hi @Harsha Reddy Dubba ，
As far as I know, AAD account is only used to connect to Azure SQL Database.
If you want to connect to SQL DB on pre in SSIS package, you could only use SQL Server authentication or Windows authentication like shown below.
Could you please have a check of the issue so that we could do more analysis.
@ZoeHui-MSFT Thank you for the response.
Is there a way I can pass other user account for the Windows Authentication and not my or any other logged-in user credentials?
Hi @Harsha Reddy Dubba ，
You can not pass other user account for the Windows Authentication.
If you are concerned about security, you may use ProtectionLevel which is an SSIS package property that is used to specify how sensitive information is saved within the package and also whether to encrypt the package or the sensitive portions of the package.
securing-your-ssis-packages-using-package-protection-level
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
Hi @Harsha Reddy Dubba ,
It looks like that SSIS package is using Native OLEDB Provider 11.0
It is deprecated.
I would suggest switching to the Microsoft OLE DB Driver for SQL Server.
Check it out here: oledb-driver-for-sql-server
Microsoft OLE DB Driver can use Azure Active Directory authentication: Azure Active Directory authentication
Please see below.
