I cannot deploy an SSIS Package from Visual Studio 2019 to SSIS in Azure Data Factory. My Azure Data Factory already exists. I can deploy using SSMS and can even execute the SSIS package on Azure. I cannot however, Deploy from Visual Studio to the SSIS-IR in Data Factory. This is the prefered method of deployment by our developers.
Here is how the error is produced:
Right-Click the package in Solution Explorer in Visual Studio 2019.
Select Deploy Package.
Select SSIS in Azure Data Factory
Provide the server name - **.database.windows.net
Authentication: Sql Server Authentication
Provide Login/Password
Click Connect
I receive this error:
List item
"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No such host is known.) (.Net SqlClient Data Provider)"
I use a VPN to connect to this server. I can connect to this server using MS SQL Server Management Studio. So I definitely have connectivity while connected to the VPN.
Do we need to open any additional ports on the SQL Server **.database.windows.net to support deploying from Visual Studio 2019?
Any other ideas what could be the cause?
Thanks.