Sunday, March 11, 2012

DLL issue when installing SS05 64bit

I uninstalled a 32-bit eval Std Ed SQL Server 2005. I then attempted to install 64bit licensed Std Ed. The database engine and other components install fine, but SSIS is throwing a DLL error (first error following). How can I solve this issue? I have attempted to IGNORE the error, but when I try to run SSIS - I get a DLL error (second error following). All assistance is appreciated.

TITLE: Microsoft SQL Server 2005 Setup

Failed to install and configure assemblies C:\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.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=29549&EvtType=sqlca%5csqlassembly.cpp%40Do_sqlAssemblyRegSvcs%40Do_sqlAssemblyRegSvcs%40x80131501

TITLE: Connect to Server

Cannot connect to SERVERNAME.


ADDITIONAL INFORMATION:

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

Connect to SSIS Service on machine "SERVERNAME" failed:
Error loading type library/DLL.

I've seen this issue in the forums a couple times, but haven't been able to repro it on my box. Here is a thread regarding this issue with a few suggestions. Feel free to take a look to see if it pertains to your situation. The people on the thread seem to have a handle on the issue, so they may be able to help out if you get stuck.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=136467&SiteID=1

Thanks,
Sam Lester (MSFT)|||The is in the Component Services in com+ called Microsoft.Sqlserver.MSMQTask. You need to delete that one. After that the install will run just fine.

Theo Ekelmans

No comments:

Post a Comment