Cannot connect to SQLMI database when using Azure Auto Resolve Integration Runtime

bk 436 Reputation points
2020-09-11T15:37:42.983+00:00

Hi All,
I am loading data from ADLS Gen2 into SQLMI. When i am tried to create a linked service using Azure Auto resolve IR to connect to SQLMI using SQL authentication , i am getting the below azure message.
Enabling Azure services in NOT an option as it is a government cloud.
Cannot connect to SQL Database:sql.database.usgovcloudapi.net', Database: 'sqldb, User: 'swat'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access. 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 - A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.), SqlErrorNumber=10060,Class=20,State=0, A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond Activity ID: 796bfe4b-a147-49ad-abf1-7e5d6ded0592.

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,269 questions
{count} votes

Accepted answer
  1. KranthiPakala-MSFT 32,976 Reputation points Microsoft Employee
    2020-09-18T22:58:20.383+00:00

    Hi @bk ,

    Sorry for the delay in my response. After having discussion with internal teams, it is suggested to whitelist all Azure Gov IP Range for Data factory Service tag. You can download JSON file that contain the current list of service tags together with IP address range details.

    Please Note that: These lists are updated and published weekly

    Here is the download link: Azure IP Ranges and Service Tags – US Government Cloud

    Additional info: Discover service tags by using downloadable JSON files

    Hope this helps. Please let us know, if you have further query.

    Thank you

    ----------

    Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members.


0 additional answers

Sort by: Most helpful