I know this is an old thread, but I am having a similar issue that maybe you can help with. I am trying to move a SQL Server 2005 reporting database to SQL Server 2008 R2. I want to keep the old database up - we are going to have both available for a certain time. So, I backed up the 2005 ReportServer and ReportServerTempDB and restored them on 2008. This gave an issue because of, I think, structure changes in the 2008 TempDB. So, I started from scratch, and restored ONLY the ReportServer and not the ReportServerTempDB.

The site seems to be working - I can access it without getting any errors. But all the permissions did not seem to get copied over. Is there something else I need to copy over from 2005 to get everything the same in 2008 security wise? I'd hate to have to manually set the permissions on each report, as there are tons. Please advise on what steps I need to do to copy a SQL Server 2005 reporting services database to a SQL Server 2008 R2 database. Both are upgraded to the latest SPs if that helps any.

Thanks!