SMS: Time Synchronizing an SMS Site Server with SQL Server
Article ID: 202552
Article Last Modified on 10/27/2006
APPLIES TO
- Microsoft Systems Management Server 2.0 Standard Edition
- Microsoft Systems Management Server 1.2 Standard Edition
This article was previously published under Q202552
SYMPTOMS
When the system time on the Systems Management Server (SMS) Site Server and the Microsoft SQL Server become different, SMS may begin to experience operational problems such as difficulties distributing software.
CAUSE
This issue can occur because SMS does not provide any checks that confirm that accuracy of the time on the SMS site server in relation to a time server or a SQL server.
WORKAROUND
To work around this issue, the Microsoft Windows NT Resource Kit includes a tool that can install a "time service" to synchronize the time on the server, even if no one is logged in, or ever logs in. Please view the Windows NT Resource Kit documentation for installation and configuration instructions for the Timeserv.exe tool. Administrators could use the Timeserv.exe tool to synchronize the servers automatically.
For additional information about how to set up a Windows NT Server as a Time server, click the article number below
to view the article in the Microsoft Knowledge Base:
131715 How to Set Up And Synchronize with Domain Time Source Servers
Additional query words: prodsms
Keywords: kbprb KB202552