Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
This error will come if we are trying write any queries(Distributed Queries) using Linked Servers. Linked server will create such a way using Security Context (RightClick on Linked Servers -> Properties->Be made using this Security Context).If this is the scenario
If we run query we get the above error Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. But you can access the same server Manually with Management Studio. But if you write query using Linked Server You may get this Error. So Ensure that after creating Linkeserver check this Linked server by using Query.
Eg:SELECT * FROM LinkedServerName.master.dbo.sysobjects
To avoid this error change security context one way is"Be made using this Security Context" TO "Be made without using a Security Context"
And Sometimes you get the permission from that(remote system)sysadmin.
If we run query we get the above error Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. But you can access the same server Manually with Management Studio. But if you write query using Linked Server You may get this Error. So Ensure that after creating Linkeserver check this Linked server by using Query.
Eg:SELECT * FROM LinkedServerName.master.dbo.sysobjects
To avoid this error change security context one way is"Be made using this Security Context" TO "Be made without using a Security Context"
And Sometimes you get the permission from that(remote system)sysadmin.
Comments