SOLVED Cant access built-in reports after upgrading to SQL server 2022

[JT26_KLL]

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:

 

[abreton]

ok so what are the logs saying now?

Same...

 

[abreton]

ok so what are the logs saying now?

Same error!.

 

[Garth]

Same error!.

So the data is likely stored within CM. As such, you need to not only remove the RP but both the component and site system roles from the server. One of them take time to removed. aka 24+ hours, after the others have been removed.

 

[abreton]

ok so what are the logs saying now?

No Logs file now, just the same issue... I try to register the DLL on that path, but nothing happens; it says it looks like the DLL is corrupted.

 

[Garth]

No Logs file now, just the same issue... I try to register the DLL on that path, but nothing happens; it says it looks like the DLL is corrupted.

To be 100% clear, you remove the RP. You the waited 24 hours to remove both component and site system roles from the server roles. You ensured that the reg key was removed on RP server. You them installed the RP. You reviewed the logs to install the component on the Site server. Then you reviewed the logs on the RP.

Did you do all of that?

 

[abreton]

To be 100% clear, you remove the RP. You the waited 24 hours to remove both component and site system roles from the server roles. You ensured that the reg key was removed on RP server. You them installed the RP. You reviewed the logs to install the component on the Site server. Then you reviewed the logs on the RP.

Did you do all of that?

No, from the SQL Server: remove the RP and site system? both, wait to remove each 24 hours, remove the key then add it again both roles. OK.. recaping.. ( Didn't catch that)... let me try this...

 

[abreton]

before that, Can i Setup Reporting role in a diferent server?, like Right now
01(ConfMgr) 02 (SQL & RP) & 03 (Wsus), ?

 

[Garth]

before that, Can i Setup Reporting role in a diferent server?, like Right now
01(ConfMgr) 02 (SQL & RP) & 03 (Wsus), ?

Yes you can install the rp and ssrs and Sql on another server.

 

[abreton]

Yes you can install the rp and ssrs and Sql on another server.

Thank you so much!... for all your help!

I built a new server and use it to install the SRSS. It works wonderfully!....