Owner of DB missing login name

SQL 2K on W2K Server...

ok. created 'user1'. made him a sys admin. created DB#1 with his credentials--he is the owner. everyone uses his credentials to create their odbc's--no problem. within EM, under db user properties for DB#1, it shows he is the owner and that his user name is 'user1' and his login name is 'dbo'.

for some reason today, the login name for this user within DB#1's db properties says <None>, as opposed to dbo. and though this same panel (Database User poperties - User1) shows that he is the owner of the db, checking 'Security-->Logins-->SQL Server Login Properties-->Database Access tab doesn't even have a checkbox under the 'Permit' column. and, when i check the Permit box, and check 'db_owner' in the 'Permit in Database role' window, i receive an error that Error 21002: [SQL-DMO]User 'User1' already exists.

well, i should hope so! but why has his ownership been taken away? why can't i re-add it? all pointers on the net for this error talk about issues with moving or restoring db's--neither of which was done in this case.

help ?need to bump this one up--sry

Originally posted by tojolo
SQL 2K on W2K Server...

ok. created 'user1'. made him a sys admin. created DB#1 with his credentials--he is the owner. everyone uses his credentials to create their odbc's--no problem. within EM, under db user properties for DB#1, it shows he is the owner and that his user name is 'user1' and his login name is 'dbo'.

for some reason today, the login name for this user within DB#1's db properties says <None>, as opposed to dbo. and though this same panel (Database User poperties - User1) shows that he is the owner of the db, checking 'Security-->Logins-->SQL Server Login Properties-->Database Access tab doesn't even have a checkbox under the 'Permit' column. and, when i check the Permit box, and check 'db_owner' in the 'Permit in Database role' window, i receive an error that Error 21002: [SQL-DMO]User 'User1' already exists.

well, i should hope so! but why has his ownership been taken away? why can't i re-add it? all pointers on the net for this error talk about issues with moving or restoring db's--neither of which was done in this case.

help ?