Tags: administrator, boaadmin, database, dbo, dbowner, local, microsoft, mysql, oracle, owner, renamed, server, sql

Change dbowner on database

On Database » Microsoft SQL Server

8,055 words with 3 Comments; publish: Mon, 02 Jun 2008 01:02:00 GMT; (250109.38, « »)

We recently renamed the local administrator account on our server from

administrator to boaadmin. And now we need to change dbo owner for a

database becauase the dbase is still using the name administrator for

the dbo.

I ran the process :

sp_changedbowner boaadmin

but it gives the following error. Am I doing something wrong, since I'm

a bit new to SQL...

Server: Msg 15007, Level 16, State 1, Procedure sp_changedbowner, Line

33 The login 'boaaladmin' does not exist.

When I ran the process in Query Analyzer I'm using the id boaadmin to

login...

I finally managed to execute the command without errors I had to add

the machine domain in front of the it servername\boaadmin.

After executing the command it returned "aliases were mapped to the new

database owner. database owner changed".

But when I look inside the dbase user's the dbo doesn't have a login

name associated with it. Previously it was servername\administrator and

now its just blank.

I've ran the sp_changedbowner twice and it still doesn't allocate the

id servername\boaadmin to dbo.

I even tried recreating the database using boaadmin, but find that the

dbowner is still the servername\administrator account.

Can'tr figure out why....

All Comments

Leave a comment...

  • 3 Comments
    • Hi

      If you renamed the account then the SID has not changed, the probably means

      that sysxlogins has not be changed. You may want to try calling sp_grantlogin

      for boaadmin and sp_revokelogin for administrator.

      What does sp_change_users_login 'report' give on the database?

      I also noticed that the error message for sp_changedbowner refers to

      'boaaladmin'

      John

      "Zeno" wrote:

      > We recently renamed the local administrator account on our server from

      > administrator to boaadmin. And now we need to change dbo owner for a

      > database becauase the dbase is still using the name administrator for

      > the dbo.

      >

      > I ran the process :

      > sp_changedbowner boaadmin

      >

      > but it gives the following error. Am I doing something wrong, since I'm

      > a bit new to SQL...

      >

      > Server: Msg 15007, Level 16, State 1, Procedure sp_changedbowner, Line

      > 33 The login 'boaaladmin' does not exist.

      >

      > When I ran the process in Query Analyzer I'm using the id boaadmin to

      > login...

      > I finally managed to execute the command without errors I had to add

      > the machine domain in front of the it servername\boaadmin.

      >

      > After executing the command it returned "aliases were mapped to the new

      > database owner. database owner changed".

      >

      > But when I look inside the dbase user's the dbo doesn't have a login

      > name associated with it. Previously it was servername\administrator and

      > now its just blank.

      >

      > I've ran the sp_changedbowner twice and it still doesn't allocate the

      > id servername\boaadmin to dbo.

      >

      > I even tried recreating the database using boaadmin, but find that the

      > dbowner is still the servername\administrator account.

      > Can'tr figure out why....

      >

      #1; Mon, 02 Jun 2008 01:03:00 GMT
    • Zeno,

      Does 'machinename\boaaladmin' have a login in SQL Server? Create the login

      and try again. I see no reason why it shouldn't work.

      --

      Mark Allison, SQL Server MVP

      http://www.markallison.co.uk

      Looking for a SQL Server replication book?

      http://www.nwsu.com/0974973602m.html

      "Zeno" wrote:

      > We recently renamed the local administrator account on our server from

      > administrator to boaadmin. And now we need to change dbo owner for a

      > database becauase the dbase is still using the name administrator for

      > the dbo.

      >

      > I ran the process :

      > sp_changedbowner boaadmin

      >

      > but it gives the following error. Am I doing something wrong, since I'm

      > a bit new to SQL...

      >

      > Server: Msg 15007, Level 16, State 1, Procedure sp_changedbowner, Line

      > 33 The login 'boaaladmin' does not exist.

      >

      > When I ran the process in Query Analyzer I'm using the id boaadmin to

      > login...

      > I finally managed to execute the command without errors I had to add

      > the machine domain in front of the it servername\boaadmin.

      >

      > After executing the command it returned "aliases were mapped to the new

      > database owner. database owner changed".

      >

      > But when I look inside the dbase user's the dbo doesn't have a login

      > name associated with it. Previously it was servername\administrator and

      > now its just blank.

      >

      > I've ran the sp_changedbowner twice and it still doesn't allocate the

      > id servername\boaadmin to dbo.

      >

      > I even tried recreating the database using boaadmin, but find that the

      > dbowner is still the servername\administrator account.

      > Can'tr figure out why....

      >

      #2; Mon, 02 Jun 2008 01:04:00 GMT
    • Zeno

      Is there a speciffic reason why you don't want your database and objects

      owned by SA. With any other owner you will find some utilities and commands

      will not run as you expect. I have in the past inherited databases not owned

      by sa and they can be a right pain.

      You need to limit access to sa, but generally your life will be much easier.

      Regards

      John

      "Mark Allison" wrote:

      > Zeno,

      > Does 'machinename\boaaladmin' have a login in SQL Server? Create the login

      > and try again. I see no reason why it shouldn't work.

      > --

      > Mark Allison, SQL Server MVP

      > http://www.markallison.co.uk

      > Looking for a SQL Server replication book?

      > http://www.nwsu.com/0974973602m.html

      >

      > "Zeno" wrote:

      > > We recently renamed the local administrator account on our server from

      > > administrator to boaadmin. And now we need to change dbo owner for a

      > > database becauase the dbase is still using the name administrator for

      > > the dbo.

      > >

      > >

      > > I ran the process :

      > > sp_changedbowner boaadmin

      > >

      > >

      > > but it gives the following error. Am I doing something wrong, since I'm

      > > a bit new to SQL...

      > >

      > >

      > > Server: Msg 15007, Level 16, State 1, Procedure sp_changedbowner, Line

      > > 33 The login 'boaaladmin' does not exist.

      > >

      > >

      > > When I ran the process in Query Analyzer I'm using the id boaadmin to

      > > login...

      > >

      > > I finally managed to execute the command without errors I had to add

      > > the machine domain in front of the it servername\boaadmin.

      > >

      > >

      > > After executing the command it returned "aliases were mapped to the new

      > > database owner. database owner changed".

      > >

      > >

      > > But when I look inside the dbase user's the dbo doesn't have a login

      > > name associated with it. Previously it was servername\administrator and

      > > now its just blank.

      > >

      > >

      > > I've ran the sp_changedbowner twice and it still doesn't allocate the

      > > id servername\boaadmin to dbo.

      > >

      > >

      > > I even tried recreating the database using boaadmin, but find that the

      > > dbowner is still the servername\administrator account.

      > >

      > > Can'tr figure out why....

      > >

      #3; Mon, 02 Jun 2008 01:05:00 GMT