Another "cannot generate SSPI context" error

• ryan.botha

  Grasshopper

  Points: 18

  More actions

  March 11, 2013 at 11:43 am

  #275105

  Freaking odd one here guys. :unsure:

  2 SQL 2008 R2 servers on the same domain, but in different data centers. Live and DR.

  Both servers running as the same domain\user same rights on both servers.

  If I connect from live to DR with the IP I connect with both SQL user and AD user.

  If I connect from live to DR with the machine domain name, I can connect at SQL user.

  However if I connect from live to DR with the machine domain name with the same domain\user used for the IP connect gives I get the "cannot generate SSPI context" error. :ermm:

  Additionally, I was working earlier with the Live sql service running under another domain\user. I changed it to get the live service off a domain admin account.

  Any help here would be good.

  Thanks.

  Ryan.

• ryan.botha

  Grasshopper

  Points: 18

  More actions

  March 12, 2013 at 3:30 am

  #1595863

  Solution found.

  The DR side instance is running under the same Domain\user as the live is now.

  However unknown to me the domain admin after I requested the password for this user, went and changed it and gave me the new password, but didn't tell me that he actually changed it.

  Solution was: Reset the password for the service account on the DR server and restart SQL.