Re: Remove NT Admin from SQL SysAdmin Role
From: BP Margolin (bpmargo@attglobal.net)
Date: 08/31/02
- Next message: Bill: "I couldn't change authentication to mixed mode. Why?"
- Previous message: BP Margolin: "Re: User permissions for view"
- In reply to: Paul: "Remove NT Admin from SQL SysAdmin Role"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
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
- Next message: Bill: "I couldn't change authentication to mixed mode. Why?"
- Previous message: BP Margolin: "Re: User permissions for view"
- In reply to: Paul: "Remove NT Admin from SQL SysAdmin Role"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|