Re: Who is using MSMQ?

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?
    ... 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: 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)