One server won't sync with the Operations Master in a Server 2008R2 environment

Posted on 2012-09-14
Last Modified: 2012-09-17
We have a Server 2008 R2 network, hosted on Hyper-V (the time synchronisation integration service is NOT selected). There are 12 member servers and 2 DCs, which all synchronise well with the FZMO-Operations Master (which is one of our DCs).
The only server that doesn't sync properly is our SQL server; it's out by about 5 seconds.
I have tried restarting the time service and "w32tm /resync" but while it says that it has completed succesfully, the 5 second delay persists.
However, I have found one difference when I queried it for the time server (w32tm /query /source); it showed the non-Operations Master DC as its source (strangely enough,that DC syncs correctly with the Operations Master).

The w32tm /resync /rediscover command doesn't seem to be changing the source to the Operations Master either.

What do i need to change so that the /rediscover option points to the correct Operations Master?

Any other suggestions please?
Question by:mark-199
    LVL 23

    Accepted Solution


    NET TIME \\PDCservername /SET /Y

    Lets hope it sticks.
    LVL 18

    Assisted Solution

    Time service is not so accurate to give you time sync second by second
    Its there to help kerberose for authentication you can tolerate time diffrence of about 5 Mins in environment using Windows Time Service

    Use below set of commands and set your Time service in domain However Expecting accuracy in seconds are not supported by windows Time
    If your DC holds the PDC role if yes run below command from CMD (Run as administrator)

    net stop w32time 
    w32tm /unregister 
    w32tm /register 
    net start w32time 
    net time /setsntp: 
    Net stop w32time & net start w32time 
    W32tm /config / /syncfromflags:manual /reliable:yes /update 
    W32tm /resync /rediscover 
    net stop w32time & net start w32time  

    Open in new window

    Run in non PDC DOmain COntrollers

    net stop w32time 
    w32tm /unregister 
    w32tm /register 
    net start w32time 
    net time /setsntp: 
    Net stop w32time & net start w32time 
    w32tm /config /syncfromflags:domhier /update 
    W32tm /resync /rediscover 
    net stop w32time & net start w32time  

    Open in new window

    Just Copy paste the commands in CMD

    After Doing above run
    dcdiag /test:advertising 

    Open in new window

    You may also see blog of MVP Ace for More info
    LVL 38

    Assisted Solution


    Synchronizing time is a horrible use of a word.

    The way time works is each client machine has a +or- window of 5 minutes (called a phase offset). If your computer is out of time by more than +/- 5 minutes windows time will readjust the time for that one computer. Until that computer is out of the 5 minute window, it will not adjust its time.

    Instead of using the term "synchronizing", a more appropriate term would be "convergence".

    Author Closing Comment

    Thanks everyone for your help.
    I followed the first solution and at least that immediately "synchronised" the time.
    If it drifts again, I will try the second solution.
    That particular server has had a time difference of up to two minutes so I wanted to fix this before it drifted apart from the domain-wide time even further.
    All other servers have the same time +/- 1 second.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    We recently endured a series of broadcast storms that caused our ISP to shut us down for brief periods of time. After going through a multitude of tests, we determined that the issue was related to Intel NIC drivers on some new HP desktop computers …
    I'm a big fan of Windows' offline folder caching and have used it on my laptops for over a decade.  One thing I don't like about it, however, is how difficult Microsoft has made it for the cache to be moved out of the Windows folder.  Here's how to …
    This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
    To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now