SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
klnsuddu
klnsuddu
Mr or Mrs. 500
Mr or Mrs. 500 (574 reputation)Mr or Mrs. 500 (574 reputation)Mr or Mrs. 500 (574 reputation)Mr or Mrs. 500 (574 reputation)Mr or Mrs. 500 (574 reputation)Mr or Mrs. 500 (574 reputation)Mr or Mrs. 500 (574 reputation)Mr or Mrs. 500 (574 reputation)

Group: General Forum Members
Points: 574 Visits: 757
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
MANU-J.
MANU-J.
SSCrazy
SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)SSCrazy (3K reputation)

Group: General Forum Members
Points: 2954 Visits: 8766
Drop the user named 'abc\btsdadmin' from this database first and then add it again by using sp_changedbowner command.
klnsuddu
klnsuddu
Mr or Mrs. 500
Mr or Mrs. 500 (574 reputation)Mr or Mrs. 500 (574 reputation)Mr or Mrs. 500 (574 reputation)Mr or Mrs. 500 (574 reputation)Mr or Mrs. 500 (574 reputation)Mr or Mrs. 500 (574 reputation)Mr or Mrs. 500 (574 reputation)Mr or Mrs. 500 (574 reputation)

Group: General Forum Members
Points: 574 Visits: 757
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
Attachments
BizTalk_Owner.docx (58 views, 26.00 KB)
klnsuddu
klnsuddu
Mr or Mrs. 500
Mr or Mrs. 500 (574 reputation)Mr or Mrs. 500 (574 reputation)Mr or Mrs. 500 (574 reputation)Mr or Mrs. 500 (574 reputation)Mr or Mrs. 500 (574 reputation)Mr or Mrs. 500 (574 reputation)Mr or Mrs. 500 (574 reputation)Mr or Mrs. 500 (574 reputation)

Group: General Forum Members
Points: 574 Visits: 757
I just need to drop the user and change the owner and map the database roles again right?
george sibbald
george sibbald
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10382 Visits: 13687
if you make abc\btsadmin the owner of the database it will have all other rights by default.

---------------------------------------------------------------------
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search