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:

 

[AhmedLS]

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]

Did you remove and readded the reporting point?

Can you access the Website for reporting?

 

[abreton]

Did you remove and readded the reporting point?

Can you access the Website for reporting?

Hello, Garth

I have the same issue, and I have removed and added the Report Point a few times. I can Now Access the Website. Do you have any idea how I can reload these reports?

I added customs reports after Just need to change the DS, but they don't show Up in the SCCM Report List.

 

[Garth]

Hello, Garth

I have this same issue, and I remove and addes the Report Point few times, I do can Access the Website. Any Idea how I can reload this reports.

I added customs reports after Just need to change the DS, but they don't show Up in the SCCM Report List.

How do you upload the report? e.g. did you do it via the web interface? if so read this blog. https://askgarth.com/blog/how-to-setup-an-rdl-for-configmgr/

 

[abreton]

How do you upload the report? e.g. did you do it via the web interface? if so read this blog. https://askgarth.com/blog/how-to-setup-an-rdl-for-configmgr/

Yes, I did upload via the web interface. Thank you will do that now.

Another thing, I also managed to get the default reports, basically is one that I need desperatly from those, is the \Software Updates\Overall Compliance 1.rdp I try to upload it same as the custom but I get this error.

 

[Garth]

Yes, I did upload via the web interface. Thank you will do that now.

Another thing, I also managed to get the default reports, basically is one that I need desperatly from those, is the \Software Updates\Overall Compliance 1.rdp I try to upload it same as the custom but I get this error.

That error is taking about a DDL that can't be loaded. Where is it looking for that DLL? Do you see that DLL on your SSRS server?

 

[abreton]

That error is taking about a DDL that can't be loaded. Where is it looking for that DLL? Do you see that DLL on your SSRS server?

a DLL?, honestly I'm lost there because it doesn't mention it...

 

[Stanley Road]

Yes, I did upload via the web interface. Thank you will do that now.

Another thing, I also managed to get the default reports, basically is one that I need desperatly from those, is the \Software Updates\Overall Compliance 1.rdp I try to upload it same as the custom but I get this error.

Same error?

 

[Garth]

a DLL?, honestly I'm lost there because it doesn't mention it...

The error message clearly states that it can't find a file. That file is used but ConfigMgr for rbac reports. So does it exist?

 

[abreton]

The error message clearly states that it can't find a file. That file is used but ConfigMgr for rbac reports. So does it exist?

After ssrs install, we created new reportdb's, then restored the old report db's and encryption key backup in order to access the original data source definitions. Then we remove the report db's and create new again. Next in url, create the ConfigMgr_JST folder and the 2 datasources under it. Should we need to change the ssrs encryption or delete the content?

 

[Garth]

After ssrs install, we created new reportdb's, then restored the old report db's and encryption key backup in order to access the original data source definitions. Then we remove the report db's and create new again. Next in url, create the ConfigMgr_JST folder and the 2 datasources under it. Should we need to change the ssrs encryption or delete the content?


View attachment 7115

Restoring the db will not make the reports work. You need to install the reporting point on this new server. This will install the dlls and config changes that you will need. Just to make your life simpler, I would delete the folder and the datasource before starting the install of the Reporting point.

 

[abreton]

Restoring the db will not make the reports work. You need to install the reporting point on this new server. This will install the dlls and config changes that you will need. Just to make your life simpler, I would delete the folder and the datasource before starting the install of the Reporting point.

OK, by that you mean this:

Remove the role and then add it again. giving it a while to do the job. I'll reply the outcome.

 

[abreton]

OK, by that you mean this:

Remove the role and then add it again. giving it a while to do the job. I'll reply the outcome.

Nothing comes back?

 

[abreton]

Nothing comes back?

I even restart the SCCM Server.

 

[Garth]

I even restart the SCCM Server.

What does the setup logs for the Reporting Point say?

 

[abreton]

What does the setup logs for the Reporting Point say?

Hello, Sorry for the time

this is the error: the file is missing this one...

weird as you can see is looking for another Root to installed... anything I do still goes to that folder.
after remove the rp role, it deletes that folder( i try creating the folder and copy the file) and back to the same.

That's the srsrpsetup.lorg

V:\SMS_SRSRP\srsserver.dll.

Looks like something is tellin it to install it in that folder...

 

[Garth]

Hello, Sorry for the time

this is the error: the file is missing this one...

weird as you can see is looking for another Root to installed... anything I do still goes to that folder.
after remove the rp role, it deletes that folder( i try creating the folder and copy the file) and back to the same.

That's the srsrpsetup.lorg

V:\SMS_SRSRP\srsserver.dll.

Looks like something is tellin it to install it in that folder...

I think it is a reg key that is telling it to go to V:\. Start by removing the RP point. Clean out this reg key. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\SRSRP then reinstall the RP.

 

[abreton]

I think it is a reg key that is telling it to go to V:\. Start by removing the RP point. Clean out this reg key. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\SRSRP then reinstall the RP.

I did, haven't see the folder back in V: SRSS haven got install correct either...

 

[Garth]

I did, haven't see the folder back in V: SRSS haven got install correct either...

ok so what are the logs saying now?