Microsoft KB Archive/822034

= PRB: &quot;SQLDMO Has Not Been Registered&quot; Error Message If You Remove SQL Server Desktop Engine =

Article ID: 822034

Article Last Modified on 6/18/2003

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft SQL Server 2000 Desktop Engine (Windows)
 * 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

Note The default path of Sqldmo.dll for SQL Server 7.0 is \MSSQL7\Binn.
 * 1) Press ENTER.



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.

