Data gateway is configured correctly but is unreachable

(0) Share

Report

Posted on by IPC_ahaas

1,387 Moderator

How do I fix this? The log shows it passes all 90 connection tests.

Categories:

Using connectors

I have the same question (1)

All responses (6)

Answers (1)

lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report

Standard/Enterprise or Personal Gateway? Dedicated VMs or your own PC?

Was this reply helpful? Yes No
IPC_ahaas 1,387 Moderator on at

Like (0)

Report

How can I tell if this is Standard/Enterprise? Microsoft had one download link.

This is running on a dumb Windows 7 machine because that's where the SQL database is.

Was this reply helpful? Yes No
lbendlin 8,474 Super User 2025 Season 2 on at

Like (0)

Report
Enterprise Gateway is running as a service. Personal Gateway is running as an application.

This is running on a dumb Windows 7 machine because that's where the SQL database is.

That is not recommended. The gateway and the SQL server will fight for the available memory and CPU. Gateways should be installed on dedicated VMs.

Was this reply helpful? Yes No
IPC_ahaas 1,387 Moderator on at

Like (0)

Report

@lbendlin wrote:

That is not recommended. The gateway and the SQL server will fight for the available memory and CPU. Gateways should be installed on dedicated VMs.

Tell me about it.

I was under the impression that the Gateway needed to run on the thing that is hosting what we want access to.

If the SQL database is on Server A, can I install the Gateway on a completely different server (Server B)?

Was this reply helpful? Yes No
lbendlin 8,474 Super User 2025 Season 2 on at

Like (1)

Report

yes, the recommendation is a dedicated set of VMs that can see the source (and ideally sit close to it).

Note that performance and BCP are a bit at odds here. BCP would ask for geographically dispersed cluster members but that introduces vast performance fluctuations.

Was this reply helpful? Yes No
Verified answer

IPC_ahaas 1,387 Moderator on at

Like (0)

Report

The issue ended up being residual files left over after updating the Data Gateway. Thanks, Microsoft! One day you'll learn how to clean house.

Was this reply helpful? Yes No