Error during install of SqlServer 2005 64 Bit edition - please help!

Hi Folks,

I'm receiving an error when i'm trying to setup a maintenance plan. I'm getting weird errors (and cannot continue) and i'm thinking it's related to a 32 bit error i received during installation on a 64 bit edition.

Background
We have a sql server behind hosted on a dedicated 64 bit box out of SanFran. The hosting company installed the 32 bit version of SqlServer 2005 standard on the box and I requested them to remove it and put the 64 bit edition on. They removed the 32 bit edition and installed the 64 bit edition. So far so good. I installed sp1 and that was fine. I then tried to start a MAINTENCE PLAN and was denied -> the component was not installed. I've asked them to install the component and they did, but they recorded an error during the install. The error screen shot is here: http://img525.imageshack.us/img525/5089/errormessagehs4.png

Now i cannot drop any tasks onto the maintenence plan ... so i'm assuming it's related to the above error. Is there any way i can determine what the 32 bit component is, remove it and re-install the correct component? Is there an error log somewhere where i can check things?

This is stopping me from setting up any backup plans :(

Regards,
Justin.

I've tried to google for more info and still have come up blank - anyone know of any clues to help, please?|||

This is an issue where Microsoft.SqlServer.MSMQTask is left behind in COM+ catalog when you toggle between 32-bit and 64-bit installs. You can workaround it by:

1. Open Administrative Tools\Component Services

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

3. Delete Microsoft.SqlServer.MSMQTask

Then your install should work fine.

Thanks,
Sam Lester (MSFT)

|||

Thanks HEAPS Sam for the post.

>>Sam said:: Then your install should work fine.

So i should then re-install the component that is required for maintenance plans?

Thanks soooo much for reading my post and replying!!

|||

I don't claim to know much about IS & maintenance plans, but that error is due to being able to only register one entry in COM+ at a time. My guess would be that reinstalling after fixing this error should make IS function as normal again. :)

Thanks,
Sam

|||

Thanks again sam - i know this post is a bit late, but i finally got around to removing the 32bit com+ and then installed Sp2 (which was why i waited for so long).

Things look fine - cheers mate.