BUG: Error 21770 Adding Login in SEM and User with SP_ADDUSERID: Q223999
|
After you grant database access through sp_adduser to a login that was created using Enterprise Manager, the following error message (Error 21770) occurs when you edit the login in Enterprise Manager:
If you delete the user from the database and then try to drop the login, the following error message might appear (Error 15175):The name <username> was not found in the Users collection.
<SQL Server> Login 'user' is aliased or mapped to a user in one or more database(s). Drop user or alias before dropping login.
To work around this problem, do one of the following:
Microsoft has confirmed this to be a problem in SQL Server version 6.5.
sp_adduser user1, user1
SQL Server returns the following message: "New user added."You might also experience this error when you try to edit permissions for the user.Error 21770: The name 'user1' was not found in the Users collection.
Additional query words:
Keywords : kberrmsg
Version : winnt:6.5
Platform : winnt
Issue type : kbbug
Last Reviewed: April 14, 1999