Re: Error 21776 - dbo account

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 11/10/03


Date: Mon, 10 Nov 2003 12:55:13 -0700

Maybe some of the other databases where you didn't change
the owner are mapped to a login that does not exist on the
server? Try using sp_changedbowner on all databases and
change the owner to sa.

-Sue

On 10 Nov 2003 10:22:30 -0800, erhunter@comscore.com (Edward
Hunter) wrote:

>I moved some database around and am now getting an error claiming
>there is no dbo name in the users collection. Several databases had
>no db-owner specified so i pointed them to sa account using
>sp_changeddbowner.
>
>Same thing, problem remains.
>
>Any ideas on how to fix?
>
>--Edward Hunter



Relevant Pages

  • Re: Remove/Add BUILTINAdministrators 2000 sp4
    ... I have seen a windows group referred to as a LOGIN for sql server in the ... the databases, and so it makes it dbo on all databases again. ...
    (microsoft.public.sqlserver.security)
  • Re: Remove/Add BUILTINAdministrators 2000 sp4
    ... detected that this login has permissions....etc this login ... be mapped to dbo. ... sysusers in the user databases and syslogins in master. ... I have seen a windows group referred to as a LOGIN for sql server in the ...
    (microsoft.public.sqlserver.security)
  • Re: Remove/Add BUILTINAdministrators 2000 sp4
    ... any of the databases. ... exist anywhere in sql server either. ... detected that this login has permissions....etc this login ... be mapped to dbo. ...
    (microsoft.public.sqlserver.security)
  • Logins
    ... We have a SQL Server login which is used by two applications, ... separate databases on the server. ... information for the databases for which the login has been added as a user. ...
    (microsoft.public.sqlserver.security)
  • Re: Remove/Add BUILTINAdministrators 2000 sp4
    ... Server, it some how knows that on this server, it use to be the dbo in all ... the databases, and so it makes it dbo on all databases again. ... via this LOGIN ...
    (microsoft.public.sqlserver.security)