I am trying to connect SSIS from the Management Studio, the connection is
fine. Once i clicked on MSDB, it saying expanding the i am getting this
errors,

By the by our servers are cluster servers

TITLE: Microsoft SQL Server Management Studio
------------------------------

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

For help, click:
http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

Login timeout expired
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
Named Pipes Provider: Could not open a connection to SQL Server [2].
(Microsoft SQL Native Client)

------------------------------

Login timeout expired
An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
Named Pipes Provider: Could not open a connection to SQL Server [2].
(Microsoft SQL Native Client)

------------------------------
BUTTONS:

OK
------------------------------
any idia , please thanks



--
SQL serer DBA

Hi,

I almost have the same problem? I'm runing Win2003 x64 and SQL 2005 x64 and
clustering services.

When trying to connect to SISS, both with the cluster name and node name
(Yes, I no its wrong)
===================================

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.VSIntegration.Ob jectExplorer.ObjectExplorer.ConnectToServer(Object
connectionInfo, IDbConnection liveConnection, Boolean validateConnection)

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

Connect to SSIS Service on machine "<hostname>" 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 "<hostname>" 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)


- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- -
- -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - --
- - -


When trying to edit a maintance plan,
===================================

Failed to create the task. (Microsoft SQL Server Management Studio)

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

Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

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

at Microsoft.SqlServer.Dts.Runtime.Sequence.get_Prope rties()
at
Microsoft.DataTransformationServices.Design.DtsBas eDesigner.PreFilterProperties(IDictionary properties)
at
Microsoft.DataTransformationServices.Design.DtsPro pExpressionsDesigner.PreFilterProperties(IDictiona ry properties)
at
Microsoft.DataTransformationServices.Design.DbMain tSequenceDesigner.PreFilterProperties(IDictionary properties)
at
System.ComponentModel.Design.ComponentDesigner.Sys tem.ComponentModel.Design.IDesignerFilter.PreFilte rProperties(IDictionary properties)
at
System.ComponentModel.Design.TypeDescriptorFilterS ervice.System.ComponentModel.Design.ITypeDescripto rFilterService.FilterProperties(IComponent
component, IDictionary properties)
at
Microsoft.DataTransformationServices.Design.DtsTyp eDescriptorFilterService.System.ComponentModel.Des ign.ITypeDescriptorFilterService.FilterProperties( IComponent component, IDictionary properties)
at System.ComponentModel.TypeDescriptor.PipelineFilte r(Int32
pipelineType, ICollection members, Object instance, IDictionary cache)
at System.ComponentModel.TypeDescriptor.GetProperties Impl(Object
component, Attribute[] attributes, Boolean noCustomTypeDesc, Boolean
noAttributes)
at System.ComponentModel.TypeDescriptor.GetProperties (Object component)
at Microsoft.DataWarehouse.Design.Cud.VsTransaction.C hangeProperty(Object
obj, String propertyName)
at
Microsoft.DataTransformationServices.Design.DtsBas ePackageDesigner.CreateExecutable(String moniker, IDTSSequence container, String name)

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

Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

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

at
Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSProper tiesProvider90.get_Properties()
at Microsoft.SqlServer.Dts.Runtime.Sequence.get_Prope rties()



"Srikanth" skrev:

Problem: You go into SSIS for a server, then try to expand the MSDB folder, and you receive an error that says "Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)"

Diagnosis and Fix: SSIS has a configuration file in which it needs to know the server and instance name. Since in some situations SQL Server 2005 automatically creates an instance name instead of using the default instance, this must be manually set.

Open the configuration file, which is usually C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml . It will look something like this:

<?xml version="1.0" encoding="utf-8"?>
<DtsServiceConfiguration xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<StopExecutingPackagesOnShutdown>true</StopExecutingPackagesOnShutdown>
<TopLevelFolders>
<Folder xsi:type="SqlServerFolder">
<Name>MSDB</Name>
<ServerName>.</ServerName>
</Folder>
<Folder xsi:type="FileSystemFolder">
<Name>File System</Name>
<StorePath>..\Packages</StorePath>
</Folder>
</TopLevelFolders>
</DtsServiceConfiguration>

In the ServerName tag, fill in the server name and instance, e.g. dwc-lreid\lreid2005 . If you're not sure what the server and instance name are, check them by looking at the database engine registrations in the Registered Servers section of the screen in SQL Management Studio.

More information is available about SSIS configuration at http://msdn2.microsoft.com/en-us/lib...9(SQL.90).aspx