Time Synchronization on SQL server
Posted on 2012-08-25
Recently i came across this warning message on one of the VM servers with sql server installed
The time service detected a time difference of greater than 5000 milliseconds for 900 seconds. The time difference might be caused by synchronization with low-accuracy time sources or by suboptimal network conditions. The time service is no longer synchronized and cannot provide the time to other clients or update the system clock. When a valid time stamp is received from a time service provider, the time service will correct itself.
Momentarily the client machines got disconnected with this server
I was suspecting that “VMware Tools” might not have been installed on this virtual server, but they are installed & are supposed to help the VM synchronize time from the host.
Is their any connectivity betwen SQL, VMware, and time issues
Please advise what could cause this problem and a possible workaround.