Connect to Fabric SQL Endpoint from Azure APP Service WebJob in C#

Anthony 0 Reputation points
2024-09-05T15:43:22.9533333+00:00

How can we connect to a Fabric SQL endpoint using a C# console app published as a webjob? We are using ADO.NET to access SQL endpoints, but we get the following error: "A server name like tcp:xxxxxxxxxxxxxxx.datawarehouse.fabric.microsoft.com,1433 is not allowed." Our connection string looks like this:

C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
11,062 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,960 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Kobe Lenjou 0 Reputation points
    2024-11-20T11:29:14.0233333+00:00

    Downgrade your SQL Client to the 5.1.x branch ....

    I don't know what happened there but that fixed it for me

    0 comments No comments

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.