Unable to upgrade reporting services from 2016 to 2017
Hello
I'm having some trouble following this Microsoft document:
https://docs.microsoft.com
I have successfully upgraded my SCOM instance to 1807. I have also successfully upgraded the SQL database instance from 2016 to 2017, as that is now supported. However, I am unable to upgrade reporting services successfully. According to the release notes of SCOM 1807, upgrading from SQL 2016 to SQL 2017 is supported, but not for fresh installations. I find it curious then, that this upgrade guide instructs a removal of Operations Manager Reporting Services, and after upgrading SSRS, to install Operations Manager Reporting Services again. So, either I’m not reading this document correctly, or nobody has tried to follow it yet, including its creators.
How does one reinstall Operations Manager Reporting Services when using SQL 2017 Reporting Services? There is no 1807 fresh installation media as far as I am aware, so naturally, the 1801 installation media gives me this error when trying to reinstall:
The installed version of SQL Server could not be verified or is not supported. Verify that the computer and the installed version of SQL Server meet the minimum requirements for installation, and that the firewall settings are correct. See the Supported Configurations document for further information.
Would anyone have a workaround for this at all, or should I just go back to SQL 2016 SSRS?
I'm having some trouble following this Microsoft document:
https://docs.microsoft.com
I have successfully upgraded my SCOM instance to 1807. I have also successfully upgraded the SQL database instance from 2016 to 2017, as that is now supported. However, I am unable to upgrade reporting services successfully. According to the release notes of SCOM 1807, upgrading from SQL 2016 to SQL 2017 is supported, but not for fresh installations. I find it curious then, that this upgrade guide instructs a removal of Operations Manager Reporting Services, and after upgrading SSRS, to install Operations Manager Reporting Services again. So, either I’m not reading this document correctly, or nobody has tried to follow it yet, including its creators.
How does one reinstall Operations Manager Reporting Services when using SQL 2017 Reporting Services? There is no 1807 fresh installation media as far as I am aware, so naturally, the 1801 installation media gives me this error when trying to reinstall:
The installed version of SQL Server could not be verified or is not supported. Verify that the computer and the installed version of SQL Server meet the minimum requirements for installation, and that the firewall settings are correct. See the Supported Configurations document for further information.
Would anyone have a workaround for this at all, or should I just go back to SQL 2016 SSRS?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.