We have a Windows Server 2012 with SQL Server 2012 instance.
Its services used to run under an Active Directory account from an old domain, from Windows 2000 Server. A few years ago we replaced our AD to Windows Server 2012 and created a new domain.
Now we decided to replace the service account to the new domain. When that change was done, Windows Authentication failed to work. SQL Server shows message "Cannot generate SSPI context".
If I log in the server using MSTSC, Windows Authentication works. But if I try to log from my local PC, it fails.
I've read some support as https://support.microsoft.com/en-us/kb/811889, but it's kinda old and I'm unable to properly understand it.
Any idea what's causing this error, and how to solve it?