Home All Groups Group Topic Archive Search About

error launching SSIS SQL 2005 Ent

Author
3 Mar 2006 4:43 PM
decipher
Hello,

I recently installed sql 2005 in a two node cluster.  I first installed
analysis services and sql 2005 clustered.  Then i went back and installed
reporting, notification and integration studios on both nodes.  i can lauch
integration studios on the first node, but on the second node I receive the
following error:

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

Cannot connect to servername.

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

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 "servername" failed:
Error loading type library/DLL.

I am trying to lauch SSIS locally on node two.  i have uninstalled and
re-installed and the services is running and configuring as network service.

Thanks in advance for any help.

AddThis Social Bookmark Button