I have created a linked server from server A to server B. I am using the security setting "Be made using login's current security context". I am able to query the linked server from SSMS on Server A. When I use SSMS on my lptp, I can query all databases on server A. but the query to linked server B fails with the following error message:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
I tried creating a mapping for NT AUTHORITY\ANONYMOUS LOGON to my logon, but it throws permission error.
Please advise what needs to be done to use the linked server from lptp. Not everyone who needs to use the linked server has access to remote desktop on on Server A, but have access to query server A.
Thanks in advance.

