Forum Discussion
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...
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.