October 2, 2008 at 2:34 pm
Hi
I installed integration services and reporting services in active node called dba3 in cluster environment . virtual server name is DBA3VS and instance name is INS1.Now Iam tyring to connect Integration services from management studio by giving DBA3 ,it throwing below error:
TITLE: Connect to Server
------------------------------
Cannot connect to DBA3
------------------------------
ADDITIONAL INFORMATION:
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Connect to SSIS Service on machine "SDBA3" failed:
Error loading type library/DLL.
And when I give the virtual server name DBA3VS it giving the error:
Cannot connect to DBA3vs.
------------------------------
ADDITIONAL INFORMATION:
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Connect to SSIS Service on machine "DBA3vs" failed:
Error loading type library/DLL.
.
------------------------------
Connect to SSIS Service on machine "DBA3vs" failed:
Error loading type library/DLL.
.
We need to do any configuration for Integration services after installing it? How can I connect Integration services?
.
December 8, 2008 at 2:09 pm
Did you ever get your SSIS to connect? I'm having the same problem with a cluster server on the second node and will not connect.
Javier
December 8, 2008 at 2:25 pm
Integration Services is not cluster aware and was not installed in the cluster. If you have not already installed it on all nodes - you will need to get it installed on the other nodes.
To access Integration Services - you log in using the machine name of the node you want to access. For example:
Cluster Nodes: NodeA, NodeB
Virtual Server: NodeAB
Virtual SQL Server: SQL1
You connect to NodeA to access Integration Services (SSIS) on that node.
Jeffrey Williams
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply