Share
ReportHow do I fix this? The log shows it passes all 90 connection tests.
You’re offline. This is a read only version of the page.
Announcements
How do I fix this? The log shows it passes all 90 connection tests.
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.
@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)?
Enterprise Gateway is running as a service. Personal Gateway is running as an application.
All responses (
Answers (
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.
#1
Michael E. Gernaey
497
Super User 2025 Season 1
#2
David_MA
436
Super User 2025 Season 1
#3
Riyaz_riz11
244
Super User 2025 Season 1
