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 |
|
DvlsAdvc8
Starting Member
2 Posts |
 Posted - 2010-09-13 : 14:48:38
|
| I am trying to schedule a nightly job to query a remote database and insert records that do not already exist in the local database.Running the job causes an error that I can't find any information to resolve: "'EXECUTE AS USER' failed for the requested user '[MyUser]' in the database '[LocalDB]'. The step failed." Severity 16, Message ID 33009Trustworthy is set to on for the local db. The linked server login mapping is correct - and I can run my procedure from SMS fine. It just fails when run as a job.I appreciate anyone who has any solution ideas I can look into. Thanks. |
|
|
DvlsAdvc8
Starting Member
2 Posts |
Posted - 2010-09-13 : 14:49:55
|
| Neglected to mention: local db is SQL Server 2008. Remote DB is SQL Server 2000. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-09-13 : 15:26:49
|
| seems SQL Agent account doesn't have permissions on linked server |
|
|
|
|
|
|
Scheduled Job failure