I am running a SQL query from SQL 2014 to SQL 2008R2. When I run the query for the SQL server will run fine. When I run it from my desktop I get the following error:
Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
When I look at the logs on the server that the query is connecting to this is the error I am getting:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON Reason: Token-based server access validation failed with an infrastructure error.
Here is the query I am running. I am running from SQL 2014:
SELECT * FROM [2008R2 server].CCMData.dbo.DimTime
I am using my domain credentials.
Thanks for any help.