BUG: CURSOR_CLOSE_ON_COMMIT Stops SQL Enterprise Mgr. Logins (154889)

The information in this article applies to:

Microsoft SQL Server 6.5

This article was previously published under Q154889

Bug #: 1261 (SQLBUG_65)

SYMPTOMS

If an SA turns on CURSOR_CLOSE_ON_COMMIT at the system level, all attempts to connect to SQL Enterprise Manager fails and the following error message appears:

A connection could not be made to SERVERNAME - [SQL Server]
cursor is not open.

The following syntax is used to turn on CURSOR_CLOSE_ON_COMMIT:

   sp_configure "user options", 4
   go
   reconfigure
   go

STATUS

Microsoft has confirmed this to be a problem in SQL Server 6.5.

Modification Type:	Major	Last Reviewed:	10/3/2003
Keywords:	kbbug kbpending KB154889