Getting below error while try to connect with Azure SQL Database using linked service through Azure Data Factory

Question

Please Check Below error:-

Cannot connect to SQL Database. Please contact SQL server team for further support. Server: 'cms-data-cleansing-poc.database.windows.net', Database: 'datacleansingdb', User: 'admindata@poc'. Check the linked service configuration is correct, and make sure the SQL Database firewall allows the integration runtime to access.

Cannot open server "poc" requested by the login. The login failed.

SQL Server Network:-

Answer 1

Hi
The error you’re encountering when connecting to Azure SQL Database through Azure Data Factory’s linked service may stem from several common issues. Check the following:

Firewall Rules: Ensure the Azure SQL Database has firewall rules allowing connections from the Data Factory IP addresses.

Authentication Mode: Verify the authentication type (SQL Authentication or Managed Identity) matches the credentials provided.

Network Settings: If using a private endpoint, ensure your Data Factory has network access to the SQL Database.

Connection String: Confirm the server name, database name, and any credentials are correctly configured in the linked service.

Try these steps to resolve the connection issue.

Answer 2

@EduTech Gyan ,

Looks like the issue is related to firewall rules not set correctly. Kindly make sure that the IP is whitelisted in the network property of the SQL server.

Also, kindly recheck if all the details entered in the linked service like servername, DBname, login id and password is correct or not. In case if it still doesn't work , would suggest you to enable Microsoft entra authentication for the server and try accessing via that, instead of SQL authentication.

References:

1. Create Azure SQL database with Microsoft Entra ID authentication

Troubleshoot using SQL authentication :

Reference:

1. Connect to SQL Server through SQL Server Authentication
2. Use private endpoints to connect securely to Azure SQL Server

Hope it helps. Kindly accept the answer by clicking on Accept answer button. Thankyou