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

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
0
SP_2018 .
Asked:
SP_2018 .
1 Solution
 
Exchange_GeekCommented:
Read the solution offered in the following link, though it was related to an AD Server - understand the logic given in it.

http://communities.vmware.com/thread/180007

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.

http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Windows_Server_2008/Q_27562893.html

Regards
Exchange_Geek
0
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