Re: sql agent permission
From: Sue Hoegemeier (Sue_H@nomail.please)
Date: 06/27/02
- Next message: Raks: "Re: Alert for SQL Server Shutdown and Startup events"
- Previous message: Sue Hoegemeier: "Re: sql agent permission"
- In reply to: Eric: "sql agent permission"
- Next in thread: Eric: "Re: sql agent permission"
- Reply: Eric: "Re: sql agent permission"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: Sue Hoegemeier <Sue_H@nomail.please> Date: Thu, 27 Jun 2002 15:46:04 -0600
And some of what you are asking may depend on the security
mapping of the linked server but I really lost what you were
saying in terms of your linked server configuration.
-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
- Next message: Raks: "Re: Alert for SQL Server Shutdown and Startup events"
- Previous message: Sue Hoegemeier: "Re: sql agent permission"
- In reply to: Eric: "sql agent permission"
- Next in thread: Eric: "Re: sql agent permission"
- Reply: Eric: "Re: sql agent permission"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
