Changing the Database Owner

From: Billy (billyn_at_backroads.net)
Date: 12/01/03 

Date: Mon, 1 Dec 2003 10:00:12 -0800

I had to move a database to a new server and used
the .bak file and did a restore from it on the
destination server. I have tried using sp_changedbowner
to change the owner to sa, which is what I want but get
the error that "..The proposed new database owner is
already a user in the database." How can I fix this? I
have also tried creating a new login and changing the
owner the new login and changing it back , and still get
the same error. Anyone have any ideas?

Thanks,

Billy

Relevant Pages

  • 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)
  • 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)
  • Re: dbo with user name in "users"
    ... be that one of them owned the database and because the login/user has been ... has something to do with not being able to validate the login. ... changing the owner to sa is usually a great ... for dbo, I get an error: "cannot insert the value NULL into column '', ...
    (microsoft.public.sqlserver.security)
  • Re: properties owner and users owner.
    ... 'dbo' is a special database user and must exist in every database. ... normally be the same login but can get out-of-sync in some situations, ... owner entries are synchronized: ...
    (microsoft.public.sqlserver.server)