SQL query will work on SQL server SSMS but not on desktop SSMS

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.
FAC_ITAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mohammed KhawajaManager - Infrastructure:  Information TechnologyCommented:
Sounds like your SQL server service is running using NT Authority.  Change the server to run using a domain account and it should work fine.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
I suppose that [2008R2 server] is an existing linked server name, right?
If so check the credentials configuration for that linked server.
0
Peter KipropCommented:
Try to use SQL authentication when connecting to the database and see if the query will run. Ensure on the configuration that Mixed mode is set
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.