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
[quoted text, click to view] "Gary Axtell" wrote:
> 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?ProdName=Microsoft+SQL+Server > <
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&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
>
>
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?ProdName=Microsoft+SQL+Server <
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&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
