Re: sql agent permission

From: SQL Guy (SQLGuy@EarthLink.Net)
Date: 06/30/02 

From: "SQL Guy" <SQLGuy@EarthLink.Net>
Date: Sat, 29 Jun 2002 21:43:54 -0700

Unless it's a domain account, the SQLAgent account has no rights over
another server so you can't read/write outside of the box.

"Eric" <ericguo_00@yahoo.com> wrote in message
news:3d1ccae5.618390378@news.microsoft.com...
> Sue,
>
> Thanks for your response.
>
> In terms of linked server configuration, all I said is that the sql
> account used to connect the remote standby server is the same account
> (with sysadmin rights) that owns the job. I got the following error
> on step 3 in the job history. Note sqlservice is the local OS account
> that mssqlserver service runs under.
>
> Executed as user: DB1\sqlservice. Could not relay results of procedure
> 'gp_restore_db_backup' from remote server 'db2'. [SQLSTATE 42000]
> (Error 7221) [SQLSTATE 01000] (Error 7312). The step failed.
>
>
> On Thu, 27 Jun 2002 15:46:04 -0600, Sue Hoegemeier
> <Sue_H@nomail.please> wrote:
>
> >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
> >
>

Relevant Pages

  • Re: Re-Post - "the trust relationship between this workstation and the
    ... "the trust relationship between this workstation and the primary domain ... only problem is adding a new user account on the station. ... Client computer must use STRICTLY the INTERNAL DNS server which can ... Attr: subschemaSubentry ...
    (microsoft.public.windows.server.active_directory)
  • Re: Same question, still no answer!!!
    ... Sounds then like we are all paying for a feature set only large companies ... The "proxy server" pc is actually an older box stuffed ... Expectation #1) keep the ethernet more or less as is. ... The kids account would be ...
    (microsoft.public.windowsxp.basics)
  • Re: Re-Post - "the trust relationship between this workstation and the
    ... "the trust relationship between this workstation and the primary domain ... only problem is adding a new user account on the station. ... This would be on the DNS server 172.20.100.2 ... Attr: subschemaSubentry ...
    (microsoft.public.windows.server.active_directory)
  • Sending email to mydomain.com
    ... server will appear as undeliverable. ... This happens because you are using the POP3 connector... ... an NDR when an account doesn't exist). ... >different from the user account names for the exchange ...
    (microsoft.public.windows.server.sbs)
  • Re: Basic Authentication + IIS 5 + Windows 2000 + Frontpage 2002 = failure?
    ... Everytime I attempt to login under Basic Authentication, ... IUSR_blah account. ... the anonymous user impersonated by the IIS Server is the ... > Event Viewer Security log. ...
    (microsoft.public.inetserver.iis.security)