Viewing MSDB Jobs From SSIS Get Error (Failed to retrieve data for this request, (Microsoft.SqlServer.SmoEnum))...

Jeffrey

2006-03-10 01:36:03 UTC

This error has to do with Named Instance you need to edit the following
file: MsDtsSrvr.ini.xml, see the below article for more information.
http://msdn2.microsoft.com/en-us/library/ms137789(SQL.90).aspx

Post by Jeffrey
Hi All,
I get the following error when I try to view any jobs in the MSDB folder
under Stored Packages for SSIS, can any help with this problem?
The error is listed below.
TITLE: Microsoft SQL Server Management Studio
------------------------------
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native Client)
------------------------------
Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native Client)
------------------------------
OK
------------------------------
===================================
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)
------------------------------
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object
connectionInfo, Request request)
at

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem

Post by Jeffrey
Builder.BuildDynamicItemWithQuery(IList nodes, INodeInformation source,
INavigableItem sourceItem, String urnQuery, Boolean registerBuilder, Boolean
registerBuiltItems)
at

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem

Post by Jeffrey
Builder.BuildDynamicItem(IList nodes, INodeInformation source,
INavigableItem sourceItem, IFilterProvider filter)
at

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem

Post by Jeffrey
Builder.Build(INodeInformation source, INavigableItem sourceItem,
IFilterProvider filter)
at

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem

Post by Jeffrey
.GetChildren()
at

Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHiera

Post by Jeffrey
rchyNode.BuildChildren()
===================================
Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native Client)
------------------------------
at

Microsoft.SqlServer.Dts.Runtime.Application.GetDtsServerPackageInfos(String

Post by Jeffrey
sPackageFolder, String sServerName)
at Microsoft.SqlServer.Dts.SmoEnum.PackageEnum.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)
===================================
Client unable to establish connection
Encryption not supported on SQL Server. (Microsoft SQL Native Client)
------------------------------
at

Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.GetDtsServerPackage

Post by Jeffrey
Infos(String bstrPackageFolder, String bstrServerName)
at

Microsoft.SqlServer.Dts.Runtime.Application.GetDtsServerPackageInfos(String

Post by Jeffrey
sPackageFolder, String sServerName)
Thanks!
JP