Re: Starting Service with SQL Authentication

From: Neil W. (neilw.nospam_at_netlib.com)
Date: 07/26/03 

Date: Fri, 25 Jul 2003 19:21:20 -0400

Then in this case the SQL Agent startup account would need Admin rights? Is
there anyway around that? I.e., are there any lesser rights that would
suffice?

Thanks for the feedback.

----------------------------------------

"Kevin" <ReplyTo@Newsgroups.only
> wrote in message > Strictly speaking, no - except in the case of the
startup account of
> sqlagent or if you want to use extended stored procedures or anything else
> in process that talks back to sql (like xp_sqlmaint for example)
>
> --
> ----------------------------------------------------
> The views expressed here are my own
> and not of my employer.
> ----------------------------------------------------
> "Neil W." <neilw.nospam@netlib.com> wrote in message
> news:#XscovtUDHA.1952@TK2MSFTNGP11.phx.gbl...
> > I guess I should know this, but ... Using SQL 2000 lets say I allow
only
> > SQL Authentication and delete all builtin/administrators. I also change
> the
> > SA password to something only a couple of people know. Then I modify
the
> > service so that it is started by a normal domain user (doesn't have the
SA
> > password). Does that domain user need to have SQL admin rights in order
> to
> > start the service? If not, what SQL rights, if any, does he need.
> >
> > Thanks!
> >
> >
>
>

Relevant Pages

  • Re: Reinstall of SMS 2003 has no Status Messages
    ... The user running SMS setup has admin rights to SQL as well correct? ... > account does not have Administrator's privileges on the SQL Server. ...
    (microsoft.public.sms.setup)
  • Re: builtin/administrators
    ... Setting up Windows Services Accounts ... MSSQLServer service or the SQLServerAgent service, or both, to the SQL ... Server system administrators role. ... > local admin rights, some even have domain admin rights. ...
    (microsoft.public.sqlserver.server)
  • Re: Lost SA Password SQL 6.5
    ... > password and no other login has admin rights? ... As I recall, in SQL Server 6.5, anyone that registered a user (or SA ... account) for SQL Server for the Enterprise Manager console, ... information was stored in plain text in the registry. ...
    (microsoft.public.sqlserver.security)
  • RE: .Net interface to vss for sql 2000 stored procedures
    ... SQL services has to run with "sa" authority and Admin rights on the ... server, therefore, it automatically gives everyone "sa" rights to SQL. ...
    (microsoft.public.sqlserver.security)
  • Re: Starting Service with SQL Authentication
    ... At first glance, I'd say NO, agent would require sysadmin by design - but, ... On the other hand - personally, it's not a problem to work without sql ... > Then in this case the SQL Agent startup account would need Admin rights? ...
    (microsoft.public.sqlserver.security)