cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User II
Super User II

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

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." 

View solution in original post

4 REPLIES 4
Highlighted
Solution Sage
Solution Sage

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

Hi @photonacl ,

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.

Capture7.PNG

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.

Highlighted
Frequent Visitor

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

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?

Highlighted
Super User II
Super User II

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

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." 

View solution in original post

Highlighted
Frequent Visitor

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

That makes perfect sense! Thank you.

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Users online (7,653)