hi,

i have read all the comments as well as suggestion but my problem is little bit different ,i have two servers .i am executing a query on linked server...its giving below wriiten error

Msg 18456, Level 14, State 1, Line 1

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

i have checked sql server agent login on both servers .both have same login name with same rights.

still it is giving error

Can any one suggest any solution??