Azure VM to ADF Data Ingestion

Question

Hi Team,

We have Regular SQL Server hosted on Azure VM and wanted to ingest the data from SQL Server to ADF

currently we are Azure AutoResloveIntegretaion Runtime but we are facing on issue so do we need to create SHIR on Azure VM where we have SQL server ??

Error:

Cannot connect to SQL Database. Please contact SQL server team for further support.

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

The network path was not found

If so I request you to please provide us the detailed step's to configure the same.

Answer 1

Some verification to do before :

1. Verify that your SQL Server is configured to allow remote connections.
2. Verify that the firewall settings on the VM and SQL Server allow traffic on the required ports (default is 1433 for SQL Server).
3. Make sure you have the necessary permissions to install software on the Azure VM.

https://learn.microsoft.com/en-us/answers/questions/1651746/unable-to-connect-on-prem-sql-server-from-azure-ad

https://learn.microsoft.com/en-us/answers/questions/81835/error-40-could-not-open-a-connection-to-sql-server

https://www.c-sharpcorner.com/article/resolve-error-40-could-not-open-a-connection-to-sql-server/

https://learn.microsoft.com/en-us/answers/questions/336067/azure-data-factory-azure-sql-connectivity-error-ch