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 Wednesday, September 28, 2011 7:58 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232, Visits: 1,046
Great question rfr.
Been looking forward to it since you posted that you submitted a question.
I was not disapointed.
Post #1182486
Posted Wednesday, September 28, 2011 8:53 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176, Visits: 778
good question
Post #1182540
Posted Wednesday, September 28, 2011 9:38 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, March 31, 2014 3:08 PM
Points: 1,906, Visits: 10,941
Great question. The referenced article has a really good overview of how this all hangs together, too. Definitely learned something today!

Rob Schripsema
Accelitec, Inc
Post #1182583
Posted Wednesday, September 28, 2011 9:44 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 12:10 PM
Points: 3,766, Visits: 3,584
I had no idea but made a lucky guess based on the answer that looked like it might be correct.
Post #1182589
Posted Wednesday, September 28, 2011 10:05 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, March 10, 2014 5:44 PM
Points: 2,225, Visits: 1,258
Great question, caught me on this one. But now I know better.

Not all gray hairs are Dinosaurs!
Post #1182626
Posted Wednesday, September 28, 2011 11:26 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, October 24, 2012 8:17 PM
Points: 1,588, Visits: 247
I got it right with a lucky guess! Thanks for the question.

http://brittcluff.blogspot.com/
Post #1182694
Posted Wednesday, September 28, 2011 1:47 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, February 06, 2014 9:39 AM
Points: 420, Visits: 487
How 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.

Joshua Perry
http://www.usesage.com
Post #1182794
Posted Wednesday, September 28, 2011 3:32 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:46 AM
Points: 3,150, Visits: 1,900
Interesting question. We typically use the file system so I haven't had to encounter this.
Post #1182886
Posted Wednesday, September 28, 2011 4:52 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, March 10, 2014 3:52 PM
Points: 1,380, Visits: 2,681
Thanks for the question.

---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum
Post #1182900
Posted Wednesday, September 28, 2011 11:38 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, August 28, 2013 7:06 AM
Points: 1,216, Visits: 308
My answer was based on the logical understanding of instance configurations. And yes I got it correct. Good QoTD. Thanks.
Post #1182949
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse