How do I change "executed as" on sql jobs?

June 09th, 2008 - 09:13 am ET by fnadal via SQLMonster.com | Report spam
I've been consistently getting some strange errors such as: Unable to check
version on remote machine when executed by a domain/user account.

Our help desk said to change the owner of the job to 'sa' for the time being.
I've changed the job owner to 'sa' but it still executes the job as the
domain/user account. How do I change who executes the job?

What gives?

Thanks in advance!!

Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forum...r/200806/1
email Follow the discussionReplies 1 replyReplies Make a reply

Similar topics

Replies

#1 David Hay
June 09th, 2008 - 11:23 am ET | Report spam
The job owner is the context that the job is run as. I suggest
creating a domain user account that has the required privileges on
both machines. Then change SQL and SQL Agent to use that accounts to
start up with. The only other thing you can do is assign the job to a
domain user that has correct privileges on the remote box. I doubt SA
would do it as that is a SQL account only.

Google SQL Service Accounts

David
email Follow the discussion Replies Reply to this message
Help Create a new topicReplies Make a reply
Search Make your own search