I recently submitted an article to SQLServerCentral about my adventures in upgrading my existing SSRS 2005 instance to 2008. In the article I described the steps taken to successfully upgrade a 2005 instance to 2008. My initial attempt, which I spoke about in the article, was a cut and dry upgrade. The entire process was Point, Click and Go. That wasn’t the case when I attempted the upgrade on our actual Development Web Server that hosts our Reporting Services instance. Towards the end of the install I received the following error:
Fortunately we have Premier Support with Microsoft. I called Microsoft around 9 AM CST, and after about 5 hours of digging through the install logs the Support Engineer solved the problems. I just have to say, hats off to the engineer, she did an excellent job. So, I decided to give it another shot on another server. I, of course, received the same error. Unfortunately, I hadn’t received the summary of work from the engineer and as a result I was back in the same place, stuck. I had written down a few steps and decided to give them a try. I did receive this error before according to my notes and the only thing that needed to be done was restart the install, choose the Maintenance Option and run a repair. Once the repair was complete I was able to finalize the installation and everything was up and running. Thanks Microsoft Support.
Talk to you soon
Patrick LeBlanc, Founder TSQLScripts.com and the SQLLunch
SQL Down South