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
Deku's avatar
Deku
Super User
1 year ago

Please see this stack overflow post with a potential solution and some info on the process

  • 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.