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

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

Date: Thu, 24 Feb 2005 16:58:51 -0500

You need full administrator rights to install SQL server. I assume you
could create a group with the same rights as the administrators group but
called something else, but what would be the point? There are just too many

You can run the services under a restricted login, but you may lose
features. 

-- 
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: xcopy deployment to sql server DTS package in restricted environme
    ... Because you're not in the Administrators group you don't have sufficient rights. ... In this case you need to grant rights to the group to which you belong that are sufficient to make the changes. ... Hitchhiker's Guide to Visual Studio and SQL Server ... I'm an old VB6 programmer who would like to distribute an .exe with the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: security
    ... You can't restrict the OS administrators or users in Administrators group ... System Admin" role from BUILTIN/ADMINISTRATORS account from sql server. ...
    (microsoft.public.sqlserver.msde)
  • Re: OUAdmin
    ... If they are only delegated the rights on the OU, without making any kind of admin or adding them to the administrators group, think not. ...
    (microsoft.public.windows.server.security)
  • Re: Windows2000 Domain - Security on Local Machine.
    ... has to be able to install software and patches (anti-virus ... > I've tried re-assigning rights to the Users group. ... > assigned every right that the Administrators group has to the Users ...
    (microsoft.public.win2000.security)
  • Re: Remote Desktop Users and Least User Rights
    ... user accounts (no administrative rights on the local machine). ... have many users that are setup so that they can access their ... from the Administrators group, the list of authorized remote users ... Remote tab> Select Remote Users) gets wiped out. ...
    (microsoft.public.windowsxp.security_admin)