Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 12:35 PM
Points: 15,375, Visits: 13,118
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 SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1183390
Posted Saturday, October 1, 2011 4:38 AM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Today @ 6:21 AM
Points: 9,700, Visits: 11,746
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 @ 4:18 AM
Points: 6,141, Visits: 13,652
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