question

DunvilleJohn-9057 avatar image
0 Votes"
DunvilleJohn-9057 asked DunvilleJohn-9057 commented

Upgrading SQL Server 2014 to 2019 but retaining reporting services

Hello,

I have a SQL server with 2x SQL server 2014 instances. One of these instances has an SSRS (Native) install and I want to upgrade both instances (In Place) to SQL server 2019. I know that upgrade of the SSRS element is not possible in this scenario (2014 > 2019)

My question is if I did the upgrade to SQL server 2019 on the instance with SSRS, would the SSRS 2014 installation still function? Is this scenario possible?

Thanks for any reply.

sql-server-generalsql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

BjoernPeters avatar image
0 Votes"
BjoernPeters answered DunvilleJohn-9057 commented

I would think that the answer might be "yes, it will continue to work," but I can't promise.

Another way to try can be:
1.) Inplace Upgrade of that instance without SSRS

  1. Install a third instance with 2019 - migrate everything from the SSRS instance

  2. Uninstall all of the remaining unnecessary 2014 features/services

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Bjoern,

Thank you for your reply. Yes this could be an option. I could install SSRS on instance 2 after its been upgraded and migrate the reports to this instance. Some discussions to be had with the application \ report owners.

Thanks again and have a great weekend.

John

0 Votes 0 ·
Isabellaz-1451 avatar image
1 Vote"
Isabellaz-1451 answered DunvilleJohn-9057 commented

Hi @DunvilleJohn-9057

Generally speaking, it's okay for SSRSto have a lower version number than SQL server, but since SSRS has been separated from SQL server since version 2017, I don't know if this is compatible, but I think it should be compatible. you can upgrade SQL server first , then see if SSRS 2014 can work normally, if it works well,then don‘t need to upgrade the SSRS. if not, upgrade SSRS to SSRS2017 or SSRS 2019.

Here is official document about how to upgrade the SSRS ,you can take a reference:https://docs.microsoft.com/en-us/sql/reporting-services/install-windows/upgrade-and-migrate-reporting-services?view=sql-server-ver16

Upgrade to Reporting Services 2017 and later from Reporting Services 2016 and older isn’t the same upgrade scenario as in previous versions. When upgrading to Reporting Services 2016 and older versions, you could following an in-place upgrade process using SQL Server installation media. When upgrading to Reporting Services 2017 and later from Reporting Services 2016 and older, you can’t follow the same steps because the new Reporting Services installation is a standalone product. It's no longer part of the SQL Server installation media.

To upgrade from Reporting Services 2016 and older versions to Reporting Services 2017 and later, follow the Migrate a Reporting Services Installation (Native Mode) article, with Reporting Services 2017 or later as your destination instance.

Best Regards,
Isabella


If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
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.




· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Isabella your comments on upgrade are noted thank you.
I had considered and read the linked literature on upgrade when I set about looking at the task in hand. I suppose I have a few avenues to explore here and some decisions to make.

I may install reporting services on the other, instance (after upgrade) and then ask my monitoring team (who own the applications being hosted) if I can move their reports to this instance.

Thanks again for your reply

Have a great weekend :)

John

1 Vote 1 ·