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:
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