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 «««123

Installating SSIS with Named Instance Expand / Collapse
Author
Message
Posted Thursday, September 29, 2011 12:23 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 11:42 AM
Points: 13,295, Visits: 11,086
Interesting question, thanks a lot!



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 #1183390
Posted Saturday, October 1, 2011 4:38 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:45 AM
Points: 7,804, Visits: 9,556
Good question.

There's one flaw though: If SSIS was installed at the same time as the named instance, there's nothing to do - the installation process does it all for you.

If it was installed after the named instance, but before the default 2008 installation, you will already have had to modify the config data to make it work at all before you get to the 2008 install.

If it's installed at the same time as or after the default 2008 installation, it will be set up to use the default instance's MSDB so the config file will have to be modified in these cases too.


Tom
Post #1184039
Posted Tuesday, October 11, 2011 7:07 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 1:38 AM
Points: 5,879, Visits: 13,010
nice to see this type of question rather than all those coding ones!

---------------------------------------------------------------------

Post #1188412
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse