SP_2018 .
asked on
Time Synchronization on SQL server
Hi,
Recently i came across this warning message on one of the VM servers with sql server installed
Warning message:
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.
Thanks
Recently i came across this warning message on one of the VM servers with sql server installed
Warning message:
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.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.