RE: Change ownership of model and msdb to 'sa'
From: pk (pk_at_discussions.microsoft.com)
Date: 02/23/05
- Next message: Jonathan S: "RE: SQL Agent won't start"
- Previous message: Kyky: "retrieving an instance name"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 23 Feb 2005 03:39:04 -0800
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!!
> >
> >.
> >
>
- Next message: Jonathan S: "RE: SQL Agent won't start"
- Previous message: Kyky: "retrieving an instance name"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
