topic Re: Connect to on-premise SQL Server in Data Engineering

Connect to on-premise SQL Server

MK007 — Thu, 06 Mar 2025 21:31:59 GMT

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 would like to know if it is possible in a Spark job or notebook.

Re: Connect to on-premise SQL Server

nilendraFabric — Thu, 06 Mar 2025 22:33:08 GMT

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

Re: Connect to on-premise SQL Server

v-achippa — Mon, 10 Mar 2025 11:29:40 GMT

Hi @MK007,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @nilendraFabric for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa