Forum Discussion
SSRS 2022 not able to connect SQL Server 2022
Hi,
on SQL Reporting Service Configuration Manager 2022, when i try to connect SQL 2022 instance, its enforcing encryption. However, during the SQL 2022 i just installed by default and haven't configured any SSL certificate or activated encryption. Moreover, MSSQLSERVER service account also default account which comes with installer.
How can i disable or bypass this issue in order to configure SQL Reporting Service ?
Regards,
6 Replies
cihan_acikgoz add "Encrypt=False" to the connection string to surpress encryption; that works for me.
- Hi,
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.
- Hi,
I'm currently experiencing the same issue.
I have a fresh install of SQL2022 standard on a SQL VM & cannot get the SSRS configuration manager to connect to the SQL server on the same VM.
It seems that the Database connection dialog is missing the "TrustServerCertificate=True" option, so fails with an SSL cert error.
Does anyone have a work around for this?
Thanks!
