Open Reporting Services Configuration Manager.The other option will be removing and reinstalling SSRS and reconnecting the existing DB with the encryption key. When I saw this, I had the option to roll back the server to before the upgrade.
Sql server management studio 17 configuration manager upgrade#
Yah, I know I could do 2017, but my organization is standardizing on 2016 for now. In the blog post, I will take you through the process of upgrading from SQL 2012 SP3 up to SQL 2016. Once I figured it out for me, I thought I would share.
So, as I began the upgrade process, I found all the resources I found out there to be incomplete. Now the SQL upgrade isn't a requirement (yet), just the native client update. So, why am I looking at this now? Well, CM 1810 introduced a pre-req check for a never version of the SQL native client. So, a number of CM environments are still running 2012. Why? Because when we built our CM 2012 environment, that's what was the latest for SQL at the time. I'm guessing that a number of us are still running SQL 2012. With how easy it is to upgrade Configuration Manager now, it can be easy to forget about the most important component of your CM infrastructure, SQL.