Error changing SA password

I'm getting the following error when trying to change the
SA password for SQL Server2000 (SP3).
"Error 21776:[SQL_DMO]The name 'dbo' was not found in the
Users collection. If the name is a qualified name, use []
to separate various parts of the name, and try again"
I can't seem to connect under the old or the new
password. Any help would be appreciated.
Thanks
RonAre you a domain admin..? If so connect to SQL via Query Analyser using
Windows Authentication. Then issue the following :-
Examples
A. Change the password of a login without the former password
This example changes the password for the login Victoria to ok.
EXEC sp_password NULL, 'ok', 'Victoria'
--
HTH
Ryan Waight, MCDBA, MCSE
"Ron" <rgowdy@.phcs.com> wrote in message
news:18c201c38695$637b2610$a001280a@.phx.gbl...
> I'm getting the following error when trying to change the
> SA password for SQL Server2000 (SP3).
> "Error 21776:[SQL_DMO]The name 'dbo' was not found in the
> Users collection. If the name is a qualified name, use []
> to separate various parts of the name, and try again"
> I can't seem to connect under the old or the new
> password. Any help would be appreciated.
> Thanks
> Ron|||Just to add to Ryan's reply, you can change the password
with Query Analyzer but you will still have the issue of a
dbo being mapped to a non-existant login - that's what
causes the error. You should still update your databases
using sp_changedbowner so that they are owned by logins that
exist on the server.
-Sue
On Mon, 29 Sep 2003 07:24:27 -0700, "Ron" <rgowdy@.phcs.com>
wrote:
>I'm getting the following error when trying to change the
>SA password for SQL Server2000 (SP3).
>"Error 21776:[SQL_DMO]The name 'dbo' was not found in the
>Users collection. If the name is a qualified name, use []
>to separate various parts of the name, and try again"
>I can't seem to connect under the old or the new
>password. Any help would be appreciated.
>Thanks
>Ron|||I believe Sue is on the money here. See the link below
http://www.google.com/groups?selm=utApDPZeDHA.2080%40TK2MSFTNGP12.phx.gbl&oe=UTF-8&output=gplain
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Ron" <rgowdy@.phcs.com> wrote in message
news:18c201c38695$637b2610$a001280a@.phx.gbl...
> I'm getting the following error when trying to change the
> SA password for SQL Server2000 (SP3).
> "Error 21776:[SQL_DMO]The name 'dbo' was not found in the
> Users collection. If the name is a qualified name, use []
> to separate various parts of the name, and try again"
> I can't seem to connect under the old or the new
> password. Any help would be appreciated.
> Thanks
> Ron