Re: users require SQL admin but not server admin ?

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 09/10/04


Date: Fri, 10 Sep 2004 11:42:13 +0100

Their login name or Windows account can be added to the sysadmins fixed
server role in SQL Server, without making them a part of local admins group
on the box, or domain admins.

-- 
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"scott" <nospamscott@yahoo.com> wrote in message
news:%239LRrEylEHA.2020@TK2MSFTNGP09.phx.gbl...
Hi,
I have SQL 2000 hosted on W2kserver.
What rights do users required to admin sql wihout giving them admin access
to the server ?
Thanks
Scott


Relevant Pages

  • Re: SQL Server Issues ::: ( how to avoid this issues )
    ... and I can sure *not* login to my SQL Server! ... > DAT files, it wont work unless u supply the exact parameters... ... > database security, the traderes will be really into deep truble... ... >>> You *cannot* keep your domain admins out of SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: Full text HELP!!!
    ... Looking for a book on SQL Server replication? ... When i populate it.. ... > admins need to be in the logins.. ... > builtin admin AND nt authority system and ...
    (microsoft.public.sqlserver.fulltext)
  • Full text HELP!!!
    ... 1- full text service is running under local system account ... 2- sql server is running under a domain account ... admins need to be in the logins.. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: SQL Server Issues ::: ( how to avoid this issues )
    ... most of the SQL Server mid-ranged clients are Trading companies... ... database security, the traderes will be really into deep truble... ... DAT files, it wont work unless u supply the exact parameters... ... >> admins, then consider encrypting it before it's put into the database, ...
    (microsoft.public.sqlserver.server)
  • Re: Minimum Permissions for sp_adduser
    ... But the OP is using SQL Server 2000 ... I suggested to him adding the user into securityadmin server role and try ... But still i am not able to execute sp_adduser using this new user. ... stored procedure will not add the rights to a non-dbo. ...
    (microsoft.public.sqlserver.security)