• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

SQL cluster node error

Hello Experts,

I have a client who is running into the following issue

clock sync error

 
Link to SQL Server on new Windows 2012 host IDCSQLCL01_N02 is throwing the following errors:
 
“The clocks on the client and server machines are skewed.”
 
“Cannot generate SSPI context”

Note:

The time on the server looks correct.  


Any ideas?
0
Jerry Seinfield
Asked:
Jerry Seinfield
  • 3
  • 2
  • 2
  • +1
1 Solution
 
PadawanDBAOperational DBACommented:
that stinks like an NTP issue.  compare the time on the cluster node to the DC. if they are more than5 minutes apart, Kerberos authentication breaks (which is essentially what the SSPI context error is saying - Kerberos authentication is broken)
0
 
Jerry SeinfieldAuthor Commented:
The time on the node and the time on the dc are identical

Any other ideas?
0
 
PadawanDBAOperational DBACommented:
where is the connection that generates the error originating from?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Jerry SeinfieldAuthor Commented:
The connection is a Windows 7 machine that talks to the cluster node
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You may have registered both ipv4 and ipv6 addresses on the DNS server. Try to delete the ipv6 address entry and check if the error is solved.
0
 
Jerry SeinfieldAuthor Commented:
Are you saying on the WIndow 7 machine or the SQL cluster node?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
In your DNS server check for the ipv4 and ipv6 addresses of the Server that's returning the error.
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Where do your Servers and Workstations sync their time from ?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

  • 3
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now