Any reason NOT to only upgrade SSIS, SSRS, and SSAS Servers to 2012 while leaving Database engine at 2008 R2?
-
Monday, December 03, 2012 6:44 PM
Can anyone tell me why it would or would not be a bad idea to only upgrade SSIS, SSRS, and SSAS servers to 2012 while leaving the database engine at 2008 R2?
Due to the changes in licensing I was wondering if this might be a viable option.
Thank you!
- Moved by Tom Phillips Monday, December 03, 2012 8:37 PM Upgrade question (From:SQL Server Database Engine)
- Edited by MMilligan Thursday, December 13, 2012 8:30 PM deleted Word code that was pasted in there (bug in Word?)
All Replies
-
Tuesday, December 04, 2012 4:02 PM
I think if you run the upgrade to SQL Server 2012 and choose to upgrade your instance, it will upgrade all services of that instance: Database Engine, SSRS, SSAS, SSIS.
Correct me if I am wrong.
- Edited by irusulMicrosoft Community Contributor Tuesday, December 04, 2012 4:03 PM
-
Wednesday, December 05, 2012 3:02 AMModerator If all the instance based features share the same instance name then it is correct that Upgrade will upgrade all features for the instance specified in addition to any shared features (ie. SSIS). If the instance features do not share the same instance name then you can upgrade them individually.
This posting is provided "AS IS" with no warranties, and confers no rights.
- Marked As Answer by Maggie LuoMicrosoft Contingent Staff, Moderator Wednesday, December 19, 2012 8:37 AM
-
Thursday, December 13, 2012 8:28 PM
If all the instance based features share the same instance name then it is correct that Upgrade will upgrade all features for the instance specified in addition to any shared features (ie. SSIS). If the instance features do not share the same instance name then you can upgrade them individually.
This posting is provided "AS IS" with no warranties, and confers no rights.
In our case, each piece of the stack (SSRS, SSIS, SSAS, and the Relational Database Engine) resides on their own server and therefore own instance.
Thank you for your responses!
.png)
