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

[DSanthoshKumar]

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.

[tmjones2]

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

[Timbaaaal]

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

[dcullen]

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.

[Anonymous · Accepted solution]

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.