February 12, 2008 at 2:13 pm
Hi, guys!, in my case I tried to use with Oracle (10g) through linked server from SQL Server 2000 SP3, I put a stored procedure inside a job (exec mysproc) with only 1 step.
I tried many times, and finally I have succeded executing the job, but only putting a windows account (win login) running with the Sql Server Agent, and the owner of the job with the same windows account (win login). Although I need a system account (sql login) to run with the agent service and the owner of the job with the system account too, but when I execute, the job fails, and the following error appears Executed as user: NT AUTHORITY\SYSTEM. Access to the remote server is denied because no login-mapping exists. [SQLSTATE 42000] (Error 7416). The step failed. I don't know why this happens
Please, help me. Thank you in advance
February 18, 2008 at 11:50 am
Because oracle wants his login, you maybe able to impersonate, but as far as I know, oracle wants you to login.
hope it helps
"We never plan to Fail, We just fail to plan":)
February 20, 2008 at 4:19 am
Yes, I know that Oracle use the own login, when I'm defining the linked server I put the local login and the remote login propertly, but does not work when I put a sql login as a owner of the job and running the sql server agent service with the same account, although with windows login works.
Help!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy