Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Cattrah
Starting Member
13 Posts |
Posted - 2008-06-24 : 17:12:11
|
I am trying to schedule a simple job to run a stored procedure in my database. The stored procedure runs perfectly when I do so manually, however when I ask a job to run it, it gives me the following error:Access to the remote server is denied because the current security context is not trusted [SQLSTATE 42000](Error 15274).The stored procedure does create a linked server (to an ORACLE database) and executes some commands across it. I've tried doing the link server creation as a separate step in the job and it executes that just fine so it has no issues creating the server, it just dies when it tries to use it. The job owner is the same user I've been using the execute the procedure manually. I also run the procedure step as that same user. But I still have this problem. Someone please help me!! |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-24 : 18:50:12
|
I think SQL Agent account doesn't have permission for that server? |
|
|
|
|
|