SSIS - Problem connecting to Azure Sql Server Managed Instance

Rsam111 1 Reputation point
2020-09-16T08:28:27.557+00:00

Hi All

I have an issue and unable to figure out for quite some time. I have been trying to connect to Azure Sql Server Managed Instance from a Sql Server Integration Package (SSIS). The type of access provided is Multi factor authentication (MFA).

I'm running the package in VS 2017 and have Sql Server 18.2 installed. During SSIS Package execution, the error is as below. I'm using ADO.Net Connection Manager

"Cannot find an authentication provider for Active Directory Interactive"

But I'm able to connect to Azure Sql Server Via SSMS.

Any help would greatly be appreciated.

Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
18,578 questions
{count} votes