Re: minimum OS user level to operate SQL Server

From: Steve Thompson (SteveThompson_at_nomail.please)
Date: 11/21/03 

Date: Fri, 21 Nov 2003 13:58:10 -0500

"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

Relevant Pages

  • Asp.net Important Topics.
    ... ASP.NET server controls contained within the page. ... A custom server control is ... can also perform validation using client script. ... Where does the Web page belong in the .NET Framework class hierarchy? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Entwicklung von Unix-Anwendung mit C++ (m/w)/ NRW : Ref.-Nr.: 37302/1
    ... I am responsible for design and implementation of the persistent data server working with mySQL. ... Developed within very short time the product was successfully installed ... Reengineering and implementing a display tool for Experimental Physics Industrial Control System ... Developed an operator interface under X Window for High Energy Physics Accelerator Control System. ...
    (de.markt.arbeit.d)
  • Re: Compromise?
    ... Yes, if you don't provide a password on your SA account, anybody able to run ... and connect now has complete control over your SQL Server. ... Server has. ...
    (microsoft.public.sqlserver.security)
  • Software engineer
    ... I have a BS in Electrical Engineering and computer science and worked on my ... I have also been involved in hardware design. ... Developed an ATL DCOM based Server and MFC client GUI using Visual C++6.0. ... User can control the data acquisition parameters by modifying the script file. ...
    (FreeBSD-Security)
  • WWWOFFLE - Web proxy with features for dial-up users
    ... The WWWOFFLE programs simplify World Wide Web browsing from computers that use ... The WWWOFFLE server is a proxy web server with special features for use with ... Interactive or command line control of online/offline/autodial status. ... Requests compressed pages from web servers (compile time option). ...
    (comp.os.linux.announce)