Create a linked server connection from on-prem SQL Server to Fabric SQL Endpoint

[BobChauvin]

Hey all. I'm trying to create a linked server connection from on-prem SQL Server to Fabric SQL Endpoint.  I saw one other post here that was "inconclusive".  I can use SSMS to connect to the SQL Endpoint. And, also connect via another app using the Microsoft OLE DB Driver 19 for SQL Server.

There are no great examples on how to do this, and my simple attempt failed with a general error.  Followed general insturctions here, but there are no examples using the SQL Connection String from the Fabric SQL Endpoint. https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/azure-ad-a...

Is this supported, or to-be supported?

[v-cboorla-msft]

Hi @BobChauvin 

Apologies for the delay in the response.

As I understand that you are trying to create a linked server connection from on-prem SQL Server to Fabric SQL Endpoint.

The below procedure might help you to resolve your ask.

In order to connect from on-prem SQL server to Fabric, you need to install an on-premises gateway. Please find the related documentation - Install and configure an on-premises data gateway 

For server connection from on-prem SQL server to Microsoft Fabric.

For more details please refer :

On Premise SQL Server 2022 Data into Microsoft Fabric

Getting On-Premises SQL Server Data to Fabric Lakehouse 

I hope this information is helpful. Please do let us know if you have any questions.

[BobChauvin]

Thank you.  I'll have to review and will respond asap.  

[v-cboorla-msft]

Hi @BobChauvin 

Following up to check whether you got a chance to review the suggestions given. If the issue still persists please let us know. Glad to help. 

[scca]

Hi, I'm having the same use caseand have not been successful in finding any solutions for this matter. The links provided did not highlight anything that would be useful for connecting "linked servers" specifically to MS Fabric. Is there anything I'm missing? 

[BobChauvin]

I'm not sure it's possible, per the documentaion here: Connectivity to data warehousing - Microsoft Fabric | Microsoft Learn "...Linked server connections from SQL Server are not supported...."

Note, for other connections I have been using the following:

Driver/Provider=MSOLEDBSQL19.1;

Authentication=ActiveDirectoryServicePrincipal;

And the user and datasource values will come from that fabric admin.

User ID=someguidstringhere;

Initial Catalog=DatabaseName;

Data Source=someguidstringhere.datawarehouse.pbidedicated.windows.net;

The following article does have info on getting a SQL connection string Connectivity to data warehousing - Microsoft Fabric | Microsoft Learn

[v-cboorla-msft]

HI @BobChauvin 

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others .

[v-cboorla-msft]

Hi @BobChauvin 

Thanks for using Microsoft Fabric platform and posting your question here.

I have escalated this to our internal team and will definitely come back to you if I get an update. Please continue using Fabric Community for help regarding your queries.

Appreciate your patience.