Change ownership of model and msdb to 'sa'

From: Rob (rhchin_at_hotmail.com)
Date: 01/06/05 

Date: Thu, 6 Jan 2005 09:42:15 -0800

>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!!
>
>.
>

Relevant Pages

  • Re: Execute permission denied on object xp_SQLagent_notify
    ... it was probably then when the owner changed. ... USE msdb ... EXECUTE permission denied on object 'xp_sqlagent_is_starting', database ... The puzzling part here is that I got the errors on 2 servers out of the 10 ...
    (microsoft.public.sqlserver.security)
  • RE: Change ownership of model and msdb to sa
    ... My Production's SQL2k MSDB & Model ... database owner is my old NT Domain Administrator. ... Master owner is SA. ... "Rob" wrote: ...
    (microsoft.public.sqlserver.server)
  • Re: sql server edition upgrade questions
    ... Like Aaron said, don't upgrade, backup all your database, including ... SQL starts), Northwind and pubs. ... Once you reinstall SQL, put it into single user mode and restore master, ... msdb and model, then your database, restart SQL. ...
    (microsoft.public.sqlserver.server)
  • Re: Change UDF Owner
    ... and are all in the master database. ... objects not owned by the database owner. ... The following objects are not owned by the database owner: ... Users can be put in the dbo role, but dbo will still own objects ...
    (microsoft.public.sqlserver.security)
  • Re: Cannot change login associated with DBO for MasterDB.
    ... sp_changedbowner changes the owner of the database from one ... The way to disable the sa login is to go to NT ... > I have a sql2000 server with Master db owned by DBO, ...
    (microsoft.public.sqlserver.server)