Forum Discussion

Microsoft Employee

1 year ago

Solved

Unable to create gateway connection for SQL Server

Please help! I'm unable to create gateway connections for my SQL Server data source. However, on PBI desktop, everything works fine as usual. Once published to the service, it shows error creating t...

Need Help

Deku
1 year ago
Old solution from Microsoft https://powerbi.microsoft.com/en-us/blog/ssl-security-error-with-data-source/

And yet another one https://learn.microsoft.com/en-us/power-query/connectors/sql-server#sql-server-certificate-isnt-trusted-on-the-client-power-bi-desktop-or-on-premises-data-gateway

Deku

Super User

1 year ago

Old solution from Microsoft https://powerbi.microsoft.com/en-us/blog/ssl-security-error-with-data-source/

And yet another one https://learn.microsoft.com/en-us/power-query/connectors/sql-server#sql-server-certificate-isnt-trusted-on-the-client-power-bi-desktop-or-on-premises-data-gateway

NothingZ

Microsoft Employee

1 year ago

Thank you.
Adding server name to the field "SqlTrustedServers" in Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config works for my case.

Forum Discussion

Unable to create gateway connection for SQL Server

Related content

Gateway connection error

Gateway Connectivity Error

gateway - unable to connect to my standard gateway

Unable to see or modify users of gateway connections

Unable to connect pipeline to Warehouse