Tuesday, February 14, 2012

Change ownership of model and msdb to 'sa'

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
>
> database to change
> account
> msdb to 'sa' if in
>

No comments:

Post a Comment