Re: Win2k and SQL2k security

From: Daniel Billingsley (dbillingsley@NO.durcon.SPAAMM.com)
Date: 04/15/03 

From: "Daniel Billingsley" <dbillingsley@NO.durcon.SPAAMM.com>
Date: Tue, 15 Apr 2003 15:48:08 -0400

I was just reading KB article 283811 and it might be of some help. I don't
think complete local admin rights would be necessary, but the OS commands
are going to run in the context of the service account if I understand
correctly what you're asking, so it would have to be appropriately elevated.

"Dolemite" <beavis@mtv.com> wrote in message
news:uktOasyADHA.1600@TK2MSFTNGP10.phx.gbl...
> You'd probably get a better answer in the SQL newsgroups.
>
>
> "TM" <mayflower1230@fuse.net> wrote in message
> news:053701c302bb$6da22a70$3301280a@phx.gbl...
> > Does anyone know a url to a white paper that explains what
> > rights the Sql Server Agent needs in order to create
> > operating system and Active Script jobs not belonging to
> > members of the sysadmin server role? I have a book that
> > explains this, however I need to have an official white
> > paper from Microsoft so that I can document that the agent
> > must be started with a dedicated account with Win2k admin
> > rights in order to run these types of jobs.
> >
> > Any input would be appreciated.
> >
> > Thanks
>
>

Relevant Pages

  • Re: Srv03 and W2k CA differences
    ... This posting is provided "AS IS" with no warranties, and confers no rights. ... >>> I am searching for some white paper or some other document on ...
    (microsoft.public.win2000.security)
  • Re: Win2k and SQL2k security
    ... You'd probably get a better answer in the SQL newsgroups. ... > Does anyone know a url to a white paper that explains what ... > operating system and Active Script jobs not belonging to ... > rights in order to run these types of jobs. ...
    (microsoft.public.win2000.security)
  • Win2k and SQL2k security
    ... Does anyone know a url to a white paper that explains what ... rights the Sql Server Agent needs in order to create ... operating system and Active Script jobs not belonging to ... rights in order to run these types of jobs. ...
    (microsoft.public.win2000.security)
  • Re: Could not Bulk insert beacuse file could not be opened
    ... Does the SQL Server agent account have ... rights to access this file? ... "MMSqlserver" wrote in message ...
    (microsoft.public.sqlserver.fulltext)
  • Snapshot Agent account rights
    ... Using SQL Server Agent as the Snapshot Agent account is not a recommended ... If a domain account is used, what rights and ... permissions should it be granted? ...
    (microsoft.public.sqlserver.replication)