We've setup a fabric gateway so we can ingest data from our on prem resources. The gateway iteself is setup and registered with our fabric tennant and we can see it in fabric and select it for data connections. However when trying to connect through it to our on prem database I'm getting the following error:
Please check your network connectivity to ensure your on-premises data gateway can access ne.frontend.clouddatahub.net and restart the service to retry the connection again once the connectivity issue has been resolved.
Activity ID: 9400b69a-de1b-4e59-bef4-be1902fa31ef
I have checked the connectivity to this url on the gateway server and it seems fine:
# 1) DNS + TLS to the Fabric front end tnc ne.frontend.clouddatahub.net -Port 443 -InformationLevel Detailed ComputerName : ne.frontend.clouddatahub.net RemoteAddress : 48.209.130.115 RemotePort : 443 NameResolutionResults : 48.209.130.115 MatchingIPsecRules : NetworkIsolationContext : Internet IsAdmin : False InterfaceAlias : Ethernet 2 SourceAddress : 10.140.18.2 NetRoute (NextHop) : 10.140.18.30 TcpTestSucceeded : True
I've also ran diagnostics on the gateway and it seems to be able to connected to everything required:
General Information
Service Bus Namespace : WABI-NORTH-EUROPE-O-PRIMARY-relay2.servicebus.windows.net
Host Name : ns-prod-db3-001.northeurope.cloudapp.azure.com
Host IP Address : 172.205.67.145
Proxy configuration : Proxy settings match for all Gateway process configurations.
Overall Results : 31/31 tests succeeded.
Note: If one or more tests failed, contact your network administrator to open the ports for the required servers.
Firewalls often intermittently allow traffic on blocked sites. Even if a test succeeds, you may still need to allowlist that server on your firewall.
Server Name: gv20-prod-db3-001-sb.servicebus.windows.net IP Address: 20.234.40.147
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv10-prod-db3-001-sb.servicebus.windows.net IP Address: 40.67.236.69
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv1-prod-db3-001-sb.servicebus.windows.net IP Address: 40.113.56.142
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv29-prod-db3-001-sb.servicebus.windows.net IP Address: 68.219.120.117
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv11-prod-db3-001-sb.servicebus.windows.net IP Address: 74.178.124.248
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv7-prod-db3-001-sb.servicebus.windows.net IP Address: 74.178.124.250
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv21-prod-db3-001-sb.servicebus.windows.net IP Address: 74.234.50.71
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv12-prod-db3-001-sb.servicebus.windows.net IP Address: 40.113.56.98
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv6-prod-db3-001-sb.servicebus.windows.net IP Address: 40.67.236.60
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv25-prod-db3-001-sb.servicebus.windows.net IP Address: 40.113.33.94
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv13-prod-db3-001-sb.servicebus.windows.net IP Address: 40.67.236.70
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv0-prod-db3-001-sb.servicebus.windows.net IP Address: 74.178.124.61
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv22-prod-db3-001-sb.servicebus.windows.net IP Address: 40.67.224.118
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv14-prod-db3-001-sb.servicebus.windows.net IP Address: 74.234.45.105
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv8-prod-db3-001-sb.servicebus.windows.net IP Address: 40.113.56.111
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv23-prod-db3-001-sb.servicebus.windows.net IP Address: 20.82.160.93
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv15-prod-db3-001-sb.servicebus.windows.net IP Address: 128.251.48.196
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv4-prod-db3-001-sb.servicebus.windows.net IP Address: 74.178.124.72
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv28-prod-db3-001-sb.servicebus.windows.net IP Address: 20.123.80.155
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv16-prod-db3-001-sb.servicebus.windows.net IP Address: 20.13.154.86
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv3-prod-db3-001-sb.servicebus.windows.net IP Address: 40.67.236.55
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv24-prod-db3-001-sb.servicebus.windows.net IP Address: 20.67.233.185
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv17-prod-db3-001-sb.servicebus.windows.net IP Address: 74.234.20.174
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv5-prod-db3-001-sb.servicebus.windows.net IP Address: 40.113.56.106
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv27-prod-db3-001-sb.servicebus.windows.net IP Address: 72.145.3.30
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv18-prod-db3-001-sb.servicebus.windows.net IP Address: 128.251.48.156
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv2-prod-db3-001-sb.servicebus.windows.net IP Address: 40.113.56.179
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv26-prod-db3-001-sb.servicebus.windows.net IP Address: 20.82.184.205
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv19-prod-db3-001-sb.servicebus.windows.net IP Address: 20.13.157.1
Port: Status: Proxy Uri:
443 Open N/A
Server Name: gv9-prod-db3-001-sb.servicebus.windows.net IP Address: 40.67.236.50
Port: Status: Proxy Uri:
443 Open N/A
Server Name: ne.frontend.clouddatahub.net IP Address: N/A
Port: Status: Proxy Uri:
443 Open N/A
This is happening when trying to create a new SQL server dataset connection in fabric. I'm a bit stumped as to what could be the issue. Any ideas would be appreciated.
Yes I've tested the URL and port from the gateway server. It's in the original body of this post. I used powershell to test the connection and it succeeded.
Just wanted to check regarding your question. We haven’t heard back and want to ensure you're not stuck. If you need anything else or have updates to share, we’re here to help!
