|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
error launching SSIS SQL 2005 EntI 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. |
|||||||||||||||||||||||