BUG: CURSOR_CLOSE_ON_COMMIT Stops SQL Enterprise Mgr. Logins

ID: Q154889

The information in this article applies to:

Microsoft SQL Server version 6.5

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 version 6.5.

Additional query words: configure @@options

Keywords : kbtool SSrvEntMan
Version : winnt:6.5
Platform : winnt
Issue type : kbbug