468,537 Members | 1,922 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,537 developers. It's quick & easy.

Can't connect to SSIS

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?ProdN...r&LinkId=20476

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

at Microsoft.SqlServer.Management.Smo.Enumerator.Proc ess(Object
connectionInfo, Request request)
at
Microsoft.SqlServer.Management.UI.VSIntegration.Ob jectExplorer.ObjectExplorer.ValidateConnection(UIC onnectionInfo
ci, IServerType server)
at
Microsoft.SqlServer.Management.UI.ConnectionDlg.Co nnector.ConnectionThreadUser()

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

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

at Microsoft.SqlServer.Dts.Runtime.Application.GetSer verInfo(String
server, String& serverVersion)
at Microsoft.SqlServer.Dts.SmoEnum.DTSEnum.GetData(En umResult
erParent)
at Microsoft.SqlServer.Management.Smo.Environment.Get Data()
at Microsoft.SqlServer.Management.Smo.Environment.Get Data(Request
req, Object ci)
at Microsoft.SqlServer.Management.Smo.Enumerator.GetD ata(Object
connectionInfo, Request request)
at Microsoft.SqlServer.Management.Smo.Enumerator.Proc ess(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.Applicatio nClass.GetServerInfo(String
bstrMachineName, String& serverVersion)
at Microsoft.SqlServer.Dts.Runtime.Application.GetSer verInfo(String
server, String& serverVersion)

Jun 11 '07 #1
0 3614

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Rodrigo Bellusci | last post: by
4 posts views Thread by Roger | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.