September 13, 2012 at 12:28 pm
If we have 2 resource groups
1. MS-DTC
2. SQL Server
And 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 you
Alan
September 14, 2012 at 2:04 am
alanspeckman (9/13/2012)
If we have 2 resource groups1. MS-DTC
2. SQL Server
And 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?
No, what errors are your users getting
alanspeckman (9/13/2012)
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 you
Alan
Are the servers in different time zones?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 14, 2012 at 12:05 pm
They 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 Servers
I 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?
September 17, 2012 at 2:40 am
Windows 2003 or Windows 2008 cluster?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
September 17, 2012 at 9:29 am
Windows 2008
September 18, 2012 at 5:24 am
alanspeckman (9/14/2012)
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?
Service dependencies would be the only logical conclusion
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply