By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,377 Members | 1,326 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,377 IT Pros & Developers. It's quick & easy.

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'

P: 17

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

Expand|Select|Wrap|Line Numbers
  1. 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\ANONYMOUS LOGON'.

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


Jun 6 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 2,878
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
Jun 7 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.