Wednesday 27 May 2009
Sql Server 2008 side by side install - Reporting service error
We are in the process of upgrading from SQL Server 2005 to SQL Server 2008. We wanted to do an install of SQL 2008 side by side with SQL 2005 so that we could test databases before migrating them to SQL 2008.
When installing SQL 2008 I did a full install and choose the option to configure Reporting Services 2008 to be ready to use. This was a MISTAKE as it seems that the SQL 2008 install overwrites the encryption key used by Reporting Services 2005. when I tried to view 2005 reports it stated that the encryption key was invalid for the installation.
Luckily we had a backup of the encryption key so we restored the key and all the reports came back.
So if you are using SQL 2005 Reporting and want to install SQL 2008 side by side then don't install Reporting Services 2008.