I have installed Integration Services 2008 R2 on two clustered nodes, 'NODE1' and 'NODE2', part of an active/passive cluster named 'SQLCLUSTER'. Now SSIS is installed (and patched up to the same level as the DB engine). I can run BIDS on the nodes, build and execute packages.
My problem is that I cannot connect to SSIS in Management Studio using the cluster name 'SQLCLUSTER'. I receive the following error:
Connecting to the Integration Services service on the computer "SQLCLUSTER" failed with the following error: "The RPC server is unavailable."
I know RPC is running on the node currently owning the cluster, and I can connect just fine in SSMS if I use the node name instead.
I have updated the <ServerName> element in msdtssrvr.ini.xml to "SQLCLUSTER" as indicated in http://msdn.microsoft.com/en-us/library/ms137789.aspx
If anyone has any clues I'd be grateful. Thank you!