Cannot change the database owner

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rich - 24 Oct 2005 21:11 GMT

Hello Group,

I have restored a database to a server and want to change the owner from me
to the SA. I have tried to use " Exec sp_changedbowner 'sa' " but get this
error:

Server: Msg 15110, Level 16, State 1, Procedure sp_changedbowner, Line 46
The proposed new database owner is already a user in the database.

I have done this at least hundred times without a problem, what is this
error saying about the USER? I am trying to chang the owner...

Rich

Reply to this Message

Geoff N. Hiten - 24 Oct 2005 21:32 GMT

SA is already mapped to a user in the database. Delete that user and retry
the command.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

> Hello Group,
>
[quoted text clipped - 11 lines]
>
> Rich

Reply to this Message

Dan Guzman - 25 Oct 2005 01:07 GMT

To add to Geoff's response, you might also get the error if the current
database owner is not linked correctly. In that case, you can work around
the problem by changing the database owner to another login and then to
'sa':

USE MyDatabase
EXEC sp_addlogin 'TempOwner'
EXEC sp_changedbowner 'TempOwner'
EXEC sp_changedbowner 'sa'
EXEC sp_droplogin 'TempOwner'

Signature

Hope this helps.

Dan Guzman
SQL Server MVP

> Hello Group,
>
[quoted text clipped - 11 lines]
>
> Rich

Reply to this Message