How to troubleshoot SQL Server: "Could not create component categories Manager" and "could not create a insta ...

server| Solution
Because the tests were installed on a Windows Server 2003 machine with BizTalk 2004 (or maybe not because of this), it suddenly became impossible to import or export data in Enterprise Manager. Check the Microsoft Support website has no idea, so the old way to Google a bit, incredibly found such a small article, with you to share:

This can happen after some additional software has been, and installed DLLs by DTS required have. The main culprit is Comcat.dll (Winnt ystem32). Version 4.71 is required for DTS to function correctly. For a quick fix copy Comcat.dll from your SQL 7 CD-ROM, and register it as described below. If This does is not work then start working your way through the suggestions below. (re-) Apply SP1 or SP2 (re-) Install Internet Explorer 5 Copy Comcat.dll from the SQL 7 CD-ROM to \winnt ystem32, replacing the E xisting version. Re-register Comcat.dll [Regsvr32 \winnt Ystem32\comcat.dll] Re-register the DTS DLLs Regsvr32 the \mssql7\binn\axscphst.dll ( SQL Server Watts: \microsoft SQL Server\80\tools\binn\axscphst.dll) Regsvr32 \mssql7\binn\dtsffile.dll (SQL Server 2000: \ Microsoft SQL Server\80\tools\binn\dtsffile.dll) Regsvr32 \mssql7\binn\dtspkg.dll SQL Server: \microsoft SQL Server\80\tools\binn\dtspkg.dll) Regsvr32 \mssql7\binn\dtspump.dll (SQL Server: \microsoft SQL Server\80\tools\binn\dtspump.dll)   Regsvr32 \mssql7\binn\dtsui.dll (SQL Server: \microsoft SQL Server\80\Tools\Binn \dtsui.dll)