hi

I will elaborate more about the problem.

first server has sql agent login : DOMAIN\sqlman (sysadmin)

AND second server has its sql agent login : DOMAIN\sqlman (sysadmin)

More over both server also have same sql login : DOMAIN\sqlman

Actually on running Stored proc manually it works fine but when i run it in JOB

it gives error :

Executed as user: DOMAIN\SQLMan. Login failed for user 'DOMAIN\bkumar'. [SQLSTATE 28000] (Error 18456).

Here,

DOMAIN\bkumar is server windows login which has adminstrative rights on both servers

please suggest