We are trying to use Meta Data Services as a way to help document our DTS
packages. We can save the DTS as a Meta Data Services Package, and we can
see it in the Meta Data Services group (under DTS).

However, when we try to open the 'Meta Data' group (under DTS), we get the
following error message:
"An error occurred while trying to access the database information.
The msdb database could not be opened."

We want to use the Meta Data Group because of the views it offers of DTS
Packages saved in Meta Data Services. These are the "Browse", "Lineage",
and "Package" views.

Are are using SQL Server 2000, SP4, the most recent build (2039).

We saw the Microsoft Fix article describing this error message (
http://support.microsoft.com/default...b;EN-US;319455 ), but it does
not help -- we have no language issues, and we have applied the most recent
SP. We have checked machine and SQL Server logs and used Profiler, but we
cannot understand why this error message is being generated. We can open,
browse, and update the msdb tables directly in Enterprise Manager. We are
using Admin group network IDs, and are SA on the servers in question.

We have tried to do this on the local SQL Server and on SQL Servers --
always same problem.

Thanks in advance for any suggestions.

Mark

This may help-

FIX: Xp_msver Returns Null for Most of the Properties of a Non-English
SQL Server Installation
(http://support.microsoft.com/?kbid=319455)


I would caution against going with Meta-Data services. It has been
removed as an option in SP3 (although it can be reenabled very easily),
and there is no direct upgrade path in SSIS. Whilst there is no direct
upgrade path for other packages, there is no meta data services at all,
never mind the packages. It is also not a supported storage location for
DTS packages when managed through SSIS and SQL 2005 tools.


Mark F. wrote:

--
Darren
http://www.sqldts.com
http://www.sqlis.com