Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

[sjohnson1984]

Hello,

I am trying to gain data from a linked server using:

select * from [LINKEDSERVER].[DBNAME].dbo.CampaignFAct

However, receive back the error in the title of this post:

Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONY MOUS LOGON'.

Does this immediately make apparent what the problem is? No problems to provide more info...

Thanks

J

[ck9663]

Your linked server is using the default autonomous login to connect to the other server. Try to configure it using Trusted Connection or provide a username/password to connect.

-- CK