Re: Cannot change login associated with DBO for MasterDB.

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 10/28/04 

Date: Thu, 28 Oct 2004 07:54:27 -0400

Additionally, sp_changedbowner changes the owner of the database from one
login to another, and the owner of master can not be changed.. This is why
you are getting the error... The way to disable the sa login is to go to NT
authenication ONLY ... Otherwise you can not disable it. 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"slycat" <slycat@consultant.com> wrote in message
news:dec83278.0410271324.1c200fa6@posting.google.com...
> I have a sql2000 server with Master db owned by DBO, login sa. All
> well and good but I need the login changed from sa to abc. Problem is
> each time i try to run
>
> sp_changedbowner 'abc' , it comes back with
>
> Server: Msg 15109, Level 16, State 1, Procedure sp_changedbowner, Line
> 22
> Cannot change the owner of the master database.
>
> I am not changing the owner of the database, just wanna change the
> login.
>
> Any ideas? THanks.

Relevant Pages

  • New Login Question
    ... I have been programming with Sql Server 2000 for 2-3 years ... I noticed that at the bottom of the New login dialog there ... One selects a database to log in to ... dropdown always has master listed. ...
    (microsoft.public.sqlserver.security)
  • Re: Accidentally dropped DBO from database
    ... That error is due to having databases where the owner (dbo) ... is mapped to a login that doesn't exist on the server. ... a user in the database" when using sp_changedbowner, ...
    (microsoft.public.sqlserver.security)
  • Re: Confused about dbo
    ... Make sure you understand the difference between login names and user names. ... database within a SQL Server instance. ... There are several ways you could have the username dbo. ... the true owner of the database. ...
    (microsoft.public.sqlserver.security)
  • New Login Question
    ... The database login ... >dropdown always has master listed. ... >what is the significance of the database dropdown on the ...
    (microsoft.public.sqlserver.security)
  • Re: not creating tables as dbo anymore ?
    ... Database Owner (dbo) ... existing user ID in the database specified by database_name. ... with the login of the current connection. ...
    (microsoft.public.sqlserver.security)