question

SusheelBojjawar-6278 avatar image
0 Votes"
SusheelBojjawar-6278 asked KranthiPakala-MSFT edited

Azure Data Factory - Azure SQL connectivity error : Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access. `SqlErrorNumber=53`

While trying to establish connection from Azure Data factory to Azure SQL, getting below error message. Please assist...

SqlErrorNumber=53

Error Message: Connection failed: Cannot connect to SQL Database: 'vm-123-sql-dev', Database: 'DevServer', User: '123-sql-dev-admin'. 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), SqlErrorNumber=53,Class=20,State=0, The network path was not found

Activity ID: ac7aba96-53d3-4740-9557-b6da7a6482s3.;

azure-data-factoryazure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HimanshuSinha-MSFT avatar image
1 Vote"
HimanshuSinha-MSFT answered KranthiPakala-MSFT edited

Hi,
Welcome to Microsoft Q&A forum and thanks for reaching out.

By looking at the error message and the SQL error number, below could be the possible root case and resolution for the issue.

SqlErrorNumber=53

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

NandanHegde-7720 avatar image
1 Vote"
NandanHegde-7720 answered

Hey, there can be multiple reasons for that.some if them are as below:
1) check whether the allow azure service property is enabled in Azure SQL server.
If not then you would have to white list the IP range of the region in which the ADF is created
2) in case if your source or sink is leveraging an integration runtime,then the azure database must also be accessible from the IR

Can you please provide the source and sine details of your adf

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.