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

ID: 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 : kbprg kbtool SSrvSQL_Admin kbbug4.20 SSrvWinNT
Version : 4.2 4.2b 4.21
Platform : WINDOWS
Issue type :