restricting domain administrator access

From: Dan D. (DanD_at_discussions.microsoft.com)
Date: 01/05/05 

Date: Wed, 5 Jan 2005 09:01:09 -0800

Is there any downside to removing the domain adminstrator group from access
to SQL Server 2000?

Thanks, 

-- 
Dan D.

Relevant Pages

  • Re: System Administrator Implied Permissions
    ... >> Hi Dan, ... >> Now, given this, why does SQL Server ... However, these logins were not ... Other sysadmin role members have the ...
    (microsoft.public.sqlserver.security)
  • Re: System Administrator Implied Permissions
    ... member of the dbo group and you are automatically given ... Now, given this, why does SQL Server ... Much Thanks Dan. ...
    (microsoft.public.sqlserver.security)
  • Re: moving data in a database to another file on a SAN
    ... Moving SQL Server Databases ... > Issues When a Database Is Moved Between SQL Servers ... > "Dan D." ...
    (microsoft.public.sqlserver.server)
  • Re: database owner
    ... Thanks for all your help Dan, ... it can access the SQL Server as a sysadmin role member by default. ... And I don't have to make an own login for the backupexec account on the database, as long as it is a member of the dedicated admins group I made on the database that are a part of the system administrator role? ... I do not have a dedicated login for this user on the server, but this account is member of a administrators group in the sql server and this group is dedicated at dbo on all databases and belongs to the sysadmin servers role. ...
    (microsoft.public.sqlserver.security)
  • Re: VFP 9/SQL Server Integration Question
    ... What Dan said is all true. ... > file entry on Remote Views. ... I have several VFP 6 applications which I want to keep in FoxPro ... >> but I want to move the databases to SQL Server. ...
    (microsoft.public.fox.helpwanted)