I have read the SQL 2000 32 bit and SQL 2005 64 bit can be installed on the
same machine. During the installation of the Integration Servcies I received
the following error: {copied from SQLSetup0002_SQLDEV64_DTS.log}
<Func Name='LaunchFunction'>
Function=Do_sqlAssemblyRegSvcs
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlAssemblyRegSvcs
PerfTime Start: Do_sqlAssemblyRegSvcs : Thu Jul 17 09:15:08 2008
<Func Name='Do_sqlAssemblyRegSvcs'>
Failed to install and configure assemblies Y:\Program Files\Microsoft SQL
Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog.
Error: 2148734209
Error message: Unknown error 0x80131501
Error descrition: 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.
Error Code: -2146233087
Windows Error Text: Source File Name: sqlca\sqlassembly.cpp
Compiler Timestamp: Thu Aug 11 01:12:01 2005
Function Name: Do_sqlAssemblyRegSvcs
Source Line Number: 155
Error Code: -2146233087
MSI (s) (E4!D4) [09:19:13:513]: Product: Microsoft SQL Server 2005
Integration Services (64-bit) -- Error 29549. Failed to install and configure
assemblies Y:\Program Files\Microsoft SQL
Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in the COM+ catalog.
Error: -2146233087
Error message: Unknown error 0x80131501
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.
Error 29549. Failed to install and configure assemblies Y:\Program
Files\Microsoft SQL Server\90\DTS\Tasks\Microsoft.SqlServer.MSMQTask.dll in
the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
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.
<EndFunc Name='LaunchFunction' Return='-2146233087' GetLastError='0'>
The rest of the installation completed succesfully. I would appreciated any
thoughts on the matter. I have been trying to create an environment for my
developers to be able to view their existing DTS packages and work on
migrating them to 2005 64.
Thanks
scott

Signature
Scott Bottomley
Network Admin
UniFirst Corporation
Denny Cherry - 17 Jul 2008 18:31 GMT
It appears that the only file which failed is the 32bit
Microsoft.SqlServer.MSMQTask.dll. You could try unregistering this
file manually.
You can also install the 32bit edition of SQL Server 2005. The SSIS
packages will run the same between x86 and x64.
Denny
>I have read the SQL 2000 32 bit and SQL 2005 64 bit can be installed on the
>same machine. During the installation of the Integration Servcies I received
[quoted text clipped - 56 lines]
>Thanks
>scott