Error 21776: after transferring databases
From: Mike Thomason (thomasom@tapemark.com)
Date: 12/09/02
- Next message: SQL Server Development Team [MSFT]: "Re: 'NT Authority/Anonimous Login'"
- Previous message: Hal Berenson: "Re: Most current service pack for SQL 6.5"
- Next in thread: Dan Guzman: "Re: Error 21776: after transferring databases"
- Reply: Dan Guzman: "Re: Error 21776: after transferring databases"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Mike Thomason" <thomasom@tapemark.com> Date: Mon, 9 Dec 2002 10:23:09 -0800
I transferred databases from SSSrvr to FRXSrvr.
The error 21776 is displayed when I try to change the 'SA'
password. I have the 'SA' password using sp_password.
I now want to link the 'DBO' in the databases to the login
DBO by correcting the SID. I have followed the suggested
workarounds in Microsoft help(see the copied message
below). The workarounds do not work for 'DBO'.
Can anyone help me?
Thank you.
Mike
_________________________________________________
BUG #: 355065 (SHILOH_BUGS)
SYMPTOMS
The database owner (dbo) user in a user database is not
listed in the Users folder in Enterprise Manager.
Additionally, when you view the properties of any login in
the Logins folder in Enterprise Manager, you may receive
the following error messages:
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.
- Next message: SQL Server Development Team [MSFT]: "Re: 'NT Authority/Anonimous Login'"
- Previous message: Hal Berenson: "Re: Most current service pack for SQL 6.5"
- Next in thread: Dan Guzman: "Re: Error 21776: after transferring databases"
- Reply: Dan Guzman: "Re: Error 21776: after transferring databases"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
