Azure VM to ADF Data Ingestion

S, Anil Kumar 20 Reputation points
2024-06-24T09:43:26.2166667+00:00

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.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,149 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Amira Bedhiafi 19,781 Reputation points
    2024-06-24T10:49:12.9466667+00:00

    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