SQL Server 2000: Revoking dbo from Builtin\Administrators

From: Jim Sims (jim.m.sims_at_exxonmobil.com)
Date: 09/18/03 

Date: Wed, 17 Sep 2003 15:01:57 -0700

I normally revoke all privileges from
Builtin\Administrators as part of my SQL Server 2000
install process. I have recently found 2 servers where
this step had been overlooked. Now,
Builtin\Administrators has dbo privileges on all databases
on the server. When I try to remove the "Permit" check
mark, I am advised, "The database owner cannot be
dropped." When I try to revoke dbo privileges, I
get "Error 15405: Cannot use teh reserved user or role
name 'dbo'.

I have run
sp_change_users_login 'auto_fix','Builtin\Administrators'.
 I have changed the owner of all the objects to my ID. I
have tried to change the object owner to "SA". I have
tried to change the owner of the database to "SA".

All attempts fail. Anybody got any ideas?

Relevant Pages

  • Re: Replication failure
    ... Connecting to directory service on server arnelfs1. ... ARNELDC1 is the Schema Owner, but is not responding to DS ... prevented from starting by the File Replication Service. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Unable to local DC ......... URGENT
    ... So please give some infos about server names, which is the old, which is the running and which is the new one. ... Verifying that the local machine NODE2, ... Role Schema Owner = CN="NTDS Settings ...
    (microsoft.public.win2000.active_directory)
  • RE: Domain membership test: Failed
    ... Testing server: Default-First-Site\ALRANGE1 ... is the Schema Owner, but is deleted. ... "Meinolf Weber" wrote: ... There is ALRANGE domain with two W2K servers, Alrange1 and Alrange2, ...
    (microsoft.public.win2000.active_directory)
  • Re: Spam:RE: application for an employment
    ... I fully agree that having a poorly protected web server puts you in a false ... The rights are those of the property owner. ... Tailor your education to your own professional goals with degree ... confirmed by letter or fax signed by a Partner of BDO. ...
    (Security-Basics)
  • RE: Spam:RE: application for an employment
    ... The rights are those of the property owner. ... owner - i.e. the owner of the web server has rights. ... Tailor your education to your own professional goals with degree ... confirmed by letter or fax signed by a Partner of BDO. ...
    (Security-Basics)