Change ownership of model and msdb to 'sa'

We are trying to exec sp_changedbowner 'sa' on model database to change
ownership from the service account 'service_sql' to 'sa' account
However, we got the follow error:
15109 16 Cannot change the owner of the master database.
Is there any know how to Change ownership of model and msdb to 'sa' if in
case 'sa' is not owner of msdb and model?
Thanks!!From BOL:
The owner of the master, model, or tempdb system databases
cannot be changed.
- Rob
>--Original Message--
>We are trying to exec sp_changedbowner 'sa' on model
database to change
>ownership from the service account 'service_sql' to 'sa'
account
>However, we got the follow error:
>15109 16 Cannot change the owner of the master database.
>Is there any know how to Change ownership of model and
msdb to 'sa' if in
>case 'sa' is not owner of msdb and model?
>Thanks!!
>.
>|||I am facing the same problem as Maggie. My Production's SQL2k MSDB & Model
database owner is my old NT Domain Administrator (olddomain/administrator).
Not sure how it ended that way. Master owner is SA.
We have completed domain migration to Active Directory, if sp_changedbowner
is not going to allow me to change DB owner for MSDB & Model, does that mean
I still got to keep my old domain forever ?
There must be a work-around for this.
"Rob" wrote:
> From BOL:
> The owner of the master, model, or tempdb system databases
> cannot be changed.
> - Rob
> >--Original Message--
> >We are trying to exec sp_changedbowner 'sa' on model
> database to change
> >ownership from the service account 'service_sql' to 'sa'
> account
> >However, we got the follow error:
> >15109 16 Cannot change the owner of the master database.
> >Is there any know how to Change ownership of model and
> msdb to 'sa' if in
> >case 'sa' is not owner of msdb and model?
> >
> >Thanks!!
> >
> >.
> >
>