Thursday, May 03, 2012 3:10 PM
All, We have a database server that hosts 3 different SSRS databases plus other databases. The web components are hosted on thier own web server and not on the same box as our databases. This is what I would like to do in order to start upgrading to 2012.
Upgrade the Database server that holds the 3 SSRS DBs and other DBs to SQL 2012 and only upgrade one of the SSRS web servers to 2012. If we do not upgrade 2 of the SSRS web servers, will the SSRS database being 2012 still work on SSRS 2008 web server? Do I need to upgrade all the web servers at once? At this time due to resources, I can only upgrade one SSRS web server to 2012. This is why I only plan to upgrade one SSRS DB.
Let me know if this approach is OK to proceed with or an alternative solution. thanks
Saturday, May 05, 2012 5:18 AM
I think you're treading off a supported path with that configuration, and my advice would be not to do this. If you had any trouble in production, you might be in a lonely place when looking for help.
A less risky approach, if you're open to it, is to add a SQL 2012 instance to your existing DB server so you can maintain both 2008 and 2012 SSRS environments in supported configurations. A single database server can have multiple instances, and those instances can be different SQL versions.
You could install the new 2012 (named) DB instance, and move the SSRS DB that will be upgraded to that instance. OTOH if you want to keep the same instance name for 2012, you could first install a second (named) instance of 2008, move the two SSRS databases that will stay 2008 to that instance, then upgrade the current instance as a standard "in-place upgrade" of SSRS 2012.
The upside of doing something like this is you'd be staying within a proven configuration while still accomplishing your goals of having one SSRS 2012 instance and two SSRS 2008 instances with no additional hardware.
Rob Kerr SQL Server MVP CTO, BlueGranite
- Marked As Answer by Elvis LongMicrosoft Contingent Staff, Moderator Friday, May 11, 2012 3:24 AM