Link to home
Start Free TrialLog in
Avatar of SP_2018 .
SP_2018 .Flag for United States of America

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
ASKER CERTIFIED SOLUTION
Avatar of Exchange_Geek
Exchange_Geek
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial