Urgent Question - Time Sychronization Across a Domain

iceman_2001_ie

I have a a SQL server running on one machine on my network, and I need to synchronize the time between all the machines on the network.

Microsoft help has been especially useless as to how to do it.
Has anybody successfully done it, and if so, would you mind imparting the information on me.

Cheers.

sirlinux

net time /setsntp:ie.pool.ntp.org if it's 2000 or 2003 server and you have permanent internet access, otherwise replace ie.pool.ntp.org with the ip of your interrnal ntp server, if your running Active Directory this should be done for you .

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnw2kmag01/html/TimeWin2K.asp

for nt4 or older consider the NTP client/server at

http://www.five-ten-sg.com/

which actually runs fine on 2000/2003 as well.

Capt'n Midnight

if you aren't worried about true time you could also use.

Net time \\computername /Domain /SET

JDxtra

Or, if you want ultra-synchronisation and don't mind spending a few quid then go for Domain Time from Greyware Software (http://www.greyware.com/software/domaintime/).

They make some nifty other utils as well.

sirlinux

in all honesty ntpd is the world wide standard in accuracy, you can even use it with a gps, you would be wasting your money on this, on windows you can to within a couple of ms of accuracy, better on solaris & linux.

jdempsey wrote:

Or, if you want ultra-synchronisation and don't mind spending a few quid then go for Domain Time from Greyware Software (http://www.greyware.com/software/domaintime/).

They make some nifty other utils as well.