Forum Discussion

BobChauvin's avatar
BobChauvin
New Member
2 years ago

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

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 Endp...
v-cboorla-msft's avatar
v-cboorla-msft
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

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.

 

 

v-cboorla-msft's avatar
v-cboorla-msft
Icon for Microsoft Employee rankMicrosoft Employee
2 years ago

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 .