Microsoft KB Archive/154889

= BUG: CURSOR_CLOSE_ON_COMMIT Stops SQL Enterprise Mgr. Logins =

Article ID: 154889

Article Last Modified on 10/3/2003

-

APPLIES TO


 * 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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.