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 |
|
Bex
Aged Yak Warrior
580 Posts |
 Posted - 2009-04-15 : 11:52:40
|
| Hi thereI have a procedure that is executed in a job, and the procedure accesses a different server. The server is set up as a linked server, and I can execute the proc under my windows account. however, when I run the job, I get the following error:Executed as user: NT AUTHORITY\SYSTEM. Login failed for user 'DEV\WS23$'. [SQLSTATE 28000] (Error 18456). The step failed.Can someone please explain to me what I need to do/configure?ThanksHearty head pats |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-04-15 : 13:13:05
|
| Your SQL Agent needs to run in domain account. |
 |
|
|
|
|
|
SQL Agent Login Failed to Linked Server