SOLVED SCCM Reporting not working after DB migration in console

[chrisj76]

Configuration Manager 2309
Microsoft SQL Server 2022 Reporting Services 16.0.1115.61
CM Database SQL Server 2022
Last week we migrated the CM Database to new supported SQL Server, today we moved the reporting service to a separate server that has SSPR running on it.
All the ConfigMgr_xxx reports are accessible via the web service link and run.



Within the console shows the Links to the correct SQL Reporting Services.
When going to Reporting > Reports in the Console they are empty.
Under Report Options I can select the Report Services Point but then get the following error.



have checked the srsp.log and can not see any errors.

I did see an blog that said the to change SQL Server Reporting Services service as Local System. But our SQL Systems and Database Administrator are running all SQL Server services using domain account (pre recommended by Microsoft)

Has anyone else had this issue?

 

[Garth]

Configuration Manager 2309
Microsoft SQL Server 2022 Reporting Services 16.0.1115.61
CM Database SQL Server 2022
Last week we migrated the CM Database to new supported SQL Server, today we moved the reporting service to a separate server that has SSPR running on it.
All the ConfigMgr_xxx reports are accessible via the web service link and run.

View attachment 6959

Within the console shows the Links to the correct SQL Reporting Services.
When going to Reporting > Reports in the Console they are empty.
Under Report Options I can select the Report Services Point but then get the following error.

View attachment 6958

have checked the srsp.log and can not see any errors.

I did see an blog that said the to change SQL Server Reporting Services service as Local System. But our SQL Systems and Database Administrator are running all SQL Server services using domain account (pre recommended by Microsoft)

Has anyone else had this issue?

Did you reinstall the Reporting Point in ConfigMgr? Did you open the firewall ports on the SSRS server?

 

[chrisj76]

Did you reinstall the Reporting Point in ConfigMgr? Did you open the firewall ports on the SSRS server?

the Reporting Point role was installed on the New SSRS server and removed off the old SSRS server. there is no firewall between the servers.

 

[Garth]

the Reporting Point role was installed on the New SSRS server and removed off the old SSRS server. there is no firewall between the servers.

What about the local firewall on the ssrs server? On a remote computer can you access the ssrs website for both urls? Admin and website.

 

[chrisj76]

What about the local firewall on the ssrs server? On a remote computer can you access the ssrs website for both urls? Admin and website.

there are no firewalls
can access both SSRS url per the screen shot attached - is only the console that that can't and have tired it from the site server, local installed copy of the console on other devices all have the same issue.

 

[Garth]

there are no firewalls
can access both SSRS url per the screen shot attached - is only the console that that can't and have tired it from the site server, local installed copy of the console on other devices all have the same issue.

It is important for clarity to know if you can access both urls listed on this page? And yes I have 3 reporting points in my lab.

 

[chrisj76]

View attachment 6968

It is important for clarity to know if you can access both urls listed on this page? And yes I have 3 reporting points in my lab.

View attachment 6966

 

[chrisj76]

the SSRS are showing in the console

 

[Garth]

the SSRS are showing in the console

View attachment 6969

But can you get to both urls from a browser?