Forum Discussion

DSanthoshKumar's avatar
DSanthoshKumar
Regular Visitor
2 years ago
Solved

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

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...
pipelines
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

tmjones2's avatar
tmjones2
Icon for Helper I rankHelper I
1 year ago

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's avatar
    Timbaaaal
    Icon for Advocate II rankAdvocate II
    1 year ago

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