SSIS Integration Runtime failed to start - Custom DNS

JoelP 366 Reputation points
2023-03-14T01:34:15.0866667+00:00

Hi,

I am currently setting up SSIS Integration runtime with VNET/SubNet. We are currently using custom DNS servers, so I got a warning when I was creating the runtime, but still continue. I waited 30mins, then it failed to start due to below error:

 Last operation 'Start' get the status 'Failed'.
  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.

Do I simply follow below instructions and replace the IP with our DNS server IPs?

Configure a custom DNS server

If you want to use your own DNS server in the virtual network to resolve your private hostnames, make sure that it can also resolve global Azure hostnames (for example, your Azure Blob Storage named <your storage account>.blob.core.windows.).

At present, for Azure-SSIS IR to use your own DNS server, you need to configure it with a standard custom setup following these steps:

  1. Download a custom setup script (main.cmd) + its associated file (setupdnsserver.ps1).
  2. Replace “your-dns-server-ip” in main.cmd with the IP address of your own DNS server.
  3. Upload main.cmd + setupdnsserver.ps1 into your own Azure Storage blob container for standard custom setup and enter its SAS URI when provisioning Azure-SSIS IR, see the Customizing Azure-SSIS IR article.
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
{count} votes

1 answer

Sort by: Most helpful
  1. JoelP 366 Reputation points
    2023-03-16T16:54:51.7966667+00:00

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.