cannot change mdb owner

Document ID : KB000101358
Last Modified Date : 13/06/2018
Show Technical Document Details
Issue:
cannot change mdb owner
We need to change to mdbadmin before to upgrade ServiceDesk
Environment:
SqlServer 2012
Cause:
An existing install has the mdb owned by admin, would like to change the owner to mdbadmin as the default install of ServiceDesk
Resolution:
Use Sql Studio Management

new query

use mdb;
EXEC dbo.sp_changedbowner mdbadmin


We recommend to have this done with your DBA;