i have two linked servers..whenever i execute Stored proc on linkedcserver ,it gives error
Msg 18456, Level 14, State 1, Line 1
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.
on both server's sql agent , i have same login with same rights.
If i use sql authentication it runs fine but if i set a job to execute it it gives above error
how to get rid of this ?
please help me
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)