SQL Server 2K5 - SSIS
Srikanth
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?ProdName=Microsoft+SQL+Server&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
cadell
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)
------------------------------
------------------------------
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.VSIntegration.ObjectExplorer.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.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 "<hostname>" 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)
- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- -
- -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - -- - - --
- - -
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_Properties()
at
Microsoft.DataTransformationServices.Design.DtsBaseDesigner.PreFilterProperties(IDictionary properties)
at
Microsoft.DataTransformationServices.Design.DtsPropExpressionsDesigner.PreFilterProperties(IDictionary properties)
at
Microsoft.DataTransformationServices.Design.DbMaintSequenceDesigner.PreFilterProperties(IDictionary properties)
at
System.ComponentModel.Design.ComponentDesigner.System.ComponentModel.Design.IDesignerFilter.PreFilterProperties(IDictionary properties)
at
System.ComponentModel.Design.TypeDescriptorFilterService.System.ComponentModel.Design.ITypeDescriptorFilterService.FilterProperties(IComponent
component, IDictionary properties)
at
Microsoft.DataTransformationServices.Design.DtsTypeDescriptorFilterService.System.ComponentModel.Design.ITypeDescriptorFilterService.FilterProperties(IComponent component, IDictionary properties)
at System.ComponentModel.TypeDescriptor.PipelineFilter(Int32
pipelineType, ICollection members, Object instance, IDictionary cache)
at System.ComponentModel.TypeDescriptor.GetPropertiesImpl(Object
component, Attribute[] attributes, Boolean noCustomTypeDesc, Boolean
noAttributes)
at System.ComponentModel.TypeDescriptor.GetProperties(Object component)
at Microsoft.DataWarehouse.Design.Cud.VsTransaction.ChangeProperty(Object
obj, String propertyName)
at
Microsoft.DataTransformationServices.Design.DtsBasePackageDesigner.CreateExecutable(String moniker, IDTSSequence container, String name)
===================================
Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)
------------------------------
Program Location:
at
Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPropertiesProvider90.get_Properties()
at Microsoft.SqlServer.Dts.Runtime.Sequence.get_Properties()
"Srikanth" skrev:
LucReid
*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/library/ms137789(SQL.90).aspx
--
LucReid
------------------------------------------------------------------------
LucReid's Profile: http://www.dbtalk.net/m295
View this thread: http://www.dbtalk.net/t285279