Forum Discussion
BobChauvin
2 years agoNew Member
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
Microsoft Employee
2 years agoHi 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.