Re: What are the necessary rights to install SQL Server?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Geoff N. Hiten (SQLCraftsman_at_gmail.com)
Date: 02/24/05 

Date: Thu, 24 Feb 2005 17:05:05 -0500

Maybe I should complete a thought before hitting "SEND".

There are too many things that have to be set up during an installation for
the installation account to be anything less than a full administrator on
the box. Remember, this product was released long before most folks started
expecting a tightly secured environment. 

-- 
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Peter" <Peter@discussions.microsoft.com> wrote in message
news:157DB67E-0D6B-4F9A-917D-B3FF9B036BB1@microsoft.com...
> Thanks Geoff.  Let's say that if I don't want the user to have direct or
> indirect membership of the local Administrators group, can I setup another
> local group with the necessary user rights?  If yes, what are the
necessary
> user rights?
>
> "Geoff N. Hiten" wrote:
>
> > The statement means membership in the local administrators group, either
> > directly or through group inheritance (I.E. Domain Admins).
> >
> > -- 
> > Geoff N. Hiten
> > Microsoft SQL Server MVP
> > Senior Database Administrator
> > Careerbuilder.com
> >
> > I support the Professional Association for SQL Server
> > www.sqlpass.org
> >
> > "Peter" <Peter@discussions.microsoft.com> wrote in message
> > news:CCA7096C-0316-4179-81CE-C23CD51EA85D@microsoft.com...
> > > BOL has the following statement in the section Preparing to Install
SQL
> > > Server 2000:
> > >
> > > Log on to the operating system under a user account that has local
> > > administrative permissions, or assign the appropriate permissions to
the
> > > domain user account.
> > >
> > > What are the local administrative permissions needed or it simply
means
> > that
> > > the user must be a member of local Administrators group?
> > >
> > > Thanks.
> >
> >
> >

Relevant Pages

  • Re: What Account Should Server Be Running?
    ... When SQL Server is installed it is installed as a service. ... Q. What account do I choose as the startup account? ... SQL Server and SQL Server Agent are installed as Windows services. ... During installation, you can choose which user account will be the startup ...
    (microsoft.public.sqlserver.server)
  • Re: SQL2KE, SP3a cluster install
    ... it's service account, at least for the first service pack installation. ... A Cluster Upgrade to Service Pack 1 Does Not Succeed If SQL Server ... The service account that SQL> Server uses won't be local admin, ...
    (microsoft.public.sqlserver.setup)
  • Re: SYSTEM DOWN - URGENT HELP NEEDED!!!!!
    ... In any case not having a password for the sa account is REALY BAD ... >>and it depends on the sql server running on the server. ... >>installation screens, and for the login page, I did the ...
    (microsoft.public.sqlserver.server)
  • Re: User account for only SQL server
    ... But now he insisted to have Admininstrators Account so that he can log on to ... I did try adding his user account that includes Administrators permission to ... Add the new account to the local Administrators group on the SQL server ...
    (microsoft.public.windows.server.active_directory)
  • SYSTEM DOWN - URGENT HELP NEEDED!!!!!
    ... Also my SA account does not have a password, ... >and it depends on the sql server running on the server. ... >installation screens, and for the login page, I did the ...
    (microsoft.public.sqlserver.server)