How does one configure and manage a remote SSIS Service?

When attempting to administer a remote SSIS Service in SQL Server Management
Studio, I get an Access is Denied error (message listed below) when trying to
connect to the service. How does one set up access to a remote SSIS Service?


Environment Information
- Windows account is not part of the a Local Administrator's group on the
remote machine (and do to corp policy, cannot be added)
- Machine has an Operating System that is Windows XP, sp 2 (eventually
production machine will be a Windows 2003 server)
- SQL Server 2005 Standard Edition
- Same domain and OU


Error Message:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click:
http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

Connect to SSIS Service on machine "GCMSQLU0" failed:
Access is denied.
..
------------------------------
Connect to SSIS Service on machine "GCMSQLU0" failed:
Access is denied.
..
------------------------------
BUTTONS:
OK
------------------------------

Hello vnapoli,

Have you had a look at this?

http://www.sqljunkies.com/WebLog/kni.../05/17769.aspx


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Yes. That was one of the first things I tried. Windows XP SP2 did not have
a Distributed COM Users group on the local machine to be able to add the
windows account to. Windows 2003 does have the group. In the DCOM Config
section of Component Services for the MsDTSServer component, I even did
something that I normally do not do and that was to add the windows account
all permissions across the board. Launch and Activate Permissions, Access
Permissions, and Configuration Permissions with full authority. Even
Restarted the machine, not just the SSIS Service.



"Allan Mitchell" wrote:

I tried the setup described in the article
http://www.sqljunkies.com/WebLog/kni.../05/17769.aspx
also on a Windows 2003 server, sp1 (SQL 2005 standard edition) with no luck
also. Any thoughts? Suggestions?




"vnapoli" wrote:

Correction. We got the remote access to a SSIS Service (on a Windows 2003
server, sp1) working. We had inadvertently left out the step to add the
windows account or group to the Distributed COM Users group on the local
machine. With that step and the rest of the instructions in the article,
http://www.sqljunkies.com/WebLog/kni.../05/17769.aspx,
we got it to work. No luck whatsoever with the setup on the Windows XP
machine as there was no Distributed COM Users group on the local machine.



"vnapoli" wrote:

Please check this: You just have to add the user to the "Limits.." on
the COM Security

http://mohansmindstorms.spaces.live.com/Blog/cns!69AE1BEA50F1D0E7!213.en
try



*** Sent via Developersdex http://www.developersdex.com ***

Mohan P -
Thank you for this solution. It was the fix I needed. All is working
great for me, now.


- Jeff

*** Sent via Developersdex http://www.developersdex.com ***