Re: Remove NT Admin from SQL SysAdmin Role

From: BP Margolin (bpmargo@attglobal.net)
Date: 08/31/02


From: "BP Margolin" <bpmargo@attglobal.net>
Date: Fri, 30 Aug 2002 20:57:22 -0400


Paul,

http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q263712

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"Paul" <pbill@turkeyhill.com> wrote in message
news:a66801c2505e$365a7140$3aef2ecf@TKMSFTNGXA09...
> Hi,
>
> I know that SQL Server 2000 automatically makes NT Admins -
> SQL Server Sys Admins. I do not want for this to be the
> case. How do I remove the NT Admins and mebers of its NT
> group from being a SQL Server Sys Admin? Thanks



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)
  • Re: users require SQL admin but not server admin ?
    ... server role in SQL Server, without making them a part of local admins group ... on the box, or domain admins. ... Vyas, MVP (SQL Server) ...
    (microsoft.public.sqlserver.server)
  • 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)