Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,629 questions
SSIS - Problem connecting to Azure Sql Server Managed Instance
![](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(22.400000000000002, 8%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Rsam111
1
Reputation point
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.
{count} votes
-
Alfredo Revilla - Upwork Top Talent | IAM SWE SWA 27,436 Reputation points2020-09-18T19:38:23.913+00:00 @Rsam111 can you describe the steps/resources followed/involved to connect to Azure SQL Server Managed Instance from the SSIS?
-
Alfredo Revilla - Upwork Top Talent | IAM SWE SWA 27,436 Reputation points
2020-09-18T22:11:31.733+00:00 Maybe this form?
Sign in to comment