Monday, December 19, 2005

SQL Server 2005 & SQLDMO

I have recently uninstalled SQL Server 2005 and got the following error while trying to run enterprise manager for SQL Server 2000. I was trying to find out why SQL Server 2005 will affect the installation of SQLDMO.dll file.

The error I was getting was :
SQLDMO has not been registered; please re-run SQL Server setup and contact system administrator.

The way to solve this issue is to register the dll rather than re-running SQL Server 2000 setup. First check that sqldmo.dll exists in binn dirctory of your SQL Server installation then run regsvr32 sqldmo.dll from command line.

No comments: