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 .


  • BobChauvin's avatar
    BobChauvin
    New Member
    2 years ago

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

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

      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's avatar
        scca
        Icon for Advocate III rankAdvocate III
        2 years ago

        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?