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

Question

Post reply

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

klnsuddu

SSCertifiable

Points: 5836
More actions
February 23, 2010 at 2:45 pm

#143125

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

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

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

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 1

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

klnsuddu SSCertifiable Points: 5836 More actions · Answer 2

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

klnsuddu SSCertifiable Points: 5836 More actions · Answer 3

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

george sibbald SSC Guru Points: 104210 More actions · Answer 4

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

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