Installating SSIS with Named Instance

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by rfr.ferrari » Installating SSIS with Named Instance

23 posts, Page 2 of 3

««1 2 3 »»

Installating SSIS with Named Instance

Rate Topic

Display Mode

Topic Options

Author

Message

SanDroid

Posted Wednesday, September 28, 2011 7:58 AM

Ten 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

OzYbOi d(-_-)b

Posted Wednesday, September 28, 2011 8:53 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176, Visits: 778

good question

Post #1182540

Rob Schripsema

Posted Wednesday, September 28, 2011 9:38 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 3:33 PM
Points: 1,655, Visits: 10,864

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

Cliff Jones

Posted Wednesday, September 28, 2011 9:44 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 2:05 PM
Points: 3,423, Visits: 3,439

I had no idea but made a lucky guess based on the answer that looked like it might be correct.

Post #1182589

Miles Neale

Posted Wednesday, September 28, 2011 10:05 AM

SSCommitted

Group: General Forum Members
Last Login: Today @ 4:17 PM
Points: 1,900, Visits: 954

Great question, caught me on this one. But now I know better. Smile

Not all gray hairs are Dinosaurs!

Post #1182626

Britt Cluff

Posted Wednesday, September 28, 2011 11:26 AM

SSCommitted

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

Joshua M Perry

Posted Wednesday, September 28, 2011 1:47 PM

Old Hand

Group: General Forum Members
Last Login: 2 days ago @ 4:30 PM
Points: 388, Visits: 419

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.kerry.com

Post #1182794

KWymore

Posted Wednesday, September 28, 2011 3:32 PM

SSCrazy

Group: General Forum Members
Last Login: Today @ 11:48 AM
Points: 2,602, Visits: 1,553

Interesting question. We typically use the file system so I haven't had to encounter this.

Post #1182886

Trey Staker

Posted Wednesday, September 28, 2011 4:52 PM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 5:42 PM
Points: 1,380, Visits: 2,637

Thanks for the question.

---------------------------------------------------------------------
Use Full Links:
KB Article from Microsoft on how to ask a question on a Forum

Post #1182900

CoolCodeShare

Posted Wednesday, September 28, 2011 11:38 PM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 6:08 AM
Points: 1,216, Visits: 298

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 »

23 posts, Page 2 of 3

««1 2 3 »»

Permissions