Microsoft KB Archive/124060

{|
 * width="100%"|

BUG: SQL Admin. Will Not Drop Logins w/ Single User Databases

 * }

Q124060

-

The information in this article applies to:


 * Microsoft SQL Server version 4.2x

-

BUG# 10198 (4.2)

SYMPTOMS
If a system has any databases in single user mode, logins cannot be dropped using the SQL Administrator systems logins window.

If a system has any databases in single user mode, any attempt to drop logins using the Manage/Drop Logins menu item in the SQL Administrator system logins window receives a series of three 924 errors:

Database 'X' is already open and can have only one user at a time.

This happens even if the login is not associated with any user id's in the single user database, and even if no other users are connected to the server.

WORKAROUND
Drop the login from the query window using sp_droplogin.

STATUS
Microsoft has confirmed this to be a problem in SQL Administrator version 4.2 for Windows and Windows NT. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Additional query words: Windows NT

Keywords : kbprogramming kbtool

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ420OS2