Failed Test Connection with Azure SQL Database

Stephen-5002 40 Reputation points
2024-10-10T14:19:43.0266667+00:00

I'm encountering an issue while using Azure Data Factory (ADF). I'm trying to connect an Azure SQL Database to a data flow using a linked service.

  1. Successful Linked Service Connection: The linked service connection to the Azure SQL Database establishes successfully within ADF.
  2. Failing Data Flow Source Dataset Test: However, when I add the source dataset using this linked service to the data flow, the test connection fails.

Error Message: Spark job failed: {

"text/plain": "{"runId":"9880465ecb-5gh4-6777w-tt78b-k8562e1db87f","sessionId":"96dd501b-ac03-4c93-8862-36058e06b8a0","status":"Failed","payload":{"statusCode":400,"shortMessage":"com.microsoft.dataflow.broker.MissingRequiredPropertyException: server is a required property for AzureSqlDatabase1.\ncom.microsoft.dataflow.broker.PropertyNotFoundException: Could not extract value from AzureSqlDatabase1","detailedMessage":"Failure 2024-10-10 15:10:36.828 failed DebugManager.processJob, run=87705efb-4fd6-854e-aa7f-e3526f1db87f, errorMessage=com.microsoft.dataflow.broker.MissingRequiredPropertyException: server is a required property for AzureSqlDatabase1.\ncom.microsoft.dataflow.broker.PropertyNotFoundException: Could not extract value from AzureSqlDatabase1"}}\n"

} - RunId: 9550465ecb-5gh4-6699w-tt78b-k8562e1db87f

I have reviewed online forums and attempted recreating the linked service, but the issue persists.

Increasing the Data Flow Integration compute size, as suggested in some resources, doesn't resolve the problem.

Are there any alternative solutions to this issue?

What could be causing this specific error message regarding a missing "server" property even though the linked service connection seems to be working?

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

Accepted answer
  1. Smaran Thoomu 16,890 Reputation points Microsoft Vendor
    2024-10-10T18:21:24.9833333+00:00

    Hi @AinoKaisa
    Welcome to the Microsoft Q&A and thank you for posting your questions here.
    I understand that you're facing connection issues in Azure Data Factory, especially after successfully setting up the linked service. The error message you’re encountering regarding the "server" property being required for Azure SQL Database is quite common and typically points to a configuration issue.

    I suggest trying this approach, which worked for a similar issue I faced:

    1. Create a new Linked Service using the "legacy" option instead of the "recommended" one.
    2. Enter your server and database names, then test the connection.
    3. Once the test is successful, publish the changes.
    4. After that, update your data sources to use this new Linked Service.
      User's image

    There seems to be a temporary issue with the recommended "new" version of the Linked Service. Using the "legacy" version should resolve the error.

    Hope this helps. Do let us know if you any further queries.


    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.