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.d ll 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.d ll 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.d ll 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
--
Scott Bottomley
Network Admin
UniFirst Corporation

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

On Thu, 17 Jul 2008 06:50:00 -0700, Scott Bottomley
<ScottBottomley@discussions.microsoft.com> wrote:

>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.d ll 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