Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

GuyInACube
Microsoft Employee
‎12-19-2014 02:52 AM

Failed to register the gateway key

We have seen a few cases some in where we get an error like the following

SNAGHTMLbf4bc85
Failed to register the gateway key.  Before trying to register the gateway key again, confirm that the Data Management Gateway is in a connected state and the Data management Gateway Host Service is started.
This could be the result of a firewall/proxy in your environment that is preventing the traffic from successfully going through.  I’ve be asked what someone has to open up from a firewall perspective to get the Data Management Gateway work.
An Inside look at Microsoft Data Management Gatewayhttps://support.office.com/en-US/Article/An-Inside-look-at-Microsoft-Data-Management-Gateway-078d306...
The above document outlines what the inbound and outbound traffic will be.  It outlines the following under the Installation section.
Regarding a firewall, the setup program will automatically configure firewall rules for the host machine, with the following TCP ports opened:
  1. Inbound for intranet: 8050/8051 by default while user is able to change with Configuration Manager. These ports are used for OData feeds consumption via the gateway, as well as Data Source Manager to test connection and store credential in the gateway.
  2. Outbound: 80, 443, from 9350 to 9354. These are used by Microsoft Azure Service Bus to establish connection between the cloud services and the gateway.
In case issues, please verify these settings remain correct to ensure a firewall is not the blocker.

Regarding proxy server, please add Microsoft Azure to the whitelist. You can download a list of valid Microsoft Azure IP addresses from the Microsoft Download Center.

 

Adam W. Saxton | Microsoft SQL Server Escalation Serviceshttps://twitter.com/awsaxton

Labels:
0