msmqtask.dll left over from a SQL 2005 32 bit install.

Recently I got this error while installing SQL Server 2005 64 bit on a machine where previously SQL Server 2005 32 bit was installed:

1. Open Administrative Tools\Component Services

2. Go to Component Services\Computers\My Computer\COM+ Applications

3. Delete Microsoft.SqlServer.MSMQTask

Full credit to Vivek Thakur at codeasp.net for his orginal blog post : http://codeasp.net/blogs/vivek_iit/microsoft-net/440/sql-server-install-error-one-or-more-of-the-components-being-installed-are-already-registered-as-32-bit-components-in-the-target-application-

Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog. Error: -xxxxx
Error message: Unknown error xxxx
Error description: One or more of the components being installed are already
registered as 32 bit components in the target application. You must install
the 64 bit versions of the components being installed in a different COM+
application, or delete the existing 32 bit versions of the components being
installed from the target COM+ application prior to attempting install of the
64 bit versions. COM+ applications cannot contain bit neutral components.

This is an issue when Microsoft.SqlServer.MSMQTask is left behind in COM+ catalog. You can workaround it by:

Since the MSMQTask.dll was already registered as a 32-bit COM+ component with the host Windows machine, the solution is to simplyunregister it as follows: