Posted by Neff on 06/11/07 14:42

I have a clustered installation of SQL Server 2005 with SSIS installed
on the cluster.

I'm running SQL Server Management Server on one of the cluster nodes
and trying to connect to the integration services server. In the
connection dialog the only editable field I have is server name and I
can browse and find the server name SC-DB01.

However wne I press the connect button I just get an error with the
messages below...... Can anyone help with what is set up wrong?

===================================

Cannot connect to SC-DB01.

===================================

Failed to retrieve data for this request.
(Microsoft.SqlServer.SmoEnum)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
Program Location:

at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object
connectionInfo, Request request)
at
Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo
ci, IServerType server)
at
Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

===================================

Connect to SSIS Service on machine "SC-DB01" failed:
Error loading type library/DLL.
..


------------------------------
Program Location:

at Microsoft.SqlServer.Dts.Runtime.Application.GetServerInfo(String
server, String& serverVersion)
at Microsoft.SqlServer.Dts.SmoEnum.DTSEnum.GetData(EnumResult
erParent)
at Microsoft.SqlServer.Management.Smo.Environment.GetData()
at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request
req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object
connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object
connectionInfo, Request request)

===================================

Connect to SSIS Service on machine "SC-DB01" failed:
Error loading type library/DLL.
..


------------------------------
Program Location:

at
Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.GetServerInfo(String
bstrMachineName, String& serverVersion)
at Microsoft.SqlServer.Dts.Runtime.Application.GetServerInfo(String
server, String& serverVersion)

• Next in forum: Can't Edit Maintenance Plan
• Prev in forum: Establishing Precedence In ORDERBY Condition Causing Problems.
• Thread view: Can't connect to SSIS

[Reply to this message]