?
Solved

Time Synchronization on SQL server

Posted on 2012-08-25
1
Medium Priority
?
578 Views
Last Modified: 2012-09-04
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
Comment
Question by:Sonali P
1 Comment
 
LVL 33

Accepted Solution

by:
Exchange_Geek earned 1500 total points
ID: 38333361
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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question