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

Question

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.

Answer 1

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.