• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 582
  • Last Modified:

Time Synchronization on SQL server


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.

SP_2018 .
SP_2018 .
1 Solution
Read the solution offered in the following link, though it was related to an AD Server - understand the logic given in it.


A fellow and respected EE has posted his thoughts on the following link, the issue never got resolved - but the flow of the solution pointed out that you shouldn't be using the host machine as TimeSync server - you're better of syncing with an external NTP Server than the host. Read the link given below.


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now