Then trying to connect to my azure sql database from linked services in azure datafactory i suddenly get the following message: Failed to resolve the server name "dpnorwayeast.svc.datafactory.azure.com", please refer to troubleshooting doc and check network configuration. Activity ID: XXXX

Tried to enter: dpnorwayeast.svc.datafactory.azure.com in browser, as described in the help link, and received the following { "statusCode": 404, "message": "Resource not found" }. The guide says: If you see 404 in the browser, it usually means your client side is ok and the issue is at ADF service side. File a support ticket with the Activity ID from the error message.But I can't find any error message in azure status health.

Done no changes to my linked service or azure sql database and it worked a few days ago.

PS: Got the same error on my test subscription (other resource group, subscription, azure sql server / database and datafactory).

CodePudding user response：

If you're trying connect to Azure SQL Database, the correct Server name ends with database.windows.net not datafactory.azure.com. The full Azure SQL Server Name can be found in Overview tab, like in the following example:

Therefore, the Linked Service in ADF should look like that:

CodePudding user response：

Here is the response I get. Used Linked Service: Azure SQL Database. Tried booth from azure subscription and Enter manually. enter image description herestrong text