Sample Header Ad - 728x90

Unable to connect to Azure SQL MI from on-prem SSIS package

0 votes
1 answer
84 views
I am trying to connect to Azure SQL MI from on-prem SSIS package. However, I am unable to connect even with MS Oledb driver 18. I did udl connection test to Azure SQL MI from on-prem ssis server with MSOLEDBSQL driver with "ActiveDirectoryIntegrated" as Authentication and it worked.However, it does not work when trying to setup new connection manager with same connection property from visual studio. How can I connect to Azure SQL MI from on-prem SSIS using "ActiveDirectoryIntegrated" authentication?
Asked by SqlDBA (171 rep)
Jan 8, 2025, 02:01 PM
Last activity: Jan 8, 2025, 10:16 PM