Add second data source to a gateway

Hi msr15105k ,

Thank you for reaching out to the Microsoft Fabric community forum. Also thank you GilbertQ  for your inputs

The error you're facing while adding a second SQL database connection to the On-premises Data Gateway is likely due to an authentication mismatch or gateway configuration. Please ensure that the authentication type (Basic or Windows Authentication) used in the gateway matches the one used in SSMS.

If your SQL Server uses Windows Authentication, the gateway service account must have the necessary access permissions. Also, verify that both data sources have the same privacy level under Manage Gateways settings in Power BI.

Additionally, check if there are network restrictions or firewall blocks on TCP port 1433 between the gateway machine and SQL Server. Restarting the gateway service and enabling diagnostic logs can also help identify the issue.

For more information, please refer to Microsoft's official documentations:

Manage an on-premises data gateway | Microsoft Learn

Add or remove a gateway data source - Power BI | Microsoft Learn

I hope my suggestions give you good ideas, if you need any further assistance, feel free to reach out.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thank you. 

We finally solved it.  See details below, but in summary, we needed to add our SQL server to the gateway configuration file and then restarted the gateway.  Marking your post above as a solution since it mentions re-starting the gateway.