upgrade order of components

• sqlfriend

  SSC Guru

  Points: 52792

  More actions

  February 16, 2024 at 8:11 pm

  #4379910

  I am upgrade a SQL server 2019 instance, it has both DB engine, SSIS service , SSRS service in same server due to it only host a small application.

  Now I would like to upgrade it from 2019 to 2022 and CU11,  My question is about the order,

  My order is like this, simplified:

  1. upgrade DB engine and SSIS to 2022.   2. then apply CU11.   3. install 2022 SSRS and reconfigure it

  Or should I do 3 first, then 2.

  Or it does not matter.

  Thanks

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  February 17, 2024 at 9:10 pm

  #4380380

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Lowell

  SSC Guru

  Points: 323518

  More actions

  February 18, 2024 at 10:44 am

  #4380591

  the SQL2022 CU11 patch potentially covers SSRS and SSAS as well. as a result, I would recommend the following:

  1. if you use UNC paths for your backup directory, you must change it to a local directory
  2. i change mine from \\domainserver\SQLBackups to whatever is the data directory for the duration of the upgrade, then change it back.
  3. in place upgrade of SQL2019 to SQL2022
  4. install SSRS 2022
  5. Run the patch for CU11

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• frederico_fonseca

  SSCoach

  Points: 16207

  More actions

  February 18, 2024 at 12:01 pm

  #4380610

  but do investigate all performance issues with 2022 before upgrading - many reporting 20 to 40% slower queries.