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: ?? unable to access SQL Server w/ sa account unless user is Administrator on local machine
    ... Check to see what kind of authentication your SQL Server is set to. ... Windows only, and if your account belongs to the local admins group, the sa ... Then when the account is removed from the local admins group, ... We've encountered a wierd security problem with our app and SQL ...
    (microsoft.public.sqlserver.security)