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

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.dll 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 PetersonHi
"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.dll 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:
>> 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.dll 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|||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...
>> 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.dll 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
>sql

Problem with sorting in exported Excel document

Hello. I am using Reporting Services 2000 and Microsoft Excel 2003 running on
Windows XP Professional. I have a report that contains sales information that
I am exporting to Excel. The first two lines of the report contain title
information. They span all columns of the report. For example, the first line
(let's call it Food Sales Information) spans 15 columns. After the first two
lines of title information, there is a line containing the names of the
columns. After that, I have a lot of lines containing the sales data. I
export this to Excel. When I click in one of the numeric columns and click
the "A->Z" (sort ascending) button, I get the following error:
"This operation requires the merged cells to be identically sized."
Clciking Show Help gives me the following detail:
"This error only appears if you attempted to sort a range of previously
merged cells, but not all cells in the sort range were merged or are not of
the same size.
To avoid this behavior, unmerge all the merged cells in the range, or merge
all the cells in the range to be the same as the largest merged cell
grouping."
I believe this error to be caused the the two header rows. When I delete the
two header rows from the exported Excel document, I do not get the error.
Is there any way around this problem? Can I get the data to sort in Excel
without removing the header? Thanks in advance for the help.For those of you with this problem in the future who find this post
through google, Teo pointed me to a blog with this very issue
addressed. The bottom line is exporting to Excel from RS2000 leaves a
lot to be desired. Here is the blog with a work-around for this
problem:
http://blogs.msdn.com/chrisbal/archive/2006/07/08/659545.aspx

Problem with ServiceBroker

I use 2 SQL Server: 1 – SQL Server 2005 Enterprise on Windows Server 2003 (Itanium) and SQL Server Express on Windows XP Professional (Pentium).

I send the message from enterprise to express the message (at once I shall tell, that sending of the message in the opposite direction gives the same result) and I process the message on express. At first sight like all is correct. Messages I receive all, I read also all of them are correct. But further there are two strange things for me.

In the table sys.conversation_endpoints there is a record (one, irrespective of how many messages in one conversation) with “state=CD”. I read that they should be deleted after 30 minutes, but they did not. Using command … WITH CLEANUP helps but in a parallel way in Service Broker Profiler I observe occurrence of a mistake which occurs after closing dialogue.

I am disturbed with this mistake and the most important is that I not understand why it arises.

EXPRESS
Event Class	EventSubClass	TextData
Broker:Message Classify	1 - Local
Broker:Conversation Group	1 - Create
Broker:Conversation	12 - Dialog Created	STARTED_INBOUND
Broker:Conversation	6 - Received Sequenced Message	CONVERSING
Broker:Remote Message Acknowledgement	3 - Message with Acknowledgement Received
Broker:Conversation	6 - Received Sequenced Message	CONVERSING
Broker:Remote Message Acknowledgement	3 - Message with Acknowledgement Received
Broker:Conversation	7 - Received END CONVERSATION	DISCONNECTED_INBOUND
Broker:Remote Message Acknowledgement	3 - Message with Acknowledgement Received
Broker:Activation	1 - Start
Broker:Message Classify	2 - Remote
Broker:Remote Message Acknowledgement	2 - Acknowledgement Sent
Broker:Conversation	2 - END CONVERSATION	CLOSED
Broker:Conversation Group
Broker:Activation	2 - Ended
Broker:Connection	4 - Closing	An error occurred while receiving data: '64(error not found)'.
Broker:Connection	5 - Closed

Enterprise
Event Class	EventSubClass	TextData
Broker:Conversation Group	1 - Create
Broker:Conversation	11 - BEGIN DIALOG	STARTED_OUTBOUND
Broker:Conversation	1 - SEND Message	CONVERSING
Broker:Message Classify	2 - Remote
Broker:Conversation	1 - SEND Message	CONVERSING
Broker:Message Classify	2 - Remote
Broker:Conversation	1 - SEND Message	CONVERSING
Broker:Message Classify	2 - Remote
Broker:Conversation	2 - END CONVERSATION	DISCONNECTED_OUTBOUND
Broker:Conversation Group	2 - Drop
Broker:Message Classify	2 - Remote
Broker:Message Classify	2 - Remote
Broker:Remote Message Acknowledgement	1 - Message with Acknowledgement Sent
Broker:Remote Message Acknowledgement	1 - Message with Acknowledgement Sent
Broker:Remote Message Acknowledgement	1 - Message with Acknowledgement Sent
Broker:Message Classify	1 - Local
Broker:Conversation	10 - Received END CONVERSATION Ack	CLOSED
Broker:Remote Message Acknowledgement	4 - Acknowledgement Received
Broker:Connection	4 - Closing
Broker:Connection	5 - Closed

Yours faithfully,

From what I understand, you are doing a BEGIN DIALOG, followed by two SENDs and then END DIALOG, all from the initiator side (the enterprise instance).

The target side (express) is just passively receiving the messages, reacting with an END CONVERSATION itself when the it receives the END CONVERSATION message from the initiator.

In general, this pattern of BEGIN DIALOG/SEND/END (aka 'fire and forget') is not advisable. If the messages cannot be delivered (e.g. the target denies access to the service), the initiator never knows about this, since he already ended the conversation. My recomendation is to have the target end the dialog first, after receiving the two messages, and the initiator END CONVERSATION on it's turn as a reaction of receiving the end dialog message from target. Another side effect of this pattern of messages (when target never sends any message back) is that the target endpoint doesn't get deleted, and that is the problem you're seeing. This is a known issue and will be addressed in a next release.

If you're asking about the reason for the 'An error occurred while receiving data: '64(error not found)', this is simply because the connection between the two machines is timing out due to innactivity. One side will time out first (the enterprise in this case) and close the connection, the other side simply reports the fact that the connection was closed by the peer.

HTH,
~ Remus