Forum Discussion
Create a linked server connection from on-prem SQL Server to Fabric SQL Endpoint
Microsoft EmployeeHi 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.
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.
sccaAdvocate III
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?
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