A bit of background to what this is about.
I was busy moving one of my larger clients’ SQL Server Reporting Services from a seperate box to their production machine, which by the way is a MONSTER.
As the target machine is production, it obviously had the latest Service Packs intalled for SQL Server, up to version Service Pack 2.
The production server never has SQL Reporting Services installed so I jumped right in and started installing.
So far so good.
But the problem arose when trying to create the Reporting database. It would create the database, but will then give the following error:
The database version (C.0.8.40) does not match your reporting services installation
I played around and just could understand what could be wrong, then it hit me, I installed this from the SQL Server 2005 standard disk, and obviously did not have the Service Pack 2 updates.
The solution to the problem at last ! I installed Service Pack 2 and everything work fine after that.
DO NOTE : In some cases the Service Pack will require a reboot of the machine. Lucky for me they had a scheduled reboot the day I performed this move.