Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / DB Engine / SQL Server / July 2008

Tip: Looking for answers? Try searching our database.

2000 32bit with 2005 64bit

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Scott Bottomley - 17 Jul 2008 14:50 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.