I'm guessing a missed a step somewhere. I'm trying to upgrade an existing 2000 reporting service database to 2008.
I took a backup of the reportserver database and reportservertmpdb database. I restored both copies. I backedup and restored the encryption keys. I used the reporting services config manager to change the current database to the one i just restored. Everything
seemed to go ok.
When i try to open the url, i get the following error:
|Invalid object name 'ReportServerTempDB.dbo.TempCatalog'. Could not use view or function 'ExtendedCatalog' because of binding errors.
Any idea what i've missed?
View Complete Post