Server drop connection error

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Server drop connection error

12 posts, Page 1 of 2

1 2 »»

Server drop connection error

Rate Topic

Display Mode

Topic Options

Author

Message

santhosh411

Posted Tuesday, July 17, 2012 3:37 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 8:28 AM
Points: 21, Visits: 170

Error: 17886, Severity: 20, State: 1. 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. [Policy: MSSQL Logfile Template]

Any suggestions

Post #1330599

GilaMonster

Posted Tuesday, July 17, 2012 4:00 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 37,640, Visits: 29,895

santhosh411 (7/17/2012)

Please contact the client driver vendor. [Policy: MSSQL Logfile Template]

Any suggestions

I would start with what the error says. That's a misbehaving driver.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1330616

Lowell

Posted Tuesday, July 17, 2012 6:55 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 1:11 PM
Points: 11,605, Visits: 27,645

is the database set to single user?

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

if it is, and should not be, you need this command:

ALTER DATABASE [YourDatabaseName] SET MULTI_USER

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1330716

santhosh411

Posted Tuesday, July 17, 2012 7:34 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 8:28 AM
Points: 21, Visits: 170

Any more suggestions on this

Post #1330738

Lowell

Posted Tuesday, July 17, 2012 7:37 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 1:11 PM
Points: 11,605, Visits: 27,645

santhosh411 (7/17/2012)

Any more suggestions on this

what did you try?
what did not work?
did you upgrade the driver like Gail suggested?
did you try the suggestions i posted,and what were the results of the queries?

Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1330745

santhosh411

Posted Tuesday, July 17, 2012 7:52 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 8:28 AM
Points: 21, Visits: 170

All databases are in multi user mode only and the drivers were running fine.

Post #1330765

GilaMonster

Posted Tuesday, July 17, 2012 7:56 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 37,640, Visits: 29,895

santhosh411 (7/17/2012)

All databases are in multi user mode only and the drivers were running fine.

This error has nothing to do with single-user databases. It's MARS-related (multiple-active-result-sets), the ability to have multiple requests pending on a session at a time. This error occurs when the driver attempts a connection reset while there are other pending requests.

Check the driver version, upgrade if necessary.
Vendor app or custom development?

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1330768

santhosh411

Posted Tuesday, July 17, 2012 9:04 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 8:28 AM
Points: 21, Visits: 170

Thanks...!!!!!!!!!!!

Any more suggestion please??????????????

Post #1330815

GilaMonster

Posted Tuesday, July 17, 2012 9:39 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 12:59 PM
Points: 37,640, Visits: 29,895

Sure, answer my question.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1330836

david.abram

Posted Tuesday, January 29, 2013 4:46 AM

Old Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 9:36 AM
Points: 381, Visits: 189

Hi,

I am receiving this error against one of my databases. There are multiple connections in to it from multiple servers and I would like to tie it down to the application/connection that it is happening against. Is there any way in SQL Profiler to find the error alongside the login or application name?

There is too much activity against the database to be able to link the time of the error message to one connection/ login etc..

Any suggestions would be welcome.

Thanks,

Dave

Post #1412921

« Prev Topic | Next Topic »

12 posts, Page 1 of 2

1 2 »»

Permissions