Hello together, I installed a new SQL 2008 R2 server with all components. I get the following error if I try to connect from my laptop to the Integration Services: (local ssms connect works fine) Connecting to the Integration Services service on the computer "ServerName" failed with the following error: "Not enough resources are available to complete this operation.". What did I configure: - Windows Firewall port 135 and MsDtsSrvr - Client components, dcom config MsDtsServer100/security - User is in the local admins I get the same error with a switched of Firewall. Im browsing the web since this morning without any results. Do you guys know about this error? Thanks

Hi Dennis, To resolve this issue, make a minimum of 200 ports available in the registry on the cluster if the HKEY_LOCAL_MACHINE\Software\Microsoft\RPC\Internet subkey is present in the registry. Please follow the steps in the article below for Windows 2003: How to configure RPC dynamic port allocation to work with firewalls Arthur My Blog

Hi Dennis, To resolve this issue, make a minimum of 200 ports available in the registry on the cluster if the HKEY_LOCAL_MACHINE\Software\Microsoft\RPC\Internet subkey is present in the registry. Please follow the steps in the article below for Windows 2003: How to configure RPC dynamic port allocation to work with firewalls Arthur My Blog