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 confi...
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!
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!