December 6, 2011 at 9:23 am
We would like to upgrade our reporting server that is installed on a separate server from another SQL server that has their source user databases. Howerver the reportserver and reporttempdb are installed on the same server as the reporting service.
My question is if we upgrade the reporting server from SQl server 2005 to 2008, but the reports data source databases are still on 2005 server, is that OK?
In other word, reporting server SQL server is at 2008, but their data source databases are on a SQL 2005 box, is that OK?
Thanks
December 6, 2011 at 9:27 am
I know you can have RS 2008 use 2005 as datasource.
I'm not sure I understand your upgrade process tho. If it's on a new machine then super easy to test and 0 risk. Not the case if you do in place upgrade.
December 6, 2011 at 9:31 am
if i am reading this right, you want to install SSRS 2008 but leave the ReportServer and ReportServerTempDB on SQL 2005 as SQL 2005 databases, not new databases created with the new install of SSRS2008?
Yes you can, please see the following link
http://msdn.microsoft.com/en-us/library/ms157300.aspx
Select a database server
Reporting Services requires a SQL Server 2005, 2008, or 2008 R2 Database Engine instance to host the report server database. You can use a local or remote server.
how ever backup your SSRS 2005 encryption keys so that they can be restored to the new SSRS2008 server
edit
i would do this as a side by side upgrade, not an inplace upgrade
December 6, 2011 at 12:54 pm
Sorry, I didn't make it clear.
In our enviroment is : install SQL database engine and integration service on one server, and then install SQL reporting service on another server along with a database engine that only hosts reporting server databases.
The project now is we want to do the upgrade of the reporting server along with its db engine on the same box.
But we won't upgrade the other server yet that has databases the reporting server use as data source for creating reports.
Ninja's_RGR'us kind of answered my question, but I don't think I can test that.
And I think this is usually a situation that many people have experience about, so like to ask before I implement.
Thanks
December 6, 2011 at 3:08 pm
The only thing I know for sure is that you can use SSRS 2008 and connect to sql 2005 (to fetch the report's data)... along with plenty other versions and even other rdbsm.
That being said, I have no idea of what would happen in your env. Any way to clone the machine to do a test? It's the best way after all...
December 6, 2011 at 3:43 pm
Ninja's_RGR'us (12/6/2011)
The only thing I know for sure is that you can use SSRS 2008 and connect to sql 2005 (to fetch the report's data)... along with plenty other versions and even other rdbsm.
That is all I want to know, thanks
December 6, 2011 at 6:00 pm
sqlfriends (12/6/2011)
Ninja's_RGR'us (12/6/2011)
The only thing I know for sure is that you can use SSRS 2008 and connect to sql 2005 (to fetch the report's data)... along with plenty other versions and even other rdbsm.That is all I want to know, thanks
Cool, as long as we're clear I am talking about the datasets and not the reports' definition kept in the rs "system" databases. 🙂
December 7, 2011 at 1:34 am
i would prefer to do this side by side if at all possible that way you have a good rollback plan should it all go the wrong way.
if you have to do an in place upgrade, is the SSRS server a physical server or a virtual server?
if virtual before you do the upgrade ask your VM people to do a snapshot of the box
if its physical, get something like acronis or ghost and do a full server backup to be on the safe side
backup the encryption keys from SSRS2005 and copy the snk file to a number of locations, then backup the ReportServer database and copy it to a number of different locations, detach the ReportServer database and copy it to a location, then uninstall 2005, reboot, install 2008, restore the RS database, configure 2008 SSRS, upload the encryption keys and then test
an other option is that if you have the solutions which the reports where deployed from, you can uninstall 2005, reboot, install 2008, configure 2008, brand new RS database, then redeploy the projects
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply