topic Re: eu2.frontend.clouddatahub.net error on connecting SQL Server on-premises as source in Pipelines

eu2.frontend.clouddatahub.net error on connecting SQL Server on-premises as source

DSanthoshKumar — Fri, 12 Jul 2024 05:56:26 GMT

Hi,

When we are trying to connect SQL Server On-Premise in fabric=>pipeline=>copy data activity as source we are getting connection type error as "Please check your network connectivity to ensure your on-premises data gateway can access eu2.frontend.clouddatahub.net and restart the service to retry the connection again once the connectivity issue has been resolved.".

where as with same source we can able to connect in fabric DataFlowGen2.

Re: eu2.frontend.clouddatahub.net error on connecting SQL Server on-premises as source

Anonymous — Mon, 15 Jul 2024 05:37:51 GMT

Hi DSanthoshKumar ,

Based on your description, you can troubleshoot by wishing for inoculation:

Make sure that eu2.frontend.clouddatahub.net is accessible from your network. You can try to test the connection by using ping or telnet in your local network.

ping eu2.frontend.clouddatahub.net

Check your firewall and network security settings to ensure that you allow access to the port required for eu2.frontend.clouddatahub.net (usually HTTPS port 443). If not, try below steps to open it:

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: eu2.frontend.clouddatahub.net error on connecting SQL Server on-premises as source

dcullen — Wed, 18 Sep 2024 12:52:39 GMT

I'm having this exact same issue.

I've added this firewall allow rule on both of our gateway servers but I am still geetting the following error.

I have also tried to manually browse to the uks.frontend.clouddatahub.net URL on the gateway servers and my local machine and I can load it without any issues (proxy enabled and disabled).

When I try and test the connection in fabric I get a HTTP Bad Request error.

Any ideas what could be occurring?

Anonymous Where is the documentation does it say to allow 443 INBOUND? https://learn.microsoft.com/en-us/fabric/security/fabric-allow-list-urls#pipeline All of these listed here are for outbound.

Re: eu2.frontend.clouddatahub.net error on connecting SQL Server on-premises as source

tmjones2 — Tue, 28 Jan 2025 14:49:19 GMT

I had to enable TLS 1.2 and restart the gateway for it to work (I also opened 443, both inbound and outbound. No clue if that did anything but it didn't work until enabling TLS1.2)

PowerShell script:

[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12 -bor [Net.SecurityProtocolType]::Tls11 -bor [Net.SecurityProtocolType]::Tls

Re: eu2.frontend.clouddatahub.net error on connecting SQL Server on-premises as source

Timbaaaal — Mon, 17 Feb 2025 11:09:13 GMT

Thanks for this. Had same issue and having TLS 1.2 on the server fixed it.

Re: eu2.frontend.clouddatahub.net error on connecting SQL Server on-premises as source

jagdishwagh0909 — Wed, 17 Sep 2025 14:22:12 GMT

Hello,
I faced the same issue but it fixed. Issue was not related to network but message will misleading. I just updated onprem gateway and everything working fine again.
Last gateway version was Aug 2024 and update version Spetmeber 2025.

Re: eu2.frontend.clouddatahub.net error on connecting SQL Server on-premises as source

smcquistan1 — Mon, 26 Jan 2026 17:53:07 GMT

I just experienced this same issue with one of my clients.

Situation: all Fabric pipelines utilizing the on-prem data gateway began failing over the weekend. The on-prem data gateway was running the Jan 2025 installation without auto-update enabled, and we began experiencing the failures exactly a year later. Updating the gateway manually to the most recent version resolved the failures we were experiencing. Microsoft states that only the prior 6 months of gateway updates are supported, even though we were running a one-year old version of the gateway.