BUG: CURSOR_CLOSE_ON_COMMIT Stops SQL Enterprise Mgr. Logins

ID: Q154889

The information in this article applies to:
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

Last Reviewed: February 25, 1999