I posted this in the RS forum as well but was thinking it would be better here. I'm not sure if I can move a post to a different forum or not so sorry for the double post.
I have a RS 2005 install in which the ReportServer and ReportServerTempDB databases reside on a different SQL Server 2005 server. I am planning to upgrade both to 2008 at some point but would like to do the SQL database engine first. So I would be running
something like this:
Server A: SQL 2005 Reporting Services
Server B: SQL 2008 database engine - housing ReportServer and ReportServerTempDB
Is this configuration supported? If I do this would I just need to run the DB's in 9.0 compatibility mode until we upgrade the RS server? Would it be better to upgrade the RS box first or both of them at the same time instead of doing the database engine
View Complete Post