Cannot connect remotely to SSIS

Question

Post reply

Cannot connect remotely to SSIS

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jonathan Butler Right there with Babe Points: 768 More actions · Answer 1

A few steps and questions about this "problem"

1) are the users in the administrators group on the server running SSIS service

2) If not then DCOM settings need to be altered on a per user (or group) basis for the serivce

see http://www.sqlservercentral.com/Forums/Topic484638-148-1.aspx

and http://www.sqljunkies.com/WebLog/knight_reign/archive/2006/01/05/17769.aspx

There are msdn articles also on this subject

Moffitar Ten Centuries Points: 1185 More actions · Answer 2

Jonathan Butler (5/23/2008)
A few steps and questions about this "problem"
1) are the users in the administrators group on the server running SSIS service
2) If not then DCOM settings need to be altered on a per user (or group) basis for the serivce
see http://www.sqlservercentral.com/Forums/Topic484638-148-1.aspx
and http://www.sqljunkies.com/WebLog/knight_reign/archive/2006/01/05/17769.aspx
There are msdn articles also on this subject

1. Yes. There is a group called "Analysts", of which I am a member. The "Analysts" group is a member of the local SCHEDULE1 Administrators group.

2. The Analysts group is also granted the following rights/membership:

a. Member of the local SCHEDULE1 Distributed COM users Group

b. Member of the local SCHEDULE1 SQLServer2005DTSUser$ group

3. The Distributed COM users group has full Activation/Launch/Access permissions for the MSDTSServer DCOM object.

4. The Analysts group is a member of all DTS roles in the MSDB instance on SCHEDULE1.

I know this is way more access than is required to grant simple remote SSIS access, but I'm trying to be methodical in what I open up, so I'll know where the problem is.

Keep in mind that I don't think it's strictly a permissions issue, because although I cannot access SSIS on "SCHEDULE1" from my workstation, I can access it from "SILO1".

I forgot to mention that this is using the SSMS method to connect to SSIS, which I don't know if it uses a different method than the BIDS. I also ran the SQL 2005 best practices analyzer and it gave me the same "Access Denied" error when attempting to connect.