Help troubleshooting DTC start

Hi -
Our Small Business Server 2003 (SBS) can not start the DTC (distributed
transaction coordinator) service. Each time it tries, an error appears is
the System log that says, " Error - Distributed Transaction Coordinator
failed to start.
(event id 7000) "The service did not respond to the start or control request
in a timely fashion".
SBS has a single instance of SQL. We have tried the following:
1. Stopping the SQL Server, Server Agent and attempting to restart DTC -
same error
2. Stopping SQL server, Server Agent and then typing "MSDTC -resetlog" in a
command window. The command appears to have completed successfully, however
the same error appears when we attempt to start DTC.
Does anyone have any suggestions on how to trouble-shoot this particular
issue. It happens consistently on this server.
Thanks for your help.
BobHi Bob,
Go to the windows\system32\MSDtc, rename MSDTC.LOG and create a new file
MSDTC.LOG.
Open a command prompt, type mdtc -resetlog.
Hugs,
Rodrigo Fernandes
"Bob L. - SBS" wrote:
> Hi -
> Our Small Business Server 2003 (SBS) can not start the DTC (distributed
> transaction coordinator) service. Each time it tries, an error appears is
> the System log that says, " Error - Distributed Transaction Coordinator
> failed to start.
> (event id 7000) "The service did not respond to the start or control request
> in a timely fashion".
> SBS has a single instance of SQL. We have tried the following:
> 1. Stopping the SQL Server, Server Agent and attempting to restart DTC -
> same error
> 2. Stopping SQL server, Server Agent and then typing "MSDTC -resetlog" in a
> command window. The command appears to have completed successfully, however
> the same error appears when we attempt to start DTC.
> Does anyone have any suggestions on how to trouble-shoot this particular
> issue. It happens consistently on this server.
> Thanks for your help.
> Bob
>|||Thanks for the quick response, however...
Went to dir MSDtc and found MSDTC.LOG file (4096 KB).
Renamed current log file.
Created new txt file with same name MSDTC.LOG
Opened CMD window, entered msdtc -resetlog (ran without error)
Stopped SQL Server Agent service
Stopped SQL Server service
Attempted to start DTC service - same error
Looked back at new log file - it is now 4096 KB in size
?
Bob
"Rodrigo Fernandes" wrote:
> Hi Bob,
> Go to the windows\system32\MSDtc, rename MSDTC.LOG and create a new file
> MSDTC.LOG.
> Open a command prompt, type mdtc -resetlog.
> Hugs,
> Rodrigo Fernandes
>
> "Bob L. - SBS" wrote:
> > Hi -
> > Our Small Business Server 2003 (SBS) can not start the DTC (distributed
> > transaction coordinator) service. Each time it tries, an error appears is
> > the System log that says, " Error - Distributed Transaction Coordinator
> > failed to start.
> > (event id 7000) "The service did not respond to the start or control request
> > in a timely fashion".
> >
> > SBS has a single instance of SQL. We have tried the following:
> > 1. Stopping the SQL Server, Server Agent and attempting to restart DTC -
> > same error
> > 2. Stopping SQL server, Server Agent and then typing "MSDTC -resetlog" in a
> > command window. The command appears to have completed successfully, however
> > the same error appears when we attempt to start DTC.
> >
> > Does anyone have any suggestions on how to trouble-shoot this particular
> > issue. It happens consistently on this server.
> >
> > Thanks for your help.
> >
> > Bob
> >|||Hi Bob,
What the account you use to start DTC Service ?
Try to start DTC with Local Administrator account.
I'm searching anothers solutions for help you.
Hugs,
Rodrigo Fernandes
MCSE/MCDBA
"Bob L. - SBS" wrote:
> Hi -
> Our Small Business Server 2003 (SBS) can not start the DTC (distributed
> transaction coordinator) service. Each time it tries, an error appears is
> the System log that says, " Error - Distributed Transaction Coordinator
> failed to start.
> (event id 7000) "The service did not respond to the start or control request
> in a timely fashion".
> SBS has a single instance of SQL. We have tried the following:
> 1. Stopping the SQL Server, Server Agent and attempting to restart DTC -
> same error
> 2. Stopping SQL server, Server Agent and then typing "MSDTC -resetlog" in a
> command window. The command appears to have completed successfully, however
> the same error appears when we attempt to start DTC.
> Does anyone have any suggestions on how to trouble-shoot this particular
> issue. It happens consistently on this server.
> Thanks for your help.
> Bob
>|||Rodrigo - Thank you. Changing accounts from the Network Service (NT
Authority) account to the Local Administrator account let DTC start without a
problem.
You are "the man of the hour".
Bob
PS - I'm attempting to isolate the permissions problem with Regmon
(Sysinternals.com), but it is "Started" and that is what really matters.
"Rodrigo Fernandes" wrote:
> Hi Bob,
> What the account you use to start DTC Service ?
> Try to start DTC with Local Administrator account.
> I'm searching anothers solutions for help you.
> Hugs,
> Rodrigo Fernandes
> MCSE/MCDBA
> "Bob L. - SBS" wrote:
> > Hi -
> > Our Small Business Server 2003 (SBS) can not start the DTC (distributed
> > transaction coordinator) service. Each time it tries, an error appears is
> > the System log that says, " Error - Distributed Transaction Coordinator
> > failed to start.
> > (event id 7000) "The service did not respond to the start or control request
> > in a timely fashion".
> >
> > SBS has a single instance of SQL. We have tried the following:
> > 1. Stopping the SQL Server, Server Agent and attempting to restart DTC -
> > same error
> > 2. Stopping SQL server, Server Agent and then typing "MSDTC -resetlog" in a
> > command window. The command appears to have completed successfully, however
> > the same error appears when we attempt to start DTC.
> >
> > Does anyone have any suggestions on how to trouble-shoot this particular
> > issue. It happens consistently on this server.
> >
> > Thanks for your help.
> >
> > Bob
> >|||Actually, changing accounts "just look like it worked." In SBS 2003,
Microsoft requires that DTC be run with the Network Service account (for
security reasons). So, back to the fun...
Here is what I learned from this exercise:
1. The SLOW boot was caused by malfunctioning COM+
- Component Services was VERY SLOW to open
- When finally open, "My Computer" would not display on right side
- Nor when right-clicking would any MSDTC function be visible
2. The malfunction in COM+ was that MS DTC was not starting
- Error 1053 - when attempting to start DTC
- Changing accounts from Network Service to Local Account let DTC start
- However, in SBS 2003, DTC must be run with Network Service account
(MS security "fix")
- Running MSDTC - uninstall and MSDTC -install did not help problem
- MSDTC -resetlog (with accompanying file changes) did not help problem
- Running filemon (sysinternals.com) on DTC start with Network Service
account showed two files that Network Service did not have permissions to
access.
- Changing (restoring) permissions on these two files cured the
problem. DTC started under Network Service account and COM+ snapped back
into operation (after a reboot).
We are talking to a third-party vendor about changing file permissions...
Thanks again.
Bob L. - SBS
"Bob L. - SBS" wrote:
> Rodrigo - Thank you. Changing accounts from the Network Service (NT
> Authority) account to the Local Administrator account let DTC start without a
> problem.
> You are "the man of the hour".
> Bob
> PS - I'm attempting to isolate the permissions problem with Regmon
> (Sysinternals.com), but it is "Started" and that is what really matters.
> "Rodrigo Fernandes" wrote:
> > Hi Bob,
> >
> > What the account you use to start DTC Service ?
> > Try to start DTC with Local Administrator account.
> >
> > I'm searching anothers solutions for help you.
> >
> > Hugs,
> >
> > Rodrigo Fernandes
> > MCSE/MCDBA
> >
> > "Bob L. - SBS" wrote:
> >
> > > Hi -
> > > Our Small Business Server 2003 (SBS) can not start the DTC (distributed
> > > transaction coordinator) service. Each time it tries, an error appears is
> > > the System log that says, " Error - Distributed Transaction Coordinator
> > > failed to start.
> > > (event id 7000) "The service did not respond to the start or control request
> > > in a timely fashion".
> > >
> > > SBS has a single instance of SQL. We have tried the following:
> > > 1. Stopping the SQL Server, Server Agent and attempting to restart DTC -
> > > same error
> > > 2. Stopping SQL server, Server Agent and then typing "MSDTC -resetlog" in a
> > > command window. The command appears to have completed successfully, however
> > > the same error appears when we attempt to start DTC.
> > >
> > > Does anyone have any suggestions on how to trouble-shoot this particular
> > > issue. It happens consistently on this server.
> > >
> > > Thanks for your help.
> > >
> > > Bob
> > >