Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesWe 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!
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread