{"id":8698,"date":"2025-04-04T04:24:42","date_gmt":"2025-04-04T04:24:42","guid":{"rendered":"https:\/\/pariswells.com\/blog\/?p=8698"},"modified":"2025-04-08T00:57:30","modified_gmt":"2025-04-08T00:57:30","slug":"how-to-upgrade-sql-2016-to-sql-2019-reporting-services-in-azure","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/research\/how-to-upgrade-sql-2016-to-sql-2019-reporting-services-in-azure","title":{"rendered":"How to upgrade SQL 2016 to SQL 2019 Reporting Services in Azure"},"content":{"rendered":"\n<p>You will need to spin up a new VM with the SQL 2019 Installer in C:\\SQLFullInstall then map this to the server you are upgrading<\/p>\n\n\n\n<p><strong>Backup Encryption Keys<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/04\/image.png\"><img loading=\"lazy\" decoding=\"async\" width=\"973\" height=\"301\" src=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/04\/image.png\" alt=\"\" class=\"wp-image-8699 img-responsive\" srcset=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/04\/image.png 973w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/04\/image-300x93.png 300w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/04\/image-768x238.png 768w\" sizes=\"auto, (max-width: 973px) 100vw, 973px\" \/><\/a><\/figure>\n\n\n\n<p><strong>Backup DB&#8217;s<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/04\/image-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"443\" height=\"33\" src=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/04\/image-1.png\" alt=\"\" class=\"wp-image-8700 img-responsive\" style=\"width:483px;height:auto\" srcset=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/04\/image-1.png 443w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/04\/image-1-300x22.png 300w\" sizes=\"auto, (max-width: 443px) 100vw, 443px\" \/><\/a><\/figure>\n\n\n\n<p><strong>Backup Settings<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/04\/image-2.png\"><img loading=\"lazy\" decoding=\"async\" width=\"416\" height=\"532\" src=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/04\/image-2.png\" alt=\"\" class=\"wp-image-8701 img-responsive\" srcset=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/04\/image-2.png 416w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/04\/image-2-235x300.png 235w\" sizes=\"auto, (max-width: 416px) 100vw, 416px\" \/><\/a><\/figure>\n\n\n\n<p>Run the SQL 2019 Installer and Run the Upgrade<\/p>\n\n\n\n<p>*Save the CD Key used embedded as you will need this from the SQL Reporting Installer<\/p>\n\n\n\n<p>Remove Reporting Services and Install the new version<\/p>\n\n\n\n<p>Install  SQL Reporting Installer with Key from the SQL Enterprise Installer<\/p>\n\n\n\n<p>Open SQL Reporting Configuration and set the DB back to ReportingServer<\/p>\n\n\n\n<p>Restore the Encryption Keys<\/p>\n\n\n\n<p>Restore the Settings<\/p>\n\n\n\n<p>Some Settings SMTP will be in the config file like SMTP Port<\/p>\n\n\n\n<p>Old Server<\/p>\n\n\n\n<p>C:\\Program Files\\Microsoft SQL Server\\MSRS13.MSSQLSERVER\\Reporting Services\\ReportServer<\/p>\n\n\n\n<p>New Server<\/p>\n\n\n\n<p>C:\\Program Files\\Microsoft SQL Server Reporting Services\\SSRS\\ReportServer\\rsreportserver.config<\/p>\n\n\n\n<p>Remove the Old One<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/04\/image-4.png\"><img loading=\"lazy\" decoding=\"async\" width=\"962\" height=\"400\" src=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/04\/image-4.png\" alt=\"\" class=\"wp-image-8703 img-responsive\" srcset=\"https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/04\/image-4.png 962w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/04\/image-4-300x125.png 300w, https:\/\/pariswells.com\/blog\/wp-content\/uploads\/2025\/04\/image-4-768x319.png 768w\" sizes=\"auto, (max-width: 962px) 100vw, 962px\" \/><\/a><\/figure>\n\n\n\n<p>Logs<\/p>\n\n\n\n<p>C:\\Program Files\\Microsoft SQL Server Reporting Services\\SSRS\\LogFiles<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You will need to spin up a new VM with the SQL 2019 Installer in C:\\SQLFullInstall then map this to the server you are upgrading Backup Encryption [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-8698","post","type-post","status-publish","format-standard","hentry","category-research"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/8698","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/comments?post=8698"}],"version-history":[{"count":2,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/8698\/revisions"}],"predecessor-version":[{"id":8734,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/8698\/revisions\/8734"}],"wp:attachment":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/media?parent=8698"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/categories?post=8698"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/tags?post=8698"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}