none
Event ID: 17886 Source: MSSQLSERVER (MSSQL Server 2008R2)

    Question

  • Hi,

    I am receiving below mentioned error 

    "

    Log Name:      Application
    Source:        MSSQLSERVER
    Date:          7/19/2013 6:26:32 PM
    Event ID:      17886
    Task Category: Server
    Level:         Error
    Keywords:      Classic
    User:          N/A
    Computer:      206-225-86-52
    Description:
    The server will drop the connection, because the client driver has sent multiple requests while the session is in single-user mode. This error occurs when a client sends a request to reset the connection while there are batches still running in the session, or when the client sends a request while the session is resetting a connection. Please contact the client driver vendor."

    Regards

    Mushtaq


    Friday, July 19, 2013 11:52 PM

Answers

  • I am sure something like  ”MultipleActiveResultSets=True”  is missing from your connection string add this to your connection string .MARS was introduced from SQL server 2005 and applies to SQL 2005 and above.

    Do revert if it helps .

    I found this Info from link.


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    Monday, July 22, 2013 11:36 AM

All replies

  • As it say 'contact  client driver vendor' it seems some driver error.Driver is resetting the connection when there are still connections coming from application.

    Can u please share Errorlog with us


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    Saturday, July 20, 2013 6:19 AM
  • Hi Shanky,

    The errorlog is given below

    =============================================================================

    2013-07-19 18:43:42.94 Server      Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) 
    Apr 22 2011 19:23:43 
    Copyright (c) Microsoft Corporation
    Web Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

    2013-07-19 18:43:43.15 Server      (c) Microsoft Corporation.
    2013-07-19 18:43:43.15 Server      All rights reserved.
    2013-07-19 18:43:43.15 Server      Server process ID is 1336.
    2013-07-19 18:43:43.18 Server      System Manufacturer: 'Supermicro', System Model: 'X8SIL'.
    2013-07-19 18:43:43.19 Server      Authentication mode is MIXED.
    2013-07-19 18:43:43.19 Server      Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
    2013-07-19 18:43:43.24 Server      This instance of SQL Server last reported using a process ID of 1152 at 7/19/2013 6:42:47 PM (local) 7/19/2013 11:42:47 PM (UTC). This is an informational message only; no user action is required.
    2013-07-19 18:43:43.24 Server      Registry startup parameters: 
    -d C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf
    -e C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG
    -l C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
    2013-07-19 18:43:43.44 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    2013-07-19 18:43:43.44 Server      Detected 8 CPUs. This is an informational message; no user action is required.
    2013-07-19 18:43:44.54 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
    2013-07-19 18:43:46.60 Server      Node configuration: node 0: CPU mask: 0x00000000000000ff:0 Active CPU mask: 0x00000000000000ff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
    2013-07-19 18:43:47.37 spid7s      Starting up database 'master'.
    2013-07-19 18:43:48.00 spid7s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
    2013-07-19 18:43:48.71 spid7s      FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'.
    2013-07-19 18:43:49.13 spid7s      SQL Trace ID 1 was started by login "sa".
    2013-07-19 18:43:49.26 spid7s      Starting up database 'mssqlsystemresource'.
    2013-07-19 18:43:49.30 spid7s      The resource database build version is 10.50.1617. This is an informational message only. No user action is required.
    2013-07-19 18:43:49.87 spid10s     Starting up database 'model'.
    2013-07-19 18:43:49.89 spid7s      Server name is '206-225-86-52'. This is an informational message only. No user action is required.
    2013-07-19 18:43:50.18 spid10s     Clearing tempdb database.
    2013-07-19 18:43:50.58 Server      A self-generated certificate was successfully loaded for encryption.
    2013-07-19 18:43:50.68 Server      Server is listening on [ 'any' <ipv6> 1433].
    2013-07-19 18:43:50.68 Server      Server is listening on [ 'any' <ipv4> 1433].
    2013-07-19 18:43:50.69 Server      Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
    2013-07-19 18:43:50.69 Server      Server local connection provider is ready to accept connection on [ \\.\pipe\sql\query ].
    2013-07-19 18:43:50.72 spid10s     Starting up database 'tempdb'.
    2013-07-19 18:43:50.72 Server      Server is listening on [ ::1 <ipv6> 1434].
    2013-07-19 18:43:50.72 Server      Server is listening on [ 127.0.0.1 <ipv4> 1434].
    2013-07-19 18:43:50.72 Server      Dedicated admin connection support was established for listening locally on port 1434.
    2013-07-19 18:43:50.94 Server      The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, state: 3. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
    2013-07-19 18:43:50.94 Server      SQL Server is now ready for client connections. This is an informational message; no user action is required.
    2013-07-19 18:43:51.47 spid13s     The Service Broker protocol transport is disabled or not configured.
    2013-07-19 18:43:51.48 spid13s     The Database Mirroring protocol transport is disabled or not configured.
    2013-07-19 18:43:51.78 spid13s     Service Broker manager has started.
    2013-07-19 18:43:52.39 Logon       Error: 18456, Severity: 14, State: 38.
    2013-07-19 18:43:52.39 Logon       Login failed for user 'EM_Pre'. Reason: Failed to open the explicitly specified database. [CLIENT: ::1]
    2013-07-19 18:43:52.39 Logon       Error: 18456, Severity: 14, State: 38.
    2013-07-19 18:43:52.39 Logon       Login failed for user 'EM_Pre'. Reason: Failed to open the explicitly specified database. [CLIENT: ::1]
    2013-07-19 18:43:57.95 Logon       Error: 18456, Severity: 14, State: 38.
    2013-07-19 18:43:57.95 Logon       Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]
    2013-07-19 18:43:58.63 Logon       Error: 18456, Severity: 14, State: 38.
    2013-07-19 18:43:58.63 Logon       Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Failed to open the explicitly specified database. [CLIENT: <local machine>]
    2013-07-19 18:43:59.91 spid17s     A new instance of the full-text filter daemon host process has been successfully started.
    2013-07-19 18:44:00.29 spid17s     Starting up database 'msdb'.
    2013-07-19 18:44:00.30 spid25s     Starting up database 'ReportServer'.
    2013-07-19 18:44:00.30 spid26s     Starting up database 'ReportServerTempDB'.
    2013-07-19 18:44:00.78 spid7s      Recovery is complete. This is an informational message only. No user action is required.
    2013-07-19 18:44:06.30 spid52      Starting up database 'CompleteEM_Pre'.
    2013-07-19 18:50:16.67 Server      Error: 17886, Severity: 20, State: 1.
    2013-07-19 18:50:16.67 Server      The server will drop the connection, because the client driver has sent multiple requests while the session is in single-user mode. This error occurs when a client sends a request to reset the connection while there are batches still running in the session, or when the client sends a request while the session is resetting a connection. Please contact the client driver vendor.
    2013-07-19 18:55:06.90 Server      Error: 17886, Severity: 20, State: 1.
    2013-07-19 18:55:06.90 Server      The server will drop the connection, because the client driver has sent multiple requests while the session is in single-user mode. This error occurs when a client sends a request to reset the connection while there are batches still running in the session, or when the client sends a request while the session is resetting a connection. Please contact the client driver vendor.
    2013-07-19 19:04:19.70 spid59      Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required.
    2013-07-19 19:04:19.75 spid59      Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
    2013-07-19 19:05:17.42 Server      Error: 17886, Severity: 20, State: 1.
    2013-07-19 19:05:17.42 Server      The server will drop the connection, because the client driver has sent multiple requests while the session is in single-user mode. This error occurs when a client sends a request to reset the connection while there are batches still running in the session, or when the client sends a request while the session is resetting a connection. Please contact the client driver vendor.
    2013-07-19 19:05:18.76 spid56      Attempting to load library 'xpsqlbot.dll' into memory. This is an informational message only. No user action is required.
    2013-07-19 19:05:18.77 spid56      Using 'xpsqlbot.dll' version '2009.100.1600' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
    2013-07-19 19:05:19.03 spid56      Attempting to load library 'xplog70.dll' into memory. This is an informational message only. No user action is required.
    2013-07-19 19:05:19.05 spid56      Using 'xplog70.dll' version '2009.100.1600' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
    2013-07-19 19:05:31.26 spid61      Starting up database 'CompleteEMWiki_Pre'.
    2013-07-19 19:05:31.53 spid61      Starting up database 'CompleteEMWiki_Pre'.
    2013-07-19 19:05:31.97 spid61      Starting up database 'CompleteEMWiki_Pre'.
    2013-07-19 19:06:07.47 Server      Error: 17886, Severity: 20, State: 1.
    2013-07-19 19:06:07.47 Server      The server will drop the connection, because the client driver has sent multiple requests while the session is in single-user mode. This error occurs when a client sends a request to reset the connection while there are batches still running in the session, or when the client sends a request while the session is resetting a connection. Please contact the client driver vendor.
    2013-07-19 19:06:47.50 Server      Error: 17886, Severity: 20, State: 1.
    2013-07-19 19:06:47.50 Server      The server will drop the connection, because the client driver has sent multiple requests while the session is in single-user mode. This error occurs when a client sends a request to reset the connection while there are batches still running in the session, or when the client sends a request while the session is resetting a connection. Please contact the client driver vendor.
    2013-07-19 19:46:00.42 Server      Error: 17886, Severity: 20, State: 1.
    2013-07-19 19:46:00.42 Server      The server will drop the connection, because the client driver has sent multiple requests while the session is in single-user mode. This error occurs when a client sends a request to reset the connection while there are batches still running in the session, or when the client sends a request while the session is resetting a connection. Please contact the client driver vendor.
    2013-07-19 20:36:24.45 Server      Error: 17886, Severity: 20, State: 1.
    2013-07-19 20:36:24.45 Server      The server will drop the connection, because the client driver has sent multiple requests while the session is in single-user mode. This error occurs when a client sends a request to reset the connection while there are batches still running in the session, or when the client sends a request while the session is resetting a connection. Please contact the client driver vendor.
    2013-07-20 00:00:05.67 spid62      Starting up database 'CompleteEMWiki_Pre'.
    2013-07-20 00:00:06.19 Backup      Database backed up. Database: master, creation date(time): 2013/07/19(18:43:47), pages dumped: 386, first LSN: 216:304:85, last LSN: 216:360:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'c:\LiveDBBackup\master_backup_2013_07_20_000005_5302962.bak'}). This is an informational message only. No user action is required.
    2013-07-20 00:00:06.49 Backup      Database backed up. Database: model, creation date(time): 2003/04/08(09:13:36), pages dumped: 178, first LSN: 20:440:37, last LSN: 20:464:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'c:\LiveDBBackup\model_backup_2013_07_20_000005_6550965.bak'}). This is an informational message only. No user action is required.
    2013-07-20 00:00:07.03 spid27s     This instance of SQL Server has been using a process ID of 1336 since 7/19/2013 6:44:00 PM (local) 7/19/2013 11:44:00 PM (UTC). This is an informational message only; no user action is required.
    2013-07-20 00:00:07.03 Backup      Database backed up. Database: msdb, creation date(time): 2010/04/02(17:35:08), pages dumped: 1932, first LSN: 272:16:237, last LSN: 272:120:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'c:\LiveDBBackup\msdb_backup_2013_07_20_000005_6550965.bak'}). This is an informational message only. No user action is required.
    2013-07-20 00:00:07.39 Backup      Database backed up. Database: ReportServer, creation date(time): 2013/06/27(22:11:05), pages dumped: 444, first LSN: 55:662:37, last LSN: 55:678:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'c:\LiveDBBackup\ReportServer_backup_2013_07_20_000005_6706965.bak'}). This is an informational message only. No user action is required.
    2013-07-20 00:00:07.62 Backup      Database backed up. Database: ReportServerTempDB, creation date(time): 2013/06/27(22:11:06), pages dumped: 202, first LSN: 23:32:37, last LSN: 23:48:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'c:\LiveDBBackup\ReportServerTempDB_backup_2013_07_20_000005_6706965.bak'}). This is an informational message only. No user action is required.
    2013-07-20 00:00:09.51 Backup      Database backed up. Database: CompleteEM_Pre, creation date(time): 2013/06/28(09:05:03), pages dumped: 6072, first LSN: 25317:2486:79, last LSN: 25317:2518:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'c:\LiveDBBackup\CompleteEM_Pre_backup_2013_07_20_000005_6862965.bak'}). This is an informational message only. No user action is required.
    2013-07-20 00:00:09.54 spid64      Starting up database 'CompleteEMWiki_Pre'.
    2013-07-20 00:00:09.82 Backup      Database backed up. Database: CompleteEMWiki_Pre, creation date(time): 2013/06/28(09:07:53), pages dumped: 234, first LSN: 70:93:37, last LSN: 70:109:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'c:\LiveDBBackup\CompleteEMWiki_Pre_backup_2013_07_20_000005_7486966.bak'}). This is an informational message only. No user action is required.
    2013-07-20 00:57:25.15 Server      Error: 17886, Severity: 20, State: 1.
    2013-07-20 00:57:25.15 Server      The server will drop the connection, because the client driver has sent multiple requests while the session is in single-user mode. This error occurs when a client sends a request to reset the connection while there are batches still running in the session, or when the client sends a request while the session is resetting a connection. Please contact the client driver vendor.

    ======================================================================

    Regards

    Mushtaq

    Saturday, July 20, 2013 10:38 PM
  • I assume you are using MARS(multiple active result set) and when call is to reset connection it is getting delayed so this error is coming.

    In connection string please set Async=True.See if this error message disappears then. 


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Sunday, July 21, 2013 6:05 AM
  • Hi Shanky,

    Thanks for reply,

    I have done changes in connection string as you mentioned above but no luck, i am still receiving error.

    Regards

    Mushtaq

    Monday, July 22, 2013 11:15 AM
  • I am sure something like  ”MultipleActiveResultSets=True”  is missing from your connection string add this to your connection string .MARS was introduced from SQL server 2005 and applies to SQL 2005 and above.

    Do revert if it helps .

    I found this Info from link.


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    Monday, July 22, 2013 11:36 AM
  • Can you please check ur server in single user mode or multiple user mode ??

    run this one:

    select * from sys.databases WHERE user_access_desc = 'SINGLE_USER'
    select * from sys.databases WHERE user_access_desc = 'SINGLE_USER'



    Thanks - SelvaKumarSubramaniam.Please MARK AS ANSWER, if my answer is useful to U.

    Monday, July 22, 2013 11:44 AM
  • Hi Selva Kumar,

    Our server is in Multi user mode.

    Regards

    Mushtaq

    Monday, July 22, 2013 3:34 PM
  • I am sure something like  ”MultipleActiveResultSets=True”  is missing from your connection string add this to your connection string .MARS was introduced from SQL server 2005 and applies to SQL 2005 and above.

    Do revert if it helps .

    I found this Info from link.


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    Hi Mushtaqnaik,

    Can you please revert whether your issue is solved ,if not what is the problem if yes please mark answer which solved your issue.


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers


    Saturday, July 27, 2013 8:12 AM