Solved

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

Posted on 2015-02-01
9
313 Views
Last Modified: 2015-02-25
Hi experts,
i am trying to execute a query the pull data from another serve, i added the server as a linked server to the another one but i am getting the following error when try to execute the query

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
\
search the net but didnt find any step by step solution to solve this issue, please help
0
Comment
Question by:AZZA-KHAMEES
  • 4
  • 3
  • 2
9 Comments
 
LVL 68

Expert Comment

by:Qlemo
ID: 40582375
In the Linked Server properties you should have a Security setting. This seems to be set to not using any security association. Change it to something more appropriate, in a domain you should be able to have it using your current user info, otherwise try with a fixed user and password.
0
 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 40583507
Post here how's your linked server defined.
'NT AUTHORITY\ANONYMOUS LOGON' is a local user so it won't be able to connect to a remote database.
0
 
LVL 68

Expert Comment

by:Qlemo
ID: 40583617
Vitor, that is nonsense. That user exists on each PC.
0
 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 40583621
@Qlemo:
I've said: "'NT AUTHORITY\ANONYMOUS LOGON' is a local user" and you replied: "That user exists on each PC. "
Isn't that a definition of local user!!?

He should have a domain user otherwise he needs to impersonate the user. Having the same name doesn't means that's the same user since internally they have different ID's.
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:AZZA-KHAMEES
ID: 40583629
thank you for the reply
do i have to create a new user with a permission to the other server,
when i configure the linked server i choose
[Be made using the login's security context]

which option do i have to chose? and do i have to add local login under the impersonate?
Linked server
0
 
LVL 46

Expert Comment

by:Vitor Montalvão
ID: 40583632
That option "Be made using the login's security context" it's only for domain users that needs to exists in both instances.
You can use an existing user from the other instance by choosing the option  "Be made using this security context". You just need to give the correct credential.
0
 
LVL 68

Expert Comment

by:Qlemo
ID: 40583645
If you want to have individual users mapping to other users, depending on who uses the link, then use the upper part of the dialog to enter those mappings. Data entered there superseeds anything you set up in the lower half, which is only used if the upper half does not match.

But interesting that MSSQL falls back to Anonymous if the user cannot get resolved on remote ... That account means "I have no user credentials available", and that again means "I don't use security". Most servers will deny access (default setting), but Anonymous Login can be switched on - that much just for completeness sake. Having authenticated users is mandatory.
0
 

Author Comment

by:AZZA-KHAMEES
ID: 40583683
i modified the properties in the security section of he linked server by adding username and password, and now i am getting a different error

OLE DB provider "SQLNCLI10" for linked server "mofneo" returned message "Unspecified error".
OLE DB provider "SQLNCLI10" for linked server "mofneo" returned message "The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_TABLES_INFO" for OLE DB provider "SQLNCLI10" for linked server "mofneo". The provider supports the interface, but returns a failure code when it is used.

note the server is sql 2008 and the linked server is sql 2000
0
 
LVL 46

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 40583698
note the server is sql 2008 and the linked server is sql 2000
SQL Server Native Client is only compatible with SQL Server 2000 with SP4 installed. Verify which SP do you have installed in the SQL Server 2000 instance.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
mysql joining from the same table 6 36
SQL server is using more virtual memory. 5 68
email about the whoisactive result 7 27
Update data using formula 22 22
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now