Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2012 SSIS and SQL 2008 R2 SSIS - 2 instances Expand / Collapse
Author
Message
Posted Tuesday, July 09, 2013 1:27 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, April 11, 2014 7:37 AM
Points: 2,673, Visits: 3,325
We have upgraded a dev server from 2008 R2 to 2012. Because 2 apps are staying on 2008 R2, we have installed a named instance on the same box. We use global env. variables for SSIS_Config_Servername in a normal env. Can we create a second for the 208 R2? Can we support multiple instances with SSIS? So far, I cannot login to SSIS on the named instance with error:

SSIS service does not support multi-instance, use just server name instead of "server name\instance"

So... does everything else have to be on the named instance instead of the new?


Thanks,

Jared
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
Post #1471821
Posted Tuesday, July 09, 2013 2:52 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:35 AM
Points: 12,208, Visits: 9,172
SQLKnowItAll (7/9/2013)
We have upgraded a dev server from 2008 R2 to 2012. Because 2 apps are staying on 2008 R2, we have installed a named instance on the same box. We use global env. variables for SSIS_Config_Servername in a normal env. Can we create a second for the 208 R2? Can we support multiple instances with SSIS? So far, I cannot login to SSIS on the named instance with error:

SSIS service does not support multi-instance, use just server name instead of "server name\instance"

So... does everything else have to be on the named instance instead of the new?


Not 100% sure, but it might be possible if you install the 2008R2 instance but don't deploy to it. Instead use the file share to store the packages and run them yourself using the 2008R2 DTEXEC version. Might be worth a shot?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1471862
Posted Tuesday, July 09, 2013 3:06 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, April 11, 2014 7:37 AM
Points: 2,673, Visits: 3,325
Worth trying man.. Thanks. Anyone else? MVPs? Doesn't it seem strange that you upgrade and can't use the other instance? There has to be a way around... Just as I've learned to use 2 ips with 1433...

Thanks,

Jared
SQL Know-It-All

How to post data/code on a forum to get the best help - Jeff Moden
Post #1471872
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse