Forum Discussion

NothingZ's avatar
NothingZ
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
NothingZ's avatar
NothingZ
Microsoft Employee
1 year ago

Hi, thank you for your quick reply. I'm not sure how to add those "TrustServerCertificate=True" into connection string when I'm creating SQL Server on-premise gateway connections. Could you please guide me further?

Plus, the connection works okay before my network environment got changed.

Deku's avatar
Deku
Super User
1 year ago

Steps suggested by Microsoft here

  • NothingZ's avatar
    NothingZ
    Microsoft Employee
    1 year ago

    Thanks a lot.

    My SQL connection in PBI desktop has disabled the encryption setting before. Along with my SQL server databases have un-checked the "Encryption Enabled" options.

    Still the issue persists, I'm not sure what to do next.