Re: sql agent permission

From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 06/27/02 

From: Sue Hoegemeier <Sue_H@nomail.please>
Date: Thu, 27 Jun 2002 15:41:46 -0600

Job ownership affects the security context of jobs in the
following way:
If the owner of a job is a member of the sysadmin role then
the job will run under the security context of the service
account for SQL Server Agent.
If the owner of a job is not a member of the sysadmin role
then the job will run under the security context of the
proxy account.

-Sue

On Thu, 27 Jun 2002 21:26:02 GMT, eric.guo@gtnexus.com
(Eric) wrote:

>Hi,
>
>I have a situation and hope someone can give me a pointer.
>
>I have two w2k servers (serverA and serverB) that are not in a domain
>and I want to set up serverB as a standby server. I run a sql agent
>job on serverA to perform the followings in sequence.
>
>1. back up the production database on serverA
>2. copy the backup file from serverA to serverB
>3. call a stored procedure on serverB to restore the database on
>serverB.
>
>While step 1 and 2 work fine, I just can not have the remote sp to
>restore the database.
>
>The job on serverA is owned by a sql account (ABC) that is in
>sysadmin role.
>
>The sqlserveragent and msssqlserver services are run under a local
>account(XYZ) that is in local admin group.
>
>The linked server is created with the connection from serverA to
>serverB as ABC. ABC has exec right on the stored procedure.
>
>The job history shows that "the job is executed as serverA\XYZ". My
>question is when step 3 gets executed, is it ABC that connects the
>serverB and runs the sp or is it serverA\XYZ, which should fail?
>
>TIA
>
>
>Eric

Relevant Pages

  • sql agent permission
    ... I have two w2k servers (serverA and serverB) that are not in a domain ... call a stored procedure on serverB to restore the database on ... accountthat is in local admin group. ... serverB as ABC. ...
    (microsoft.public.sqlserver.security)
  • Re: sql agent permission
    ... saying in terms of your linked server configuration. ... >and I want to set up serverB as a standby server. ... call a stored procedure on serverB to restore the database on ... >serverB as ABC. ...
    (microsoft.public.sqlserver.security)