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
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
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