The proposed new database owner is already a user or aliased in the database

  • Hi,

    We have BizTalk databases on SQL Server 2005 EE x64 with SP3. For security reason, we have changed the BizTalk databases owner to SA from abc\btsdadmin. But from BizTalk best practices, we came to know that we should NOT change the database owner from BTSAdmin. So I want to change the owner back to abc\BTSAdmin. I'm executing the below query:

    Use BizTalkMsgBoxDb

    GO

    Exec sp_changedbowner 'abc\btsdadmin'

    But I'm getting the below error:

    Msg 15110, Level 16, State 1, Line 1

    The proposed new database owner is already a user or aliased in the database.

    Please advice me on how can I change the database owner form SA to abc\btsdadmin

  • Drop the user named 'abc\btsdadmin' from this database first and then add it again by using sp_changedbowner command.

  • thanks Manu,

    But after changing the owner to abc\btsadmin, I want to have the below database roles (these roles already exist now, with database owner SA and I want to keep them as it is after changing the owner to abc\btsadmin)

    db_accessadmin

    db_ddladmin

    db_securityadmin

    public

    please see the attachment

  • I just need to drop the user and change the owner and map the database roles again right?

  • if you make abc\btsadmin the owner of the database it will have all other rights by default.

    ---------------------------------------------------------------------

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply