Cannot connect to Azure SQL Managed Instance

Question

Hi All,
We have a SHIR (Self hosted Integration Run time) running on VM in our network. We have a SQL Server Managed Instance hosted on an Azure VM.
Issue : Not able to set up a linked service using the SHIR. I get the below error

Cannot connect to SQL Database: 'sql.public.c24f50d7ee24.database.usgovcloudapi.net,3342', Database: 'sqldb-MAY-01', User: 'performs'. 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 - No such host is known.), SqlErrorNumber=11001,Class=20,State=0,
No such host is known
Activity ID: d74131d9-99e3-445f-ad3f-11ce955507d1.

Please advice
Thanks

Answer 1

Hey @bk ,
Based on the error msg; it seems that the VM on which the Self hosted IR is installed is not able to access the SQL MI database.
For that to verify, login into the VM hosting the IR and try to execute the below cmd in cmd line :

ping <<IP address of the SQL MI server>>  

Note: The IP address should be the private IP of the SQL MI server since both the VMs are in the same Vnet.

Else , install SSMS/Azure data studio in the VM with IR and try connecting the SQL MI.

If we are not able to access SQL MI, then that is the reason why Linked service is not being created and you would need to make some network security changes across the 2 VMs for them to be able to communicate.