Article ID: 305711 - View products that this article applies to.
This article was previously published under Q305711
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:
This problem only occurs after you apply SQL Server 2000 Service Pack 1 (SP1) to the server. Prior to Service Pack 1, the dbo user displays with a blank Login Name.
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.
Enterprise Manager is incorrectly filtering out all the users that do not have matching logins, and the dbo user does not have a matching login. Two possible reasons for this behavior to occur are:
If the dbo user does not have an explicit login, change the owner of the database to a user that has an explicit login. For example, change the owner of the database to the system administrator (sa), and then execute the following code:
Microsoft has confirmed this to be a problem in SQL Server 2000 Service Pack 1 (SP1).
To determine if the dbo user is unmatched in a user database, execute the following query:
REFERENCESFor more information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/218172/ )PRB: Cannot change SA password in Enterprise Manager
(http://support.microsoft.com/kb/274188/ )PRB: "Troubleshooting Orphaned Users" topic in Books Online is incomplete
(http://support.microsoft.com/kb/168001/ )PRB: User logon and/or permission errors after restoring dump
(http://support.microsoft.com/kb/246133/ )How to transfer logins and passwords between instances of SQL Server
(http://support.microsoft.com/kb/298758/ )PRB: Using the Auto_Fix option with sp_change_users_login can leave security vulnerabilities
Article ID: 305711 - Last Review: June 6, 2005 - Revision: 5.2
Contact us for more help