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

Stephan van Helden 26 Reputation points
2022-07-10T07:48:07.077+00:00

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":

219199-image.png

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

Microsoft Configuration Manager
0 comments No comments
{count} votes

Accepted answer
  1. Amandayou-MSFT 11,021 Reputation points
    2022-07-10T16:10:28.363+00:00

    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.

    0 comments No comments

3 additional answers

Sort by: Most helpful
  1. Garth 5,786 Reputation points
    2022-07-10T12:48:55.4+00:00

    Did you check the firewall port are open?

    0 comments No comments

  2. Stephan van Helden 26 Reputation points
    2022-07-10T13:00:39.353+00:00

    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.

    0 comments No comments

  3. Stephan van Helden 26 Reputation points
    2022-07-10T14:19:56.167+00:00

    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.

    0 comments No comments