Cannot Deploy SSIS Package to SSIS-IR from Visual Studio 2019

Jeremiah Adams 171 Reputation points
2021-08-26T19:31:29.79+00:00

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:

  1. Right-Click the package in Solution Explorer in Visual Studio 2019.
  2. Select Deploy Package.
  3. Select SSIS in Azure Data Factory
  4. Provide the server name - **********.database.windows.net
  5. Authentication: Sql Server Authentication
  6. Provide Login/Password
  7. Click Connect
  8. I receive this error:
  9. 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.

  1. Do we need to open any additional ports on the SQL Server **********.database.windows.net to support deploying from Visual Studio 2019?
  2. Any other ideas what could be the cause?

Thanks.

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,752 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,482 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,426 Reputation points
    2021-08-27T02:21:09.353+00:00

    Hi @Jeremiah Adams ,

    You receive error messages when the connection to Azure SQL Database or Azure SQL Managed Instance fails. These connection problems can be caused by reconfiguration, firewall settings, a connection timeout, incorrect login information, or failure to apply best practices and design guidelines during the application design process.

    You may refer the documentation for more details.

    Try the steps (in the order presented) in the Steps to fix common connection issues section.

    Regards,

    Zoe


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October