Skip to main content

Notifications

Power Automate - General Discussion
Answered

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

(0) ShareShare
ReportReport
Posted on by 29

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?

  • photonacl Profile Picture
    photonacl 29 on at
    Re: Installing On-Premises Data Gateway right on the SQL Production Server?

    That makes perfect sense! Thank you.

  • Verified answer
    Brad_Groux Profile Picture
    Brad_Groux 4,556 on at
    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." 

  • photonacl Profile Picture
    photonacl 29 on at
    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?

  • v-zhos-msft Profile Picture
    v-zhos-msft on at
    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard