Forum Discussion
SSRS 2022 not able to connect SQL Server 2022
cihan_acikgoz add "Encrypt=False" to the connection string to surpress encryption; that works for me.
But on SSRS there is no string to put this string. On SSRS configuration when you select account and password, it straights throws this error message.
There should be a way to bypass this.
cihan_acikgoz wrote:
Hi,
But on SSRS there is no string to put this string.cihan_acikgoz , of course there is field "Connection string" to add the property.
olafhelper​ -- there is no connection string anywhere for the connection from the SSRS service to the ReportServer website. It does not exist in any of the rs*.config files, and there is no UI that allows setting parameters such as TrustServerCertificate. The version I am installing (16.0.1117.43, released May 2025) does have an "Encrypt" checkbox, but that's not helpful at all when the SQL instance is configured for ForceEncryption=True, because it gets ignored. The only workaround I have found is to set ForceEncryption=False, which is not at all appropriate for us given that we have sensitive data on the SQL instance, and our standard is to have encrypted connections at all times.
Hi @olafhelper
As other users also having same problem, could you kindly let us know the steps how to add this string please ?
When you click account on SSRS menu, like i mentioned, there is only Username and Password field, but i dont see any other field to enter connection string.
We'd be grateful if you kindly share with us the steps.
Thank you
olafhelper I have the same issue with the September 2024 version, and there is no "Connection string" field.
