MS SQL Server - RE: SQL startup hangs for 10 minutes on "attempting to initialize dist

Author

RE: SQL startup hangs for 10 minutes on "attempting to initialize dist

John Bell

2006-02-28, 8:23 pm

Hi

Have you checked for information in the Windows Event log?

John

"Mister_Tog" wrote:

> 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