Click here to Skip to main content
14,638,468 members
Rate this:
Please Sign up or sign in to vote.
See more:
Dear Alll

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
Posted
Rate this:
Please Sign up or sign in to vote.

Solution 1

   
Comments
Pratham25 16-Apr-13 2:10am
   
thanks for reply

Tried the same but still facing the same issue ....
Any other way i can try to resolve it .
need help for the same...\

Thanks in advance
Pratham
Rate this:
Please Sign up or sign in to vote.

Solution 2

As this was the issue with my linked server .issue rectified and required linked server added and issue resolved .
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100