July 29, 2013 at 6:48 am
Hi guys, hope someone can help me out.
This msdn article: http://msdn.microsoft.com/en-us/library/ms143731.aspx suggests that SSIS 2012 can be installed on the same server as SSIS 2008, although confusingly in the Instance Configuration section it says only one instance of SSIS can be installed on a computer.
Can you tell me if I can run both on the same server and if so how do I get SSMS to recognise the 2012 instance? The SSIS installation has gone fine, onto a Server 2008 R2 box, and I can see that the services are running, but SSMS only picks up the SSIS 2008 instance.
Any advice appreciated.
July 29, 2013 at 7:10 am
I think what the article means is that you cannot install for example SSIS 2012 twice on the same machine, but you can install SSIS 2008 and 2012 on the same machine. You'd have to modify one of the configuration files of the service though, to point to the correct MSDB database.
The problem is that SSIS is instance unaware, so SSMS will look for only one instance. Not sure on how to solve this.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 29, 2013 at 7:13 am
Thanks Koen,
I think I may have found a solution. Both instances run OK, but you need to use SSMS 2008 to manage the SSIS 2008 instance and SSMS 2012 to manage the SSIS 2012 instance.
Tony
July 29, 2013 at 12:48 pm
tbraithwaite (7/29/2013)
Thanks Koen,I think I may have found a solution. Both instances run OK, but you need to use SSMS 2008 to manage the SSIS 2008 instance and SSMS 2012 to manage the SSIS 2012 instance.
Tony
I was thinking about that option and thought: "Nah, that would be too easy for Microsoft" 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 9, 2016 at 8:16 am
This thread is old but I have the same question now. We want to know if we can install SSIS 2012 and 2014 on the same server. Was this successful or no?
March 9, 2016 at 10:46 am
raygaitherjr (3/9/2016)
This thread is old but I have the same question now. We want to know if we can install SSIS 2012 and 2014 on the same server. Was this successful or no?
Never tried it.
SSIS is instance unaware, so it might still be an issue.
But, if you use the project deployment model, SSIS is contained in the SSIS catalog.
Only one way to know for sure: test it out 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply