Re: Who is using MSMQ?

I thought Roger answered that quite well. MSMQ is not installed with SQL
Server. They are two different applications and neither is directly
dependant on the other. The term MSMQ Triggers seems to be misleading you to
believe that means there are triggers in SQL Serve which is not the case. 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. Again each of these are separate applications or services. 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.
So in a nutshell your assumption of:
Are MSMQ and MSMQTriggers installed with SQL Server? I assume so.

is false.

--
Andrew J. Kelly SQL MVP


"Sam Hobbs" <samuel@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:u5I8aBnLGHA.964@xxxxxxxxxxxxxxxxxxxxxxx
Thank you for your answer but I am sorry, this answer is not as clear as
it could be. For example, I asked "Are MSMQ and MSMQTriggers installed
with SQL Server?" and the answer here is that "MSDTC is used by SQL Server
but it is actually part of Windows.".

The extent (whether rarely or frequently) to which SQL Server uses MSMQ is
not important here; the important thing is that SQL Server uses MSMQ and
therefore it is normal for the SQL Server Service Manager to start the
MSDTC. I am assuming it is normal althought that was not stated
explicitly.

Also, it is my understanding that MSMQ is not part of Windows; that it
must be installed separately. So are you saying that MSDTC issues the
message (that MSMQ is a dependent) by default when it is shutdown,
regardless of whether MSMQ is installed?

The most important question, though, is simply whether the behavior I
describe is normal. Regardless of everything else, I am just asking if
this normal. This question, in the SQL Server Security newsgroup, is
itended to ensure that there is not a security problem.


"Roger Wolter[MSFT]" <rwolter@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:OHZWu1cLGHA.2704@xxxxxxxxxxxxxxxxxxxxxxx
SQL Server does not use MSMQ except in some rare replication scenarios.
MSMQ does use MSDTC however which is why you get the error when you shut
down MSDTC. MSDTC is used by SQL Server but it is actually part of
Windows.

SQL Server 2000 is version 8.

--
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"Sam Hobbs" <samuel@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:OBOHImQLGHA.2812@xxxxxxxxxxxxxxxxxxxxxxx
Who is using MSMQ in my XP Pro system? I have SQL Server but I use it
only for development purposes. I think it is SQL Server 2000 but the EM
About box says version 8.

When I use SQL Server Service Manager to shutdown SQL Server, DTC is
running too. When I try to shut that down, I get a warning that MSMQ and
MSMQTriggers depend on it. Is this normal? I assume so, but I would feel
better if I knew for sure. One thing that I don't like about Microsoft
software is that it often does things automatically without us having a
way to know what is happening. Are MSMQ and MSMQTriggers installed with
SQL Server? I assume so.








.

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?
    ... SQL Server?" ... and the answer here is that "MSDTC is used by SQL Server but it ... The extent to which SQL Server uses MSMQ is ... MSMQTriggers depend on it. ...
    (microsoft.public.sqlserver.security)
  • 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 ...
    (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?
    ... SQL Server does not use MSMQ except in some rare replication scenarios. ... MSMQ does use MSDTC however which is why you get the error when you shut ...
    (microsoft.public.sqlserver.security)