InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 11:45:37 GMT20http://www.sqlservercentral.com/Forums/Topic1358779-1549-1.aspx[quote][b]alanspeckman (9/14/2012)[/b][hr]Why would SQL Server restart when DTC is failed over, especially when DTC isn't even used according to transaction statistics in the Clustered DTCs folder under Component Services?[/quote]Service dependencies would be the only logical conclusionTue, 18 Sep 2012 05:24:13 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1358779-1549-1.aspxWindows 2008Mon, 17 Sep 2012 09:29:53 GMTalanspeckmanhttp://www.sqlservercentral.com/Forums/Topic1358779-1549-1.aspxWindows 2003 or Windows 2008 cluster?Mon, 17 Sep 2012 02:40:41 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1358779-1549-1.aspxThey were not errors really, just intermittent connections issues with getting to 1 server of the 2 load balanced web servers. I can't RDP into those servers, so I cannot see specific errors. But the thinking of the SA, at the time, was that since the cluster resources were split between 2 nodes, that was causing the problem. So, she failed over DTC and that made SQL services restart.Why would SQL Server restart when DTC is failed over, especially when DTC isn't even used according to transaction statistics in the Clustered DTCs folder under Component Services?Both web servers are on the same timezone. Same with my SQL ServersI suspect the problem was that one node of the load balanced web servers had the wrong time, off by something like 6 hours, from the 2nd server, where connections were still happening. This would cause intermittent connection problems to the actual application.Is there any truth to that?Fri, 14 Sep 2012 12:05:15 GMTalanspeckmanhttp://www.sqlservercentral.com/Forums/Topic1358779-1549-1.aspx[quote][b]alanspeckman (9/13/2012)[/b][hr]If we have 2 resource groups1. MS-DTC2. SQL ServerAnd the MSDTC resources lyes on Node A, and the SQL Server resources(disks, IP, SQL Server, Agent) lye on Node B, would this be a possible cause for users not being able to connect to SQL Server?[/quote]No, what errors are your users getting[quote][b]alanspeckman (9/13/2012)[/b][hr]Also, If we have 2 web servers load balances, but Server C is 6 hours behind Server D, would this cause issues with users trying to connect to the application, or cause issues with the application trying to connect to the database?Thank youAlan[/quote]Are the servers in different time zones?Fri, 14 Sep 2012 02:04:40 GMTPerry Whittlehttp://www.sqlservercentral.com/Forums/Topic1358779-1549-1.aspxIf we have 2 resource groups1. MS-DTC2. SQL ServerAnd the MSDTC resources lyes on Node A, and the SQL Server resources(disks, IP, SQL Server, Agent) lye on Node B, would this be a possible cause for users not being able to connect to SQL Server?Also, If we have 2 web servers load balances, but Server C is 6 hours behind Server D, would this cause issues with users trying to connect to the application, or cause issues with the application trying to connect to the database?Thank youAlanThu, 13 Sep 2012 12:28:47 GMTalanspeckman