PENDINGCant access built-in reports after upgrading to SQL server 2022

J

JT26_KLL

New Member
1
0
1
running latest version of SCCM on Server 2022. recently upgraded the SCCM SQL server to SQL server 2022 and in the process had to remove 2016 SQL service reporting and install the independent one. did everything but after the upgrade i cannot access the built-in reports however custom reports load just fine. here is the error i get when i load the report:

2023-06-19_8-54-45.png
AhmedLS

AhmedLS

Well-Known Member
125
9
18
running latest version of SCCM on Server 2022. recently upgraded the SCCM SQL server to SQL server 2022 and in the process had to remove 2016 SQL service reporting and install the independent one. did everything but after the upgrade i cannot access the built-in reports however custom reports load just fine. here is the error i get when i load the report:

View attachment 5353
i had a similar issue but after upgrading the windows server to 2019. i ended up deleting the reporting server databases and creating a new ones then reconfiguring the reporting service on SCCM. i think your issue is due to the encryption keys not working after the upgrade.
Garth

Garth

Well-Known Member
Staff member
1,712
140
63
Did you remove and readded the reporting point?

Can you access the Website for reporting?

Forum statistics

Threads
5,608
Messages
21,877
Members
12,154
Latest member
GSwells