MSSQLSERVER service hangs on loading DTC

Hi All,
MSSSQLSERVER service is hanging for ever after auto reboot.
it stops at DTC loading :
SQL Server terminating because of system shutdown.
SQL Server is starting at priority class 'normal'(4 CPUs detected).
SQL Server configured for thread mode processing.
Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
Attempting to initialize Distributed Transaction Coordinator.
.........
..............
DTC service is disabled and running under local system account.
Sql services are running under domain admin account.
We are starting it manually every time this occurs.
the version is
Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4).
There is below DCOM error in the eveny log at the same time.Is this causing
the problem?
DCOM got error "The service cannot be started, either because it is disabled
or because it has no enabled devices associated with it. " attempting to
start the service EventSystem with arguments "" in order to run the server:
{1BE1F766-5536-11D1-B726-00C04FB926AF}
Can any one shed some light on it?
Thanks,
Suchi
Some more info:
Start up modes are as below:
Mssqlserver --manual
SQLagent--Manual
DTC --manual
Disabled auto-startup of the 3 services from within EM.
Thanks,
Suchi
"Suchi" wrote:

> Hi All,
> MSSSQLSERVER service is hanging for ever after auto reboot.
> it stops at DTC loading :
> SQL Server terminating because of system shutdown.
> SQL Server is starting at priority class 'normal'(4 CPUs detected).
> SQL Server configured for thread mode processing.
> Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
> Attempting to initialize Distributed Transaction Coordinator.
> ........
> .............
> DTC service is disabled and running under local system account.
> Sql services are running under domain admin account.
> We are starting it manually every time this occurs.
> the version is
> Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4).
> There is below DCOM error in the eveny log at the same time.Is this causing
> the problem?
> DCOM got error "The service cannot be started, either because it is disabled
> or because it has no enabled devices associated with it. " attempting to
> start the service EventSystem with arguments "" in order to run the server:
> {1BE1F766-5536-11D1-B726-00C04FB926AF}
> Can any one shed some light on it?
> Thanks,
> Suchi
>
|||Did you try reinstalling DTC?
I dont' think DCOM alert has something to do with it...not sure doh.

MSSQLSERVER service hangs on loading DTC

Hi All,
MSSSQLSERVER service is hanging for ever after auto reboot.
it stops at DTC loading :
SQL Server terminating because of system shutdown.
SQL Server is starting at priority class 'normal'(4 CPUs detected).
SQL Server configured for thread mode processing.
Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
Attempting to initialize Distributed Transaction Coordinator.
........
.............
DTC service is disabled and running under local system account.
Sql services are running under domain admin account.
We are starting it manually every time this occurs.
the version is
Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4).
There is below DCOM error in the eveny log at the same time.Is this causing
the problem?
DCOM got error "The service cannot be started, either because it is disabled
or because it has no enabled devices associated with it. " attempting to
start the service EventSystem with arguments "" in order to run the server:
{1BE1F766-5536-11D1-B726-00C04FB926AF}
Can any one shed some light on it?
Thanks,
SuchiSome more info:
Start up modes are as below:
Mssqlserver --manual
SQLagent--Manual
DTC --manual
Disabled auto-startup of the 3 services from within EM.
Thanks,
Suchi
"Suchi" wrote:
> Hi All,
> MSSSQLSERVER service is hanging for ever after auto reboot.
> it stops at DTC loading :
> SQL Server terminating because of system shutdown.
> SQL Server is starting at priority class 'normal'(4 CPUs detected).
> SQL Server configured for thread mode processing.
> Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
> Attempting to initialize Distributed Transaction Coordinator.
> ........
> .............
> DTC service is disabled and running under local system account.
> Sql services are running under domain admin account.
> We are starting it manually every time this occurs.
> the version is
> Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4).
> There is below DCOM error in the eveny log at the same time.Is this causing
> the problem?
> DCOM got error "The service cannot be started, either because it is disabled
> or because it has no enabled devices associated with it. " attempting to
> start the service EventSystem with arguments "" in order to run the server:
> {1BE1F766-5536-11D1-B726-00C04FB926AF}
> Can any one shed some light on it?
> Thanks,
> Suchi
>|||Did you try reinstalling DTC?
I dont' think DCOM alert has something to do with it...not sure doh.

MSSQLSERVER service hangs on loading DTC

Am using SQL 2000 SP4
Whenever the system is re-booted, SQL service hangs while loading. The
last entry ion the startup log indicates is :
"Attempting to initialize Distributed Transaction Coordinator"
When I check the services, DTC is running.
To fix the problem I manually kill (pskill) the process, log off and
then log back in.
Once logged back in, I manually start the SQL server and agent.
SteveHi Steve
Do you have autostart DTC enabled, if so you may want to try removing it
(server properties page in EM).
John
"Steve Babcock" wrote:
> Am using SQL 2000 SP4
> Whenever the system is re-booted, SQL service hangs while loading. The
> last entry ion the startup log indicates is :
> "Attempting to initialize Distributed Transaction Coordinator"
> When I check the services, DTC is running.
> To fix the problem I manually kill (pskill) the process, log off and
> then log back in.
> Once logged back in, I manually start the SQL server and agent.
> Steve
>|||John - tried disabling DTC from starting up (which it did - service was not
running) this but the result was the same - last entry in startup log is :
"Attempting to initialize Distributed Transaction Coordinator"
Steve
John Bell wrote:
> Hi Steve
> Do you have autostart DTC enabled, if so you may want to try removing it
> (server properties page in EM).
> John
> "Steve Babcock" wrote:
> > Am using SQL 2000 SP4
> >
> > Whenever the system is re-booted, SQL service hangs while loading. The
> > last entry ion the startup log indicates is :
> > "Attempting to initialize Distributed Transaction Coordinator"
> >
> > When I check the services, DTC is running.
> >
> > To fix the problem I manually kill (pskill) the process, log off and
> > then log back in.
> > Once logged back in, I manually start the SQL server and agent.
> >
> > Steve
> >
> >|||Hi Steve
Have you tried making SQLServer and DTC manual services, then starting SQL
Server from a command line, to see what happens?
John
"Steve Babcock" wrote:
> John - tried disabling DTC from starting up (which it did - service was not
> running) this but the result was the same - last entry in startup log is :
> "Attempting to initialize Distributed Transaction Coordinator"
> Steve
> John Bell wrote:
> > Hi Steve
> >
> > Do you have autostart DTC enabled, if so you may want to try removing it
> > (server properties page in EM).
> >
> > John
> >
> > "Steve Babcock" wrote:
> >
> > > Am using SQL 2000 SP4
> > >
> > > Whenever the system is re-booted, SQL service hangs while loading. The
> > > last entry ion the startup log indicates is :
> > > "Attempting to initialize Distributed Transaction Coordinator"
> > >
> > > When I check the services, DTC is running.
> > >
> > > To fix the problem I manually kill (pskill) the process, log off and
> > > then log back in.
> > > Once logged back in, I manually start the SQL server and agent.
> > >
> > > Steve
> > >
> > >
>|||That's our next step - will have to do it later today outside of office hours.
John Bell wrote:
> Hi Steve
> Have you tried making SQLServer and DTC manual services, then starting SQL
> Server from a command line, to see what happens?
> John
> "Steve Babcock" wrote:
> > John - tried disabling DTC from starting up (which it did - service was not
> > running) this but the result was the same - last entry in startup log is :
> > "Attempting to initialize Distributed Transaction Coordinator"
> >
> > Steve
> >
> > John Bell wrote:
> >
> > > Hi Steve
> > >
> > > Do you have autostart DTC enabled, if so you may want to try removing it
> > > (server properties page in EM).
> > >
> > > John
> > >
> > > "Steve Babcock" wrote:
> > >
> > > > Am using SQL 2000 SP4
> > > >
> > > > Whenever the system is re-booted, SQL service hangs while loading. The
> > > > last entry ion the startup log indicates is :
> > > > "Attempting to initialize Distributed Transaction Coordinator"
> > > >
> > > > When I check the services, DTC is running.
> > > >
> > > > To fix the problem I manually kill (pskill) the process, log off and
> > > > then log back in.
> > > > Once logged back in, I manually start the SQL server and agent.
> > > >
> > > > Steve
> > > >
> > > >
> >
> >|||John :
I disabled auto-startup of the 3 services from within EM, re-booted and loaded
each one from the SQL Manager in order for DTC, SQL, SQLA - all was OK.
Is there a way to see a more detailed log so that I can tell where it's hangin up
on loading. Even though it says it's waiting for DTC, DTC is running as a
service when SQL is trying to start up.
Steve
John Bell wrote:
> Hi Steve
> Have you tried making SQLServer and DTC manual services, then starting SQL
> Server from a command line, to see what happens?
> John
> "Steve Babcock" wrote:
> > John - tried disabling DTC from starting up (which it did - service was not
> > running) this but the result was the same - last entry in startup log is :
> > "Attempting to initialize Distributed Transaction Coordinator"
> >
> > Steve
> >
> > John Bell wrote:
> >
> > > Hi Steve
> > >
> > > Do you have autostart DTC enabled, if so you may want to try removing it
> > > (server properties page in EM).
> > >
> > > John
> > >
> > > "Steve Babcock" wrote:
> > >
> > > > Am using SQL 2000 SP4
> > > >
> > > > Whenever the system is re-booted, SQL service hangs while loading. The
> > > > last entry ion the startup log indicates is :
> > > > "Attempting to initialize Distributed Transaction Coordinator"
> > > >
> > > > When I check the services, DTC is running.
> > > >
> > > > To fix the problem I manually kill (pskill) the process, log off and
> > > > then log back in.
> > > > Once logged back in, I manually start the SQL server and agent.
> > > >
> > > > Steve
> > > >
> > > >
> >
> >|||Hi
The SQL Server log will log each event in the same way as you should see how
when it manually started. You could add a dependency of SQL Server on DTC so
that it does not even try to start before DTC has started. I don't know if
the DTC service logs anywhere other than the event log.
John
"Steve Babcock" wrote:
> John :
> I disabled auto-startup of the 3 services from within EM, re-booted and loaded
> each one from the SQL Manager in order for DTC, SQL, SQLA - all was OK.
> Is there a way to see a more detailed log so that I can tell where it's hangin up
> on loading. Even though it says it's waiting for DTC, DTC is running as a
> service when SQL is trying to start up.
> Steve
> John Bell wrote:
> > Hi Steve
> >
> > Have you tried making SQLServer and DTC manual services, then starting SQL
> > Server from a command line, to see what happens?
> >
> > John
> >
> > "Steve Babcock" wrote:
> >
> > > John - tried disabling DTC from starting up (which it did - service was not
> > > running) this but the result was the same - last entry in startup log is :
> > > "Attempting to initialize Distributed Transaction Coordinator"
> > >
> > > Steve
> > >
> > > John Bell wrote:
> > >
> > > > Hi Steve
> > > >
> > > > Do you have autostart DTC enabled, if so you may want to try removing it
> > > > (server properties page in EM).
> > > >
> > > > John
> > > >
> > > > "Steve Babcock" wrote:
> > > >
> > > > > Am using SQL 2000 SP4
> > > > >
> > > > > Whenever the system is re-booted, SQL service hangs while loading. The
> > > > > last entry ion the startup log indicates is :
> > > > > "Attempting to initialize Distributed Transaction Coordinator"
> > > > >
> > > > > When I check the services, DTC is running.
> > > > >
> > > > > To fix the problem I manually kill (pskill) the process, log off and
> > > > > then log back in.
> > > > > Once logged back in, I manually start the SQL server and agent.
> > > > >
> > > > > Steve
> > > > >
> > > > >
> > >
> > >
>|||How do I set up the dependency - I don;t see where in Services I can do this.
Steve
John Bell wrote:
> Hi
> The SQL Server log will log each event in the same way as you should see how
> when it manually started. You could add a dependency of SQL Server on DTC so
> that it does not even try to start before DTC has started. I don't know if
> the DTC service logs anywhere other than the event log.
> John
> "Steve Babcock" wrote:
> > John :
> >
> > I disabled auto-startup of the 3 services from within EM, re-booted and loaded
> > each one from the SQL Manager in order for DTC, SQL, SQLA - all was OK.
> >
> > Is there a way to see a more detailed log so that I can tell where it's hangin up
> > on loading. Even though it says it's waiting for DTC, DTC is running as a
> > service when SQL is trying to start up.
> >
> > Steve
> >
> > John Bell wrote:
> >
> > > Hi Steve
> > >
> > > Have you tried making SQLServer and DTC manual services, then starting SQL
> > > Server from a command line, to see what happens?
> > >
> > > John
> > >
> > > "Steve Babcock" wrote:
> > >
> > > > John - tried disabling DTC from starting up (which it did - service was not
> > > > running) this but the result was the same - last entry in startup log is :
> > > > "Attempting to initialize Distributed Transaction Coordinator"
> > > >
> > > > Steve
> > > >
> > > > John Bell wrote:
> > > >
> > > > > Hi Steve
> > > > >
> > > > > Do you have autostart DTC enabled, if so you may want to try removing it
> > > > > (server properties page in EM).
> > > > >
> > > > > John
> > > > >
> > > > > "Steve Babcock" wrote:
> > > > >
> > > > > > Am using SQL 2000 SP4
> > > > > >
> > > > > > Whenever the system is re-booted, SQL service hangs while loading. The
> > > > > > last entry ion the startup log indicates is :
> > > > > > "Attempting to initialize Distributed Transaction Coordinator"
> > > > > >
> > > > > > When I check the services, DTC is running.
> > > > > >
> > > > > > To fix the problem I manually kill (pskill) the process, log off and
> > > > > > then log back in.
> > > > > > Once logged back in, I manually start the SQL server and agent.
> > > > > >
> > > > > > Steve
> > > > > >
> > > > > >
> > > >
> > > >
> >
> >|||Hi Steve
Dependencies should be a tab on the properties dialog for the services
applet (from administrators on the start menu or control panel). If you
double clicking your SQL Server service it should appear.
John
"Steve Babcock" wrote:
> How do I set up the dependency - I don;t see where in Services I can do this.
> Steve
> John Bell wrote:
> > Hi
> >
> > The SQL Server log will log each event in the same way as you should see how
> > when it manually started. You could add a dependency of SQL Server on DTC so
> > that it does not even try to start before DTC has started. I don't know if
> > the DTC service logs anywhere other than the event log.
> >
> > John
> >
> > "Steve Babcock" wrote:
> >
> > > John :
> > >
> > > I disabled auto-startup of the 3 services from within EM, re-booted and loaded
> > > each one from the SQL Manager in order for DTC, SQL, SQLA - all was OK.
> > >
> > > Is there a way to see a more detailed log so that I can tell where it's hangin up
> > > on loading. Even though it says it's waiting for DTC, DTC is running as a
> > > service when SQL is trying to start up.
> > >
> > > Steve
> > >
> > > John Bell wrote:
> > >
> > > > Hi Steve
> > > >
> > > > Have you tried making SQLServer and DTC manual services, then starting SQL
> > > > Server from a command line, to see what happens?
> > > >
> > > > John
> > > >
> > > > "Steve Babcock" wrote:
> > > >
> > > > > John - tried disabling DTC from starting up (which it did - service was not
> > > > > running) this but the result was the same - last entry in startup log is :
> > > > > "Attempting to initialize Distributed Transaction Coordinator"
> > > > >
> > > > > Steve
> > > > >
> > > > > John Bell wrote:
> > > > >
> > > > > > Hi Steve
> > > > > >
> > > > > > Do you have autostart DTC enabled, if so you may want to try removing it
> > > > > > (server properties page in EM).
> > > > > >
> > > > > > John
> > > > > >
> > > > > > "Steve Babcock" wrote:
> > > > > >
> > > > > > > Am using SQL 2000 SP4
> > > > > > >
> > > > > > > Whenever the system is re-booted, SQL service hangs while loading. The
> > > > > > > last entry ion the startup log indicates is :
> > > > > > > "Attempting to initialize Distributed Transaction Coordinator"
> > > > > > >
> > > > > > > When I check the services, DTC is running.
> > > > > > >
> > > > > > > To fix the problem I manually kill (pskill) the process, log off and
> > > > > > > then log back in.
> > > > > > > Once logged back in, I manually start the SQL server and agent.
> > > > > > >
> > > > > > > Steve
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> > >
>

MSSQLSERVER service hangs on loading DTC

Hi All,
MSSSQLSERVER service is hanging for ever after auto reboot.
it stops at DTC loading :
SQL Server terminating because of system shutdown.
SQL Server is starting at priority class 'normal'(4 CPUs detected).
SQL Server configured for thread mode processing.
Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner
Blocks.
Attempting to initialize Distributed Transaction Coordinator.
........
.............
DTC service is disabled and running under local system account.
Sql services are running under domain admin account.
We are starting it manually every time this occurs.
the version is
Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4).
There is below DCOM error in the eveny log at the same time.Is this causing
the problem?
DCOM got error "The service cannot be started, either because it is disabled
or because it has no enabled devices associated with it. " attempting to
start the service EventSystem with arguments "" in order to run the server:
{1BE1F766-5536-11D1-B726-00C04FB926AF}
Can any one shed some light on it?
Thanks,
SuchiSome more info:
Start up modes are as below:
Mssqlserver --manual
SQLagent--Manual
DTC --manual
Disabled auto-startup of the 3 services from within EM.
Thanks,
Suchi
"Suchi" wrote:

> Hi All,
> MSSSQLSERVER service is hanging for ever after auto reboot.
> it stops at DTC loading :
> SQL Server terminating because of system shutdown.
> SQL Server is starting at priority class 'normal'(4 CPUs detected).
> SQL Server configured for thread mode processing.
> Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Own
er Blocks.
> Attempting to initialize Distributed Transaction Coordinator.
> ........
> .............
> DTC service is disabled and running under local system account.
> Sql services are running under domain admin account.
> We are starting it manually every time this occurs.
> the version is
> Microsoft SQL Server 2000 - 8.00.818 (Intel X86)
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4).
> There is below DCOM error in the eveny log at the same time.Is this causin
g
> the problem?
> DCOM got error "The service cannot be started, either because it is disabl
ed
> or because it has no enabled devices associated with it. " attempting to
> start the service EventSystem with arguments "" in order to run the server
:
> {1BE1F766-5536-11D1-B726-00C04FB926AF}
> Can any one shed some light on it?
> Thanks,
> Suchi
>|||Did you try reinstalling DTC?
I dont' think DCOM alert has something to do with it...not sure doh.