InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 14:04:58 GMT20http://www.sqlservercentral.com/Forums/Topic1182174-2857-1.aspxnice to see this type of question rather than all those coding ones!Tue, 11 Oct 2011 07:07:46 GMTgeorge sibbaldhttp://www.sqlservercentral.com/Forums/Topic1182174-2857-1.aspxGood 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.Sat, 01 Oct 2011 04:38:42 GMTL' Eomot Inverséhttp://www.sqlservercentral.com/Forums/Topic1182174-2857-1.aspxInteresting question, thanks a lot!Thu, 29 Sep 2011 12:23:35 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1182174-2857-1.aspxMy answer was based on the logical understanding of instance configurations. And yes I got it correct. Good QoTD. Thanks.Wed, 28 Sep 2011 23:38:16 GMTCoolCodeSharehttp://www.sqlservercentral.com/Forums/Topic1182174-2857-1.aspxThanks for the question.Wed, 28 Sep 2011 16:52:23 GMTTrey Stakerhttp://www.sqlservercentral.com/Forums/Topic1182174-2857-1.aspxInteresting question. We typically use the file system so I haven't had to encounter this.Wed, 28 Sep 2011 15:32:06 GMTKWymorehttp://www.sqlservercentral.com/Forums/Topic1182174-2857-1.aspxHow timely. I just added a note to this MSDN article yesterday to explain how to deal with multiple instances in a cluster when SSIS is not a cluster resource. This allows you to store your packages in MSDB rather than having to use the file system, which has the advantage of using server storage to protect passwords rather than a user key. The only other thing to watch is the DCOM permissions, and running agent jobs using a proxy tied to a credential that is a member of the local Distributed COM Users group on each cluster node is a great way to manage those permissions. This ensures that agent jobs will be successful regardless of which node an instance is running on.Wed, 28 Sep 2011 13:47:21 GMTJoshua M Perryhttp://www.sqlservercentral.com/Forums/Topic1182174-2857-1.aspxI got it right with a lucky guess! Thanks for the question.Wed, 28 Sep 2011 11:26:26 GMTBritt Cluffhttp://www.sqlservercentral.com/Forums/Topic1182174-2857-1.aspxGreat question, caught me on this one. But now I know better.:-)Wed, 28 Sep 2011 10:05:08 GMTMiles Nealehttp://www.sqlservercentral.com/Forums/Topic1182174-2857-1.aspxI had no idea but made a lucky guess based on the answer that looked like it might be correct.Wed, 28 Sep 2011 09:44:39 GMTCliff Joneshttp://www.sqlservercentral.com/Forums/Topic1182174-2857-1.aspxGreat question. The referenced article has a really good overview of how this all hangs together, too. Definitely learned something today!Wed, 28 Sep 2011 09:38:12 GMTRob Schripsemahttp://www.sqlservercentral.com/Forums/Topic1182174-2857-1.aspxgood questionWed, 28 Sep 2011 08:53:26 GMTOzYbOi d(-_-)bhttp://www.sqlservercentral.com/Forums/Topic1182174-2857-1.aspxGreat question [i]rfr[/i]. Been looking forward to it since you posted that you submitted a question.I was not disapointed.Wed, 28 Sep 2011 07:58:28 GMTSanDroidhttp://www.sqlservercentral.com/Forums/Topic1182174-2857-1.aspxI can tell you from personal experience, in an environment where we are moving to multiple instances on huge workhorse cluster systems, that this is a critical thing to know. Integration Services won't work properly if you need to use the MSDB portion of IS storage. That said, if you keep packages in the file system and only use SQL Agent to run them as jobs, you don't even need Integration Services. You can supply all of the detail in the job creation to run the package without use of Integration Services (which is the preferred method at our shop, though not always possible with third party apps, thus the criticality of today's question).Wed, 28 Sep 2011 07:37:13 GMTjeff.masonhttp://www.sqlservercentral.com/Forums/Topic1182174-2857-1.aspxGreat question.MattWed, 28 Sep 2011 06:34:59 GMTMattrickhttp://www.sqlservercentral.com/Forums/Topic1182174-2857-1.aspxAs I work in a shop with multiple DBA's, I don't always get to "fiddle" with the configuration. Definitely learned something today. Thanks for the question.Wed, 28 Sep 2011 05:49:13 GMTThomas Abrahamhttp://www.sqlservercentral.com/Forums/Topic1182174-2857-1.aspxGot to learn something, I am yet to explorer SSIS settings may be I will understand it clearly when I get the time to learn SSIS in detail...Wed, 28 Sep 2011 04:43:44 GMTjshailendrahttp://www.sqlservercentral.com/Forums/Topic1182174-2857-1.aspxIf you have multiple instances of SQL Server, then you need a &lt;ServerName&gt; node that describes each instance. I am not sure the question makes this clear.If you use FineBuild to install your instances, then this work is done for you automatically. Also, if you install a SQL cluster and are certain you will only ever have one SQL instance on the cluster it is safe to setup SSIS as a cluster. If you want a SSIS cluster, use the parameter [b]/SetupSSISCluster:[/b][i]Yes[/i] and FineBuild will build the SSIS cluster, setup a Package Store folder on a shared drive, and update MsDtsSrvr.ini to allow SSIS to recognise both the shared msdb database and the shared package store folder.Wed, 28 Sep 2011 03:17:47 GMTEdVassiehttp://www.sqlservercentral.com/Forums/Topic1182174-2857-1.aspxVery interesting questionThanksWed, 28 Sep 2011 02:10:16 GMTStewart "Arturius" Campbellhttp://www.sqlservercentral.com/Forums/Topic1182174-2857-1.aspxInteresting QOTD.Wed, 28 Sep 2011 01:54:32 GMTpaul s-306273http://www.sqlservercentral.com/Forums/Topic1182174-2857-1.aspxDefinitely worth knowingTue, 27 Sep 2011 22:00:28 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1182174-2857-1.aspxGood question, got to know somethingTue, 27 Sep 2011 21:41:30 GMTmohammed moinudheenhttp://www.sqlservercentral.com/Forums/Topic1182174-2857-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/Integration+Services+(SSIS)/75405/">Installating SSIS with Named Instance</A>[/B]Tue, 27 Sep 2011 21:41:11 GMTrfr.ferrari