Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Sql Server Linked Server connection to Fabric Sql Endpoint

Hi,   I'm trying to create a Linked Server connection from SQL Server to Fabric Lakehouse SQL Endpoint. The idea is to easily get data from Fabric to on-prem SQL Server. The current On-Prem solutio...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
3 years ago

Hi Anonymous 

 

It does appear not to work because of the way it needs to authenticate with a username and password as if you were logging in.

 

Have you tried using the data pipeline copy activity and try and copy the data from the Fabric SQL End point to your SQL Server via the gateway?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi GilbertQ 

     

    To my knowledge there is no Self-Hosted Integration Runtime for Fabric, so I cannot push data to On-Prem with Copy Activity. 

     

    The requirement was for the client application (SQL Server) to pull data from Fabric. I ended up using SSIS after all, since the connection worked well with AAD service principal.