PRB: Errors When You Redistribute SQL Server 2000 DMO Clients in SQL Server 7.0 Environment (295026)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
  • Microsoft SQL Server 7.0
This article was previously published under Q295026

SYMPTOMS

After you successfully register the SQL Server 2000 Distributed Management Objects (SQL-DMO) DLLs in an environment with the SQL Server 7.0 Client tools installed, when you start SQL Server 7.0 Enterprise Manager (SEM), you may receive the following error messages.

On Microsoft Windows 2000:
SQL-DMO: Error 127: General Error".
On Microsoft Windows NT 4.0:
SQL-DMO: 340 General Error"
After these error messages are displayed, SEM starts and you may experience the following behavior:
  • The previously existing SQL server registrations are missing.
  • Upon registering a new SQL Server server, you receive the following error message:
    "Server registration information cannot be changed on remote Registries"

CAUSE

SQL Server Enterprise Manager uses additional DLL files that are not redistributable as part of the licensing agreement.

WORKAROUND

To work around this problem after you have already redistributed the SQL Server 2000 SQL-DMO files, you can do either of the following things:
  • Unregister all SQL-DMO DLLs and then redistribute the SQL Server 7.0 SQL-DMO DLLs into the environment that comes with the SQL Server 7.0 Setup CD.

    -or-
  • For the full functionality of the SQL Server 2000 Client tools, install the SQL Server 2000 tools from a SQL Server 2000 CD.

MORE INFORMATION

As described in the redistributable components file, Redist.txt, which comes with the SQL Server 2000 Setup CD, you can redistribute the SQL Server 2000 SQL-DMO DLLs. However, registering these DLLs in an environment with a preexisting SQL Server 7.0 Enterprise Manager (SEM) is not recommended because SEM uses additional DLL files. These additional files are not redistributable as part of the license agreement in Redist.txt, and there is no guarantee that SEM 7.0 will work with the SQL Server 2000 SQL-DMO files.

Please note that Redist.txt lists only one SQL client utility (OSQL.exe) for redistribution. To obtain the full functionality of the SQL Server 2000 Client tools, it is recommended that you install the SQL Server 2000 tools from a SQL Server 2000 CD with the appropriate Microsoft End-User Licensing Agreement (EULA).

The SQL Server 2000 redistributable components are backward-compatible. However, they are provided for distribution only with object code in conjunction with, or as part of, your application that works with Microsoft SQL Server. In other words, the SQL Server 2000 redistributable components should work with any third-party applications that were written for SQL Server 7.0.

SQL-DMO object names that were available in SQL Server 7.0 are also available in SQL Server 2000. It is not necessary to modify existing SQL Server version 7.0 DMO applications because they do not reference the new objects, methods, and properties that are exposed in SQL Server 2000.

For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

248241 INF: Enabling SQL DMO Clients Without Installing the Client Side Utilities

Modification Type:MajorLast Reviewed:10/31/2003
Keywords:kbprb KB295026
©2003 Microsoft Corporation. All rights reserved.