when i moved the ssrs from one 2008 r2 server to another by backin up and restoring the report server and report server tempddb databases over to the new server. i restored the encryption file on the other server, when i access the report manager link, i see an error Invalid object name 'ReportServerTempDB.dbo.TempCatalog'. Could not use view or function 'ExtendedCatalog' because of binding errors. Pls help Nik

Hi, Try not to copy report server tempdb from the old server and then try again. Please share the results. CheersPlease Mark as Answer or Vote As Helpful if a post solves your problem. MCP, MCTS, MCITP

the microsoft documentation says that even the reportservertem needs to be copied and restored plus, this instance that i moing to is a named instance and the ReportServer is named ReportServer$DSSNTX . if you need me to restore the original reportservertempdb , i will do that, any harm ??

If you can, just test the solution I mentioned. Just restore "ReportServers$YOUR_INSTANCE_NAME" and encryption key as well but not ReportServer TempDB. Also, please take a look at the threads below: http://msdn.microsoft.com/en-us/library/ms143724(v=sql.105).aspx http://msdn.microsoft.com/en-us/library/ms156421(v=sql.105).aspx CheersPlease Mark as Answer or Vote As Helpful if a post solves your problem. MCP, MCTS, MCITP

i restored the original reportserver$instanacenametempdb which was the servers original database, but same error