MS SQL Server - SQL startup hangs for 10 minutes on "attempting to initialize distributed transaction coordina

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

SQL startup hangs for 10 minutes on "attempting to initialize distributed transaction coordina

Mister_Tog

2006-02-28, 8:23 pm

We have a SQL service that consistently seems to take about 10-12
minutes to start up. After it finally started, everything is hunky
dory. I was able to review the SQL Server logs in the Enterprise
Manager. The SQL startup hangs on "attempting to initialize distributed
transaction coordinator."

It seems to get stuck on this for about 10 minutes. Everything else in
the startup process goes quickly EXCEPT for this line.

The most recent change that I am aware of is changing the ports in the
Client and Network server utilities so they match each other. I'm not
sure how this would be the cause. Changing this back simply means that
the clients can't connect anymore. Is it possible that changing the
ports interfered with communication with MSDTC? Any other thoughts?

Thanks!

Sponsored Links