We have a production environment that we have used to clone into our lab environment for testing. We are using Vcloud Director to host this virtual environment. In production all of our linked servers are using Kerberos for security to use logins own context. In our VCloud environment everything looks the same as production. The problem we are having is that everything looks good as far as SPN goes and in AD the sql server service account is running under an account that uses account delegation but we are still getting the error:
Msg 18456, Level 14, State 1, Line 1 Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
We tried to verify it is using kerberos with this query, "select net_transport, auth_scheme from sys.dm_exec_connections where session_id=@@spid". However in vcloud it returns NTLM, and production is returns Kerberos. We have tried a bunch of things and nothing seems to work. We rebooted machines, added and removed account delegation in AD, etc. Anyone else run into this?