Server Administrator and SQL Server

From: Steve Whaley (swhaley_at_growmark.com)
Date: 04/25/03 

Date: Fri, 25 Apr 2003 06:31:15 -0700

Is it possible to prevent the Windows 2000 Administrator
on the SQL Server machine from accessing a SQL Server 2000
database? If so, how would this be done?

Relevant Pages

  • Re: SharePoint Portal search is not working after changing admin paasw
    ... Just a thought but it could be the access account to the actual SQL server. ... Query on SQL and see if it lets you in as the Administrator. ... > Verified Password for services on our Database Server ...
    (microsoft.public.sharepoint.portalserver)
  • Re: SQL Server Express
    ... These are true if the Windows user is an administrator for any database - ... GRANT CREATE DATABASE on DATABASE::xxx to SAM ... figured out the SCHEMA topics in SQL Server 2005). ...
    (microsoft.public.sqlserver.msde)
  • Re: Fresh installation and no access
    ... You're not getting access because you're not an administrator when you log ... In previous OS's you had administrator permissions on the database ... You must create a login (to allow connect to SQL Server) then a user to be ...
    (microsoft.public.sqlserver.security)
  • Re: Cause SQL Server Restricted Mode (db_owner, dbcreator,)
    ... The only thing that can do that is an administrator. ... But, if it is an existing database, ... Lumigent Technologies and point it at your tran log + tran log backups. ... SQL Server MVP ...
    (microsoft.public.sqlserver.clustering)
  • Re: Permission question - another one
    ... I would have thought that Administrator ... Are you asking why is it connecting to SQL Server? ... > and I gave BUILTIN/Administrator this database as its default database. ...
    (microsoft.public.sqlserver.programming)