Knowledge Base

BUG: CURSOR_CLOSE_ON_COMMIT Stops SQL Enterprise Mgr. Logins

Article ID: 154889

Article Last Modified on 10/3/2003

Microsoft SQL Server 6.5 Standard Edition

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.

Additional query words: configure @@options

Keywords: kbbug kbpending KB154889