Re: SS Agent Required to Local Admin?

From: Kimberly L. Tripp (Kimberly@nospam.sqlskills.com)
Date: 10/15/02 

From: "Kimberly L. Tripp" <Kimberly@nospam.sqlskills.com>
Date: Mon, 14 Oct 2002 21:08:27 -0700

What are the rights of the SQLServerAgent account on server2. I'm guessing
that it's having troubles performing the operations you want it to.

So - as long as the SQLServerAgent account is a domain account AND that
domain account has SQL Server rights on server2 you should be ok (unless
there's some specific requirement for OLAP - and I can't imagine there is).
It shouldn't have to be an nt admin of server2 though.

hth,
kt

Kimberly L. Tripp
********************
Please do not send mail to me directly - reply on the newsgroup.
Please include legible and tested code samples (and ddl if possible!). This
makes it easier to test and answer your questions. Thanks!

"Rick Carroll" <rick@r.net> wrote in message
news:uqbqmbdst05s73@corp.supernews.com...
> Does SS Agent on a SS2K machine have to be in the local administrators
group
> to run jobs?
>
> Scenario:
>
> Job is created on server1 (local) to update OLAP cubes on server2
(remote).
> Job was created in SSAgent and scheduled to run.
>
> If the job is located on the remote OLAP server and run on the remote OLAP
> server, it runs okay; if, however, it runs from the local machine, it
> bombs. Permissions and accounts all have appropriate security, but
SSAgent
> isn't a member of local admins on the remote server. It is in the OLAP
> admin group on the remote server.
>
> Are there any special requirements to make this work. Does the SSA
account
> have to be the same domain/windows account on both machines?
>
> Does the SSA account have to be a member of each machine's local
> administrator's group?
>
>
>
>
>
>
>

Relevant Pages

  • Re: RWW and Remote desktop stopped working on all clients
    ... After diggin through ALL the group policies, I found Remote ... Desktop DISABLED under the Account Lockout policy - I don't think I've even ... adminsitrator or another account with Domain Admin role; also the server ...
    (microsoft.public.windows.server.sbs)
  • Re: IIS 6 Directory Services Mapping ACL Problems
    ... It would appear that you can not delegate Certificate based credentials. ... IIS does not have the user's password, so it can't just logon to the remote ... file server as the user directly. ... Lastly - if you want to see what account is being used to access the remote ...
    (microsoft.public.inetserver.iis.security)
  • Re: asp.net remote [hosted] configuration usse
    ... That includes machine admin rights. ... to manipulate the that one site, one of many on a remote PC running Win2k3. ... The FrontPage Server Extensions Access Method ... Create an account on the remote Web Server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: IIS 6.0 with Mapped Drives
    ... The user account that IIS is impersonating needs to have permissions to ... permissions to the remote resource. ... folder on local drive on the server, this local folder is Virtual Directory ...
    (microsoft.public.inetserver.iis)
  • Re: Port Forward
    ... And no I don't want to remote into both at the same time. ... remote into one of the computer workstations OR the Server. ... I don't log into my server with my user account. ... Right now my client Remotes into a workstation with default port ...
    (microsoft.public.windows.server.sbs)