Re: minimum OS user level to operate SQL Server
From: djc (noone_at_nowhere.com)
Date: 11/21/03
- Next message: djc: "Re: minimum OS user level to operate SQL Server"
- Previous message: Jasper Smith: "Re: Connections errors"
- In reply to: Steve Thompson: "Re: minimum OS user level to operate SQL Server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 21 Nov 2003 14:09:27 -0500
Thanks!
"Steve Thompson" <SteveThompson@nomail.please> wrote in message
news:uUzWpFGsDHA.1760@TK2MSFTNGP10.phx.gbl...
> "djc" <noone@nowhere.com> wrote in message
> news:u9rrYCFsDHA.2508@TK2MSFTNGP10.phx.gbl...
> > I need to know what the minimum is for a user to have full control over
> > SQLServer2000 but nothing else in the OS.
> >
> > A while back I was in a rush to get someone access and had problems. I
> wound
> > up making the user account a member of the 'server operators' windows
> > built-in security group. I really don't want to keep it that way.
> >
> > 1) What windows permissions/privelages are needed at a minimum to have
> full
> > control of SQL Server.
>
> Here you need an account that allows the user to logon the server.
> Typically, in a domain configuration, I'll add a user to the Users group
> which allows them to logon locally (after you've configutered the local
> policy options), however they cannot install/remove software or mess with
> most administrative options.
>
> > 2) What SQLServer permissions/privelages are needed at a minimum to have
> > full control of SQL Server.
>
> They need to have sysadmin equivalence. The best bet here, is create a
local
> group on the server that you add this user, add that local group into sql
> server and grant that group system administrators (sysadmin) permissions.
>
> Steve
>
>
>
>
- Next message: djc: "Re: minimum OS user level to operate SQL Server"
- Previous message: Jasper Smith: "Re: Connections errors"
- In reply to: Steve Thompson: "Re: minimum OS user level to operate SQL Server"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
