Event ID: 17886 Source: MSSQLSERVER (MSSQL Server 2008R2)
Question
Friday, July 19, 2013 11:52 PM
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
All replies (8)
Monday, July 22, 2013 11:36 AM ✅Answered
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
Saturday, July 20, 2013 6:19 AM
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 10:38 PM
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
Sunday, July 21, 2013 6:05 AM
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
Monday, July 22, 2013 11:15 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:44 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 3:34 PM
Hi Selva Kumar,
Our server is in Multi user mode.
Regards
Mushtaq
Saturday, July 27, 2013 8:12 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
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