We are trying to figure out what is wrong with our server. Right now i have many accounts that are sql accounts and windows authenticated (domain accounts).
When i connect with ANY windows authenticated account i get an error
Cannot generate SSPI context
The account is good. I have also been trying to connect simply using Management Studio and i get the same error. If i use any SQL accounts it works and all windows authenticated account fails.
That being said, if i do a remote desktop to the SQL server itself and try using Management Studio on the server itself, all Windows authenticated account works without error.
The error only shows for remote computer (same domain / ip range) when using windows authenticated connections.
i have found this but it doesn't fix anything. According to the doc no accounts should work if we are getting this error.
Now what changed, the only thing that change is that the server was a virtual machine on VMWare, there was a conversion done to switch it to hypervisor and the instance has been restarted.
Anyone else would know when SSPI error can show based of where the authentication request was called ? i haven't been able to find anything. Could possibly be a bad error. Our servers have been down for the whole weekend we still haven't found anyone with the same issue.
Important notes :
- PC that remote and connect to
SQL are in the same domain, same physical location, plugged in the same rack mount network wise.
- Running using IP or DNS doesn't change anything.
- no error logs show up in
SQL and neither in
Event Viewer on the server