I'm attempting to connect to the SSIS service on my server from my local
workstation using Management Studio and when I try it I get:

******************************************
TITLE: Connect to Server
------------------------------
Cannot connect to xyz.
------------------------------
ADDITIONAL INFORMATION:

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

For help, click:
http://go.microsoft.com/fwlink?ProdN...oft+SQL+Server
<http://go.microsoft.com/fwlink?ProdN...ver&LinkId=204
76> &LinkId=20476
------------------------------
Connect to SSIS Service on machine "xyz" failed:
The RPC server is unavailable.
------------------------------
******************************************

I have verified that the service is running on server xyz.

I came across a note in the documentation about TCP port 135 having to
be open in order to communicate with the service. Windows Firewall is
running on that server (don't ask) so I opened that up but I still have
the problem. Any thoughts? TIA


Gary Axtell

Florida Association of Court Clerks

The SSIS server is configured for local access by default. You have to
configure it to be accessed remotely from Component Services. Here is what
you have to do:

1. Click Start | Administrative Tools | Component Services.
2. Expand Component Services | Computers | My Computer | DCOM Config.
3. Right-click MsDtsServer and choose Properties.
4. On Security tab select Customize under Launch and Activation Permissions.
Click Edit.
5. Add a domain account.
6. Select the Remote Activation permission to allow user to access service
remotely.


Charles Kangai, MCT, MCDBA



"Gary Axtell" wrote: