Getting the mentioned error while running the job in sql .i have added link server in the procedure and getting the error.
Cannot open database requested by the login. The login failed. Login failed for user ‘NT AUTHORITY\NETWORK SERVICE’.
Pls help with the solution for the error..
thanks in advance