Share via

Join Azure-SSIS integration runtime to a virtual network

Ankit Vats ADM INT (Others) 0 Reputation points
2023-02-09T10:57:00.59+00:00

While trying to create SSIS-Integration Runtime in Azure Data Factory, I am getting below error:

Error code: InvalidVnetConfiguration. Error message: VNet configuration is invalid. Code : MisconfiguredDnsServerOrNsgSettings, Message: Failed to provision Azure-SSIS integration runtime (SSIS IR) in a virtual network (VNet). If you’ve configured a domain name system (DNS) server, network security group (NSG), or user-defined route (UDR) in your VNet, make sure that you follow our guideline. Please see https://docs.microsoft.com/azure/data-factory/join-azure-ssis-integration-runtime-virtual-network to configure your VNet.. Activity ID: 2ad1b75c-e886-4812-aa7b-e10b0ee423f9

Need Help.

Thanks

Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,674 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,666 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AnnuKumari-MSFT 34,436 Reputation points Microsoft Employee
    2023-02-14T09:00:29.6466667+00:00

    Hi Ankit Vats ADM INT (Others) ,

    Welcome to Microsoft Q&A platform and thanks for posting your question here.

    As I understand your issue, you are facing an error : "InvalidVnetConfiguration" when you are trying to create an Azure SSIS Integration Runtime in ADF. Please let me know if that is not the correct understanding about your issue.

    The error message you're encountering, "InvalidVnetConfiguration" with the message "VNet configuration is invalid" and "MisconfiguredDnsServerOrNsgSettings", indicates that there is an issue with the virtual network (VNet) configuration you've set up for the Azure-SSIS integration runtime. The specific issue could be related to the domain name system (DNS) server, network security group (NSG), or user-defined route (UDR) settings in your VNet.

    When there's a Virtual Network-related issue, you are prone to experience this error as mentioned in the following document: MisconfiguredDnsServerOrNsgSettings

    In this situation, you probably have a customized configuration of DNS server or NSG settings, which prevents the Azure server name required by SSIS IR from being resolved or accessed. For more information, see SSIS IR Virtual Network configuration.

    If you’re still having problems, I would recommend you to Create Support request with Azure.

    Hope it helps. Please do consider clicking Accept Answer and Up-Vote for the same as accepted answers help community as well.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.