<div>
Kerberos, which AD uses, will break within 5 minutes or so of time discrepancy (default value, you can change to other than 5 minutes)<br />
<br />
So, if you don't need any kind of authentication or security tokens, you might be able to get away with doing this.<br />
<br />
A registry change to make the server use itself as a time source would probably work (but remember to keep in mind my first 2 statements)
</div>


<div>
Hi Kaffiend,<br />
<br />
I understand that we will break the ability to login with a domain account while the time is incorrect.<br />
The idea is that just during the testing, the date is changed. <br />
They DO NOT log out of the machine while the date is incorrect.<br />
They change it back to correct time before they logout<br />
<br />
A reboot or logging in with a local account to re-adjust the time will allow domain accounts to log back in, if they forget to change it or get booted off for some reason.<br />
<br />
What would the registry change be to set the server as its own time source?
</div>


<div>
Thanks all.<br />
I will give these a go and get back to you tomorrow.
</div>


<div>
Hi all<br />
Thanks for the help.<br />
<br />
@oBdA - A reboot does fix the time when ive reconfigured the syncfromflag. <br />
Maybe its a group policy we have, but a reboot resets the time to the correct time<br />
But, stopping the service also works.<br />
<br />
@acbrown2010 - Thanks, w32tm /config /syncfromflags:no /update worked fine for me.<br />
<br />
@kaffiend - thanks for pointing me in the right direction to look it up myself. Teach a man to fish etc...
</div>


<div>
w32tm /config /syncfromflags:no /update <br />
<br />
worked fine for me.<br />
Check if the change is reverted back, otherwise the server will be changed forever.
</div>


<div>
<div class="content wysiwyg-content">
I have a supplier of software who wants to test some date related functions within MS SQL2008R2<br />
Their stored procedures use GETDATE() and GETUTCDATE() to get the date, which reads from the underlying Windows 2012 server with MSSQL.<br />
<br />
Their solution is to change the system date on the SQL server whenever they want to do their testing of date functions.<br />
<br />
However, the Active Directory, quite rightly, changes the system time back to the correct PDC emulator time within 10-20 minutes.<br />
<br />
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<br />
<br />
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?<br />
The server needs to remain on the domain for other parts of the software testing.
</div>
</div>


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.

Disable Time Sync on Windows server on Domain

Windows Server 2012 is the server version of Windows 8 and the successor to Windows Server 2008 R2. Windows Server 2012 is the first version of Windows Server to have no support for Itanium-based computers since Windows NT 4.0. Windows Server 2012, now in its second release (Windows Server 2012 Release 2) includes Foundation, Essentials, Standard and Datacenter, and does not support IA-32 or IA-64 processors.

Windows Server 2012

Active Directory (AD) is a Microsoft brand for identity-related capabilities. In the on-premises world, Windows Server AD provides a set of identity capabilities and services, and is hugely popular (88% of Fortune 1000 and 95% of enterprises use AD). This topic includes all things Active Directory including DNS, Group Policy, DFS, troubleshooting, ADFS, and all other topics under the Microsoft AD and identity umbrella.

Active Directory

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.