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 |
|
craigwg
Posting Yak Master
154 Posts |
 Posted - 2009-09-25 : 10:08:17
|
| Hi all,I have been working with several jobs that check the status of other jobs across many linked servers (around 80) total. On the source server the account is a Windows account in a domain (CORP\a) and the job runs fine until it hits a server that CORP\a is NOT running SQL Server Agent. These are production servers so I can NOT simply change the account running SQL Server Agent. The job I am running is very simple. Just a single line: exec sp_jobstatus. The owner of the job is my own admin account with full rights and the owner of the job is the same account. I'm not even 100% clear why the account running SQL Agent is involved, but the error message clearly says "Access denied to the SQL Account CORP\a on suchandsuch server...". What's my work around here? Execute as? CraigCraig Greenwood |
|
|
craigwg
Posting Yak Master
154 Posts |
Posted - 2009-09-25 : 15:29:03
|
| After a series of trials what we did was set it up to run as a proxy account which worked great.Craig Greenwood |
 |
|
|
|
|
|
Acct running Agent changes across linked servers