Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I wish to do some testing on my local machine which requires me to put the date forward a year. So I can test some stuff in SQL Server (i've found it not possible to override the sql server time).

However because I'm connected to a domain, I believe this is causing the time to be reset to normal a few moments after I try to override it.

I understand that it's probably important for the local and domain time to be insync, but is it possible to temporarily block the clock from being reset?

Disconnecting from the network isn't an option, as I require an internet connection.

If there is a manual way to block the time reset what are the likely reprocutions? I don't want to screw anything up on the network :-)

share|improve this question
Would disabling the Windows Time service be acceptable? – jscott Feb 2 '12 at 17:55
yep disabling time service would do the trick.. – Cold T Feb 2 '12 at 17:57
Just be aware that if the SQL machine's time gets too far out of sync with the DCs, authentication will fail. – mfinni Feb 2 '12 at 18:21
Thanks for the tips – Alex KeySmith Feb 3 '12 at 10:13
If you're doing this on virtual machine, make sure to disable Time synchronization on your host VM manager because none of the above suggestions will otherwise work. – Dejan Mar 28 '15 at 8:50
up vote 10 down vote accepted

Open the registry editor (regedit), navigate to:


Find the REG_SZ value named Type. Edit the value to NoSync. Set it back to Nt5DS when you need to sync with the domain hierarchy again.

You can do this from the command line by calling

reg add HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\W32Time\Parameters /v Type /d NoSync /f

or in PowerShell, with:

Set-ItemProperty HKLM:\SYSTEM\CurrentControlSet\services\W32Time\Parameters -Name "Type" -Value "NoSync"
share|improve this answer
Thanks, +1 from me – Alex KeySmith Feb 3 '12 at 10:13
Interestingly my type value Type was set to NTP. So perhaps it was actually a NTP server setting which I couldn't see due to a domain policy or something. – Alex KeySmith Feb 3 '12 at 10:16
In some domain configurations, you might want to set the Type to NTP and add a specific DC to your list of NTP Sources, eg. if you have no DC's in your Site, and want to specify a remote DC with better connectivity than you have with the PDC Emulator. – Mathias R. Jessen Feb 3 '12 at 15:30

Disable the Windows Time service or block the outbound port 123 on your local firewall.

share|improve this answer
Thanks, +1 from me – Alex KeySmith Feb 3 '12 at 10:14

You can type this in the cmd terminal to stop the Windows Time Sync. It does what you needed in Window OS.

net stop w32time

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.