Upgraded ConfigMgr database to SQL 2019, now Report Server instance not detected

Question

I updated the SQL server instanced used by ConfigMgr from SQL 2014 to SQL 2019.

That version is supported per https://learn.microsoft.com/en-us/mem/configmgr/core/plan-design/configs/support-for-sql-server-versions.

Upgrade to any supported version is supported per https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/upgrade-on-premises-infrastructure.

SQL Server upgrade required to remove installed instance of SQL Server Reporting Services and install SQL Server Reporting Services 2019 as a separate component instead. I followed instructions, and Reporting Services are working, I can reach the /Reportserver and /Reports URLs, and I granted permission to ConfigMgr server and the accounts used by it. However, the instance name of SSRS is now <servername>\SSRS, no longer <servername>\SYSTEMCENTER as before. (Did not find a way to use a different instance name.)

Now, this instance was no longer found by ConfigMgr (probably due new name). So I tried to remove and reinstall the Reporting Services Point - but that fails because "Unable to locate any configured SRS instances on the server":

What could I do, or which log could I investigate to find out more?

Answer 1

Hi @Stephan van Helden ,

Thank you very much for your feedback and sharing. We're glad that the question is solved now. I think maybe other peoples with the same needs will benefit from it. Here's a short summary for the problem.

Problem/Symptom:
Upgraded ConfigMgr database to SQL 2019, now Report Server instance not detected

Solution:
Kindly run Configuration Manager Console with an account that has admin rights on the SSRS server.

---

If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Did you check the firewall port are open?

Answer 3

Yes, both servers are on the same subnet and have their firewalls disabled. Also all other communications is working, access to SQL, WMI, SMB, Reporting Services website etc.

Answer 4

Seems fixed. I had to run Configuration Manager Console with an account that has admin rights on the SSRS server. It uses the specified account for actually accessing the server later, but not for detecting SSRS instances during configuration.