Avatar of HBS-Mach
HBS-Mach
Flag for Solomon Islands

asked on 

Disable Time Sync on Windows server on Domain

I have a supplier of software who wants to test some date related functions within MS SQL2008R2
Their stored procedures use GETDATE() and GETUTCDATE() to get the date, which reads from the underlying Windows 2012 server with MSSQL.

Their solution is to change the system date on the SQL server whenever they want to do their testing of date functions.

However, the Active Directory, quite rightly, changes the system time back to the correct PDC emulator time within 10-20 minutes.

Ive tried moving the AD object into a Test OU and block all Group Policy inheritence to ensure it isnt a GPO that is changing the time

Is there anyway, apart from dropping the server off the domain, that I can stop the Windows 2012 server from syncing its time from the Active Directory?
The server needs to remain on the domain for other parts of the software testing.
Windows Server 2012Active DirectoryMicrosoft SQL ServerWindows OS

Avatar of undefined
Last Comment
HBS-Mach

8/22/2022 - Mon