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