In a testing scenario where there are calculations depending on the current time, it may be useful to set the windows time to a fixed date.
The problem is that the NTP time source in Windows Server 2008 will sync the time with the internet or the active directory. To stop this synchronization, the service windows time can be stopped or even un-installed.
This is where de command w32tm comes in:
Also to stop the windows time service:
net stop "windows time"
Now the date can be fixed.
The problem is that the windows authentication is going to fail when trying to connect those servers. The problem isn’t a issue if the testing scenario is to set the sql server database server date and you can use sql server authentication.