Problem with SQL 2005 install. Can Microsoft.SqlServer.MSMQTask.dll be recovered?

Hello!
I am trying to install SQL Server 2005 (Developer Edition -- the version
that came with my Visual Studio 2005 Professional Edition software).
For the most part, the install went pretty smoothly. However, during the
Integration Services portion, I got the following error:
Failed to install and configure assemblies C:\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: You must have administrative credentials to perform this
task. Contact your system administrator for assistance.
I Googled for some solutions, and came up with a few relevant hits:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1311934&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1143461&SiteID=1
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61570
I tried the suggestions therein, but none of them seemed to solve the
problem (and now I no longer have *any* Microsoft.SqlServer.MSMQTask entry
in my COM+ list). I couldn't hit "Retry" during the SQL installation and
have it gracefully resume.
I eventually just hit Ignore, and the rest of the install proceeded just
fine.
I'm wondering if there's any way to recover this file and/or COM+ entry?
I'm guessing that it's necessary for Integration Services?
(BTW: I'm on Windows XP Professional, SP2, and I had SQL Server 2005 CTP
installed at one point, too, but uninstalled before installing the current
version.)
Thanks for any help anyone can provide!
John Peterson
Hi
"John Peterson" wrote:

> Hello!
> I am trying to install SQL Server 2005 (Developer Edition -- the version
> that came with my Visual Studio 2005 Professional Edition software).
> For the most part, the install went pretty smoothly. However, during the
> Integration Services portion, I got the following error:
> Failed to install and configure assemblies C:\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: You must have administrative credentials to perform this
> task. Contact your system administrator for assistance.
> I Googled for some solutions, and came up with a few relevant hits:
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1311934&SiteID=1
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1143461&SiteID=1
> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61570
> I tried the suggestions therein, but none of them seemed to solve the
> problem (and now I no longer have *any* Microsoft.SqlServer.MSMQTask entry
> in my COM+ list). I couldn't hit "Retry" during the SQL installation and
> have it gracefully resume.
> I eventually just hit Ignore, and the rest of the install proceeded just
> fine.
> I'm wondering if there's any way to recover this file and/or COM+ entry?
> I'm guessing that it's necessary for Integration Services?
> (BTW: I'm on Windows XP Professional, SP2, and I had SQL Server 2005 CTP
> installed at one point, too, but uninstalled before installing the current
> version.)
> Thanks for any help anyone can provide!
> John Peterson
Have you tried a re-install
http://msdn2.microsoft.com/en-us/library/ms144259.aspx#reinstallmode
John
|||John,
Thanks for the reply! I've got two questions:
If I re-install, will it correctly detect the components to re-install, even
if I've already upgraded to SP2 (and the critical update for SP2)?
What exactly is Integration Services in SQL 2005? Is that sort of like the
DTS replacement? If so, is the absence of this COM+ object going to be a
hindrance?
Kind regards,
John Peterson
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:EB989A7F-2DD9-4A7C-BBB4-ECF7AD1568C4@.microsoft.com...
> Hi
> "John Peterson" wrote:
>
> Have you tried a re-install
> http://msdn2.microsoft.com/en-us/library/ms144259.aspx#reinstallmode
> John
|||Oh -- I also meant to ask whether I could expect the previous error to "go
away" if I were to try and re-install, or if it would likely pop up again?
Now that I've done a little more research on Integration Services (also
known as SSIS), it looks like it is a DTS replacement (and more). As such,
I know that I'll need to be using this component -- so if I can resolve this
installation error, I'll be a happy camper. :-)
Thanks for any additional help you (or any others) can provide!
John Peterson
"John Peterson" <j0hnp@.comcast.net> wrote in message
news:%23unJK%234fHHA.1216@.TK2MSFTNGP03.phx.gbl...
> John,
> Thanks for the reply! I've got two questions:
> If I re-install, will it correctly detect the components to re-install,
> even if I've already upgraded to SP2 (and the critical update for SP2)?
> What exactly is Integration Services in SQL 2005? Is that sort of like
> the DTS replacement? If so, is the absence of this COM+ object going to
> be a hindrance?
> Kind regards,
> John Peterson
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:EB989A7F-2DD9-4A7C-BBB4-ECF7AD1568C4@.microsoft.com...
>