Re: Who is using MSMQ?

To add on to the other responses, the MSMQ warning messages you get from the
SQL Server Service Manager are the same ones you get from the Windows MMC
service manager or the command-line NET STOP command. These commands and
tools examine service dependencies and warn you accordingly. The warnings
are normal whenever a service dependencies exist.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Sam Hobbs" <samuel@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23Xe16SBMGHA.208@xxxxxxxxxxxxxxxxxxxxxxx
"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:%23haa1GoLGHA.1312@xxxxxxxxxxxxxxxxxxxxxxx
I thought Roger answered that quite well.

I specified the most relevant areas in which the answer was either not
provided or was not clear. Most important of all is the question of
whether it is normal to get the qustion asking about MSMQ and
MSMQTriggers.

MSMQ is not installed with SQL Server.

Okay, thank you. Do you know why the SQL Server Service Manager is asking
about MSMQ and MSMQTriggers? Most important of all, though, is the
question of whether this is normal.

They are two different applications and neither is directly
dependant on the other.

Note that you contradict yourself later in this message. The reason I say
that MSMQ and MSMQTriggers are dependent on MSDTC is because the message
from the SQL Server Service Manager says so.

The term MSMQ Triggers seems to be misleading you to believe that means
there are triggers in SQL Serve which is not the case.

No the reason I am asking about MSMQ Triggers is because the message from
the SQL Server Service Manager.

It is normal for SQL Server to use MSDTC when it is involved in
distributed transactions. But as Roger pointed out this is not dependant
on SQL Server or MSMQ.

Huh? I don't understand how that is relevant. Are you saying that SQL
Server is not dependent on SQL Server? I of course understand that MSDTC
is not dependent on SQL Server; I don't know what I said to indicate I
don't. As for whether SQL Server is dependent on MSMQ, see below.

All your message is doing is warning you that if you use SQL Server to
shut down the MSDTC service it can affect other services that depend on
MSDTC, in this case MSMQ.

What message? I did not say anything about a message from me.

As for the SQL Server Service Manager message, I mainly want to know if
the message from the SQL Server Service Manager is normal. You could
answer that question much faster than it took to post the many criticisms.
In other words, you are more concerned with criticising than answering the
question.

So in a nutshell your assumption of:
Are MSMQ and MSMQTriggers installed with SQL Server? I assume so.

is false.

So is it normal to get the message I am getting from the SQL Server
Service Manager? The message implies that MSMQ and MSMQTriggers are
installed and if they are installed then it is reasonable to assume that
SQL Server installed them. If that assumption is incorrect, then say so.
Yet the way you say it is incorrect is in a manner that emphasizes your
criticisms.

If it is normal for the SQL Server Service Manager to issue the message
about MSMQ and MSMQTriggers even if they are not installed, then that is
what is helpful and relevant. It would be easier to say that than to say
all the criticisms.




.

Relevant Pages

  • Re: Who is using MSMQ?
    ... SQL Server is one of several services ... that sometime uses DTC to manage distributed transactions. ... to shut down DTC for whatever reason, the dependency logic listed MSMQ as ... Do you know why the SQL Server Service Manager is asking ...
    (microsoft.public.sqlserver.security)
  • Re: Who is using MSMQ?
    ... it is normal to get the qustion asking about MSMQ and MSMQTriggers. ... Do you know why the SQL Server Service Manager is asking ...
    (microsoft.public.sqlserver.security)
  • Re: Who is using MSMQ?
    ... I understand about the dependencies; ... the SQL Server Service Manager are the same ones you get from the Windows ... about MSMQ and MSMQTriggers? ...
    (microsoft.public.sqlserver.security)
  • Re: Who is using MSMQ?
    ... MSMQ is not installed with SQL ... But as Roger pointed out this is not dependant on SQL Server ... the MSDTC service it can affect other services that depend on MSDTC, ... When I use SQL Server Service Manager to shutdown SQL Server, ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Network Interfaces, error: 26
    ... where zz is the name SQL Server Service Manager shows which is just the ... An error has occurred while establishing a connection to the server. ...
    (microsoft.public.dotnet.framework.aspnet)