March 11, 2013 at 11:43 am
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.
March 12, 2013 at 3:30 am
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply