We plan to upgrade the sql server 2005 x32 bit to x64 bit. Before starting, we wanted to uninstall the existing version of the sql server and then plan to start the installation of new sql server version in 64 bit on existing hardware. We checked all perquisites before applying new version of sql server like .net framework 3.5, windows installer 4 which was already installed on system.
So we started sql server installation setup after going through some steps of the installation wizards, we got the component error saying “failed to install and configure assemblies ….\Microsoft.sqlserver.MSMQtask.dll in the COM+”
How to edit Registry entries ?
HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90
• Expand the Components services – My Computer—COM+ Application
• Microsoft.sqlserver.MSMQTask component.
• Right click on it and delete it.
After deleting the COM+ component, we started sql server setup again this time it installed successfully without any error.