Drop Table

Support Forum for database administrators and web based access to important newsgroups related to databases
Register on Database Support Forum Edit your profileCalendarFind other Database Support forum membersFrequently Asked QuestionsSearch this forum -> 
For Database admins: Free Database-related Magazines Now Free shipping to Texas


Post New Thread










Thread
Author

SQL startup hangs for 10 minutes on "attempting to initialize distributed transaction coordinat
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!


Report this thread to moderator Post Follow-up to this message
Old Post
Mister_Tog
03-01-06 01:23 AM


Sponsored Links





Last Thread Next Thread
Post New Thread

MS SQL Server archive

Show a Printable Version Email This Page to Someone! Receive updates to this thread
Microsoft SQL Server
Access database support
PostgreSQL Replication
SQL Server ODBC
FoxPro Support
PostgreSQL pgAdmin
SQL Server Clustering
MySQL ODBC
Web Applications with dBASE
SQL Server CE
MySQL++
Sybase Database Support
MS SQL Full Text Search
PostgreSQL Administration
SQL Anywhere support
DB2 UDB Database
Paradox Database Support
Filemaker Database
Berkley DB
SQL 2000/2000i database
ASE Database
Forum Jump:
All times are GMT. The time now is 06:13 AM.

 
Mobile devices forum | Database support forum archive




Copyrights DropTable.com Database Support Forum 2004 - 2006