Forum Discussion

MK007's avatar
MK007
Frequent Visitor
1 year ago
Solved

Connect to on-premise SQL Server

Has anyone tried to connect to an on-premise SQL Server database using a Fabric Spark job definition or a notebook? I am able to do so using a data pipeline (via an on-premise gateway). However, I wo...
  • nilendraFabric's avatar
    1 year ago

    Hello MK007 

     

    Spark notebooks and SJD in Fabric cannot use the On-Premises Data Gateway for connectivity to on-premises SQL Server databases

     

    VPN/ExpressRoute for direct network access or Managed Private Endpoints for Azure Private Link connectivity could be a possibility.  I haven't tried it personally