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
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> > >
>
