Forum Discussion
Unable to create gateway connection for SQL Server
I get this error in system log:
The certificate received from the remote server was issued by an untrusted certificate authority. Because of this, none of the data contained in the certificate can be validated. The TLS connection request has failed. The attached data contains the server certificate.
The SSPI client process is Microsoft.PowerBI.EnterpriseGateway (PID: 6376).
Is there any methods to add encryption/trust server cert into SQL server connection string for gateway? I can't find any more parameters to add when creating gateway connections.
Thank you.
Adding server name to the field "SqlTrustedServers" in Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config works for my case.Thank you for your infomation. I have tried following steps and adding entries on SqlTrustedServers field in gateway config file, but still it would not allow me to create such SQL Server on-premise gateway connection😓.
Another thing I tried: OLE DB connection type works fine in gateway new connection creation as it provides "TrustServerCertificate=True" in connection string. However, OLE DB data souce from PBI desktop once published to the service, it becomes SQL Server connection type again and be un-able to add such parameter in the connection.
Think it might be time for a support ticket