Forum Discussion
Common On-Premise data gateway to access multiple SQL servers from Fabric Data Factory
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.
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:
6 Replies
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.
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.
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:
