Answered

Installing On-Premises Data Gateway right on the SQL Production Server?

(0) Share

Report

Posted on by photonacl

According to Microsoft, it is recommend to have the data gateway installed as close as possible to the data source to minimize latency. If that is the case, I'm assuming for most people, it means the SQL server. However, I been hearing different voices where installation of the gateway on SQL produciton is not recommended. Anyone knows why this is not recommended? Anything has to do with resources/overhead? the nature of how SQL works? Or firewall/ports issues?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

v-zhos-msft on at

Like (0)

Report

Hi @photonacl ,

I recommend you to install the data gateway on you computer.

Then you can create the connections of 'SQL server' via on-premises data gateway in flow.

As the document says:

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem

The On-premises data gateway acts as a bridge, providing quick and secure data transfer between on-premises data (data that is not in the cloud) and the Power BI, Microsoft Flow, Logic Apps, and PowerApps services.

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
photonacl 29 on at

Like (0)

Report

Thank you for your reply, but I'm still not sure why it is not recommended to have the instance installed right on the server itself?

Was this reply helpful? Yes No
Verified answer

Brad_Groux 4,556 on at

Like (1)

Report

Generally speaking, it is against Microsoft best practice to install anything other than required components on a dedicated system server (SQL, Exchange, SharePoint, etc.).

You can certainly install the connector directly on the SQL Server, but it is an added component that could possbily affect the performance or stability of the server - which is why they do not recommend it. For one of our clients, we installed the Gateway directly on the web front end server within their SharePoint environment without issue. Although I would have preferred to have not done so - but they didn't want to pay for another VM.

Most IT infrastructures have "tools" or "jump" servers within their environments to house small, one-off tools like the Gateway connector which is considered "best practice."

Was this reply helpful? Yes No
photonacl 29 on at

Like (0)

Report

That makes perfect sense! Thank you.

Was this reply helpful? Yes No