Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

The clocks on the client and server machines are skewed Expand / Collapse
Author
Message
Posted Sunday, May 29, 2011 5:56 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 4:22 AM
Points: 31, Visits: 178
Hi all,

When running SP which read data from remote server (linked server), after few minutes, I get the following error: "Failed with the following error: ERROR: SQL Network Interfaces: The clocks on the client and serevr machines are skewed".

We checked the clocks on both machines, they are both on the same domain and connected to the same DC.

Does any body have an idea?

Thanks,
Ran.
Post #1116763
Posted Sunday, May 29, 2011 7:32 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:32 AM
Points: 6,196, Visits: 13,354
Regional settings???

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1116773
Posted Sunday, May 29, 2011 10:26 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Sunday, July 27, 2014 6:10 AM
Points: 4,179, Visits: 4,260
Two articles on setting regional settings:

http://support.microsoft.com/kb/273558

http://stackoverflow.com/questions/211549/how-to-change-system-default-regional-settings-in-windows-xp



For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #1116788
Posted Sunday, May 29, 2011 10:42 AM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Yesterday @ 7:32 AM
Points: 64, Visits: 1,227
Hi Ran

Are the clocks on all machines and the DC showing the same time?

Best Regards
Chris
Post #1116791
Posted Sunday, May 29, 2011 10:27 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 4:22 AM
Points: 31, Visits: 178
Thank you all, but I forgot to mention that it is not happening all the times...
So if it was regional setting, it would have occur all the time...
Post #1116849
Posted Monday, May 30, 2011 12:02 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, July 18, 2011 3:54 AM
Points: 492, Visits: 481
that might be a problem of Time synchronization with domain controller,schedule the time synchronize with Domain controller command on OS level on the machine who creating this problem

Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

My Blog
www.aureus-salah.com
Post #1116873
Posted Monday, May 30, 2011 2:21 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 4:40 PM
Points: 159, Visits: 454
I agree with Syed.

The clocks on the client and server machines are skewed".

Had same issue, seems some servers were losing time sync with domain controller/s.
Affected browsing certain in-house websites, also could not logon to one server via RDP.
Once server time sync with DC's was resolved, the 'clocks skewed' error disappeared.
Post #1117126
Posted Tuesday, December 10, 2013 3:44 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 11, 2013 12:56 AM
Points: 2, Visits: 2
I get ... error: ERROR: SQL Network Interfaces: The clocks on the client and serevr machines are skewed".


Please treat as urgent.

Kindly give the solution.
Post #1521440
Posted Tuesday, December 10, 2013 4:02 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 4:22 AM
Points: 31, Visits: 178
Hi,

I tried to find the solution which helped us.
If i'm not wrong - we installed lated SP to the OS.

Ran.
Post #1521442
Posted Wednesday, December 11, 2013 12:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 11, 2013 12:56 AM
Points: 2, Visits: 2
hi,

error : The clocks on the client and server machines are skewed".

solution : Once server time sync with DC's was resolved, the 'clocks skewed' error disappeared.

Post #1521767
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse