Common On-Premise data gateway to access multiple SQL servers from Fabric Data Factory

[MaheshSanga]

HI Team, we are migrating ADF pipelines to Fabric Data Factory where as we have On-Premisis sql servers data copying with Integration runtime now we are trying to set up common On-Premisis Gateway to connect multiple sql servers.

looking some help in setting up common gateway.

[govindarajan_d]

Hi @MaheshSanga,

Similar to ADF Self-hosted Integration Runtime (SHIR), you have a On-premises Gateway in Fabric through which you would be connecting to the on-prem systems. 

In the current VM where you have installed SHIR, you can install On-prem gateway as well and establish connection to it from Power BI Manage connections page. Once you configure the gateway, you can create SQL connections on the Gateway using the same Manage Connections page. 

[MaheshSanga]

yes I have done it already able to connect SQL Server from gateway but would need help in how to set the same gateway to access multiple sql servers which are from different VM's like centralized Gateway across sql servers.

[govindarajan_d · Accepted solution]

Hi @MaheshSanga,

You need to install the gateway in the multiple VMs you mentioned, and you would require the recovery key that you had generated when you installed the gateway the first time. 

Below is the complete instructions on how to do that:

https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install#add-another-gatew...

[v-aatheeque]

Hi @MaheshSanga ,

 If our response addressed by the @govindarajan_d   your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!

[v-aatheeque]

Hi @MaheshSanga ,

If our previous response posted by @govindarajan_d  was helpful, please consider clicking "Accept Answer" and selecting "Yes" for whether the answer was helpful. If you have any further questions or need additional assistance, please don't hesitate to reach out.

Thanks for using Microsoft Fabric Community.

[v-aatheeque]

Hi @MaheshSanga ,

 If our response addressed by the @govindarajan_d   your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!