PRB: "SQLDMO Has Not Been Registered" Error Message If You Remove SQL Server Desktop Engine (822034)


The information in this article applies to:

  • Microsoft SQL Server 7.0
  • Microsoft SQL Server 2000 Desktop Engine (MSDE)
  • Microsoft Windows NT 4.0
Bug #: 469527 (SQL Server 8.0)

SYMPTOMS

If you remove SQL Server Desktop Engine (also known as MSDE 2000) on a computer running SQL Server 7.0 and Windows NT 4.0, SQL Server Enterprise Manager may not start. You may receive an error message that is similar to the following error message:
SQLDMO has not been registered, please re-run SQL Server setup and contact your system administrator.

WORKAROUND

To work around this problem, register the Sqldmo.dll file again. To do so, follow these steps:
  1. At a command prompt, type the following command:

    regsvr32 absolute path of Sqldmo.dll

    Note The default path of Sqldmo.dll for SQL Server 7.0 is Installation Drive\MSSQL7\Binn.
  2. Press ENTER.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Install SQL Server 7.0 on a computer that is running Windows NT 4.0 Service Pack 6a (SP6a).
  2. Install SQL Server 7.0 SP4.
  3. Install a named instance of SQL Server Desktop Engine SP3.
  4. Use Add/Remove Programs to remove the named instance of SQL Server Desktop Engine.
  5. Start SQL Server Enterprise Manager.

REFERENCES

For additional information about SQL Server Enterprise Manager , click the following article numbers to view the articles in the Microsoft Knowledge Base:

272453 PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server 2000

315007 PRB: Error Message: "The snap in that has been selected has failed to initialize" Occurs When You Open SQL Enterprise Manager

Modification Type:MajorLast Reviewed:6/18/2003
Keywords:kbDLL kberrmsg kbprb KB822034 kbAudDeveloper
©2003 Microsoft Corporation. All rights reserved.