Cannot connect to SSIS from SSMS

• S_DBA

  Ten Centuries

  Points: 1242

  More actions

  July 28, 2009 at 5:51 am

  #134331

  I have a 2 node Active-Passive SQL 2005 64 bit Standard edition cluster with version:9.00.3042.

  Yesterday when I tried connecting to SSIS from Management Studio on Active Node,I got below error:

  Cannot connect to DBSQL.

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

  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 "DBSQL" 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 "DBSQL" 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)

  Since then I found that the Integration Services is at version 9.00.3310 and i could connect to it from the Passive node SSMS.

  Probably the Windows Team applied some Windows Hotfixes on the cluster few weeks back and the SSIS was also patched then,I was not informed about this.

  So basically the DB engine and client tools are at a lower version than SSIS which is why I cant connect.I have also gone through the below KB article and tried registing the dlls,but with no success in connecting to SSIS.

  http://support.microsoft.com/kb/919224

  I would like to ask if there is any other work-around besides bringing all of them to the same version level,inorder to connect to SSIS from Management studio from active node?

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  July 30, 2009 at 5:19 am

  #1032293

  This doesn't look right. The easiest option would be to reinstall your server.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/