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

View products that this article applies to.

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.

Back to the top

WORKAROUND

To work around this problem, register the Sqldmo.dll file again. To do so, follow these steps:

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.
Press ENTER.

Back to the top

MORE INFORMATION

Steps to Reproduce the Behavior

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

Back to the top

REFERENCES

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

272453 (http://support.microsoft.com/kb/272453/EN-US/ ) PRB: Cannot Use SQL Server 7.0 Tools After You Remove SQL Server 2000

315007 (http://support.microsoft.com/kb/315007/ ) PRB: Error Message: "The snap in that has been selected has failed to initialize" Occurs When You Open SQL Enterprise Manager

Back to the top