Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Error 21776

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-09-17 : 22:19:42
Mike writes "I am restoring a database to a hot standby server from a production server. When I add one particular user to the database, which has a login on both servers, I get an error message that states, "Error 21776: [SQL-DMO]The name 'username' 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 have read info on the sp_changedbowener stored procedure as it relates to this error, but this does not appear to be my problem because 'username' is not the dbo on either server's database. Also I have recreated the login for 'username' with the same SID on both servers to try to prevent orphaning. Why would I get this error and what can I do to solve it?"
   

- Advertisement -