troubleshooting Question

Windows Server 2003 - Time Service

Avatar of ActiveInfoSys
ActiveInfoSysFlag for United Kingdom of Great Britain and Northern Ireland asked on
ExchangeMicrosoft SQL Server 2005Microsoft Legacy OS
5 Comments1 Solution239 ViewsLast Modified:
Hello Experts -

Wondering if someone could offer a few hints and tips here please.

Looking to sync time on about 21 Windows Server 2003 boxes.  An application newly installed, with SQL Backend Clusters and Front-End Web Servers, requires all servers in the mix to all have same time, room for deviation is less than 1 minute.  

Any body got any tips on how to setup and monitor the situation with time on all servers.

Also wondering why Active Directory is not enough to keep servers in sync.

I've created a batch file to run on each server with the following commands:

w32tm /config /update /manualpeerlist: /syncfromflags:MANUAL
net stop w32time
net start w32time

However, need a way to monitor and report on the time of each server and show the differences if any over say a one month period.

At the moment, under Active Directory, after 1-2 weeks, the servers will slowly go over 2 minutes differences from each other.

Any help very appreciated.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros