x

What can cause Error: 18056 Severity:20 State:29 ?

Hi All,

I have been researching this error:

Error: 18056 Severity:20 State:29 The client was unable to reuse a session with SPID xx, which had been reset for connection pooling.

I can not find any real concise information, so I thought I would come to the fountain of knowledge that is AskSSC. I am sure there are numerous answers to this question so specifically I would like to know;

How to recreate this error at will? How connection pooling works ? (at a high level, if you can/want to go lower please do :))

How to prevent it from occuring in future ?

Below is so information about my SQL Server:

Microsoft SQL Server 2008 (SP2) - 10.0.4311.0 (X64) May 11 2011 14:27:15 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.1 (Build 7601: Service Pack 1) (VM)

Output from sp_configure is attached because I am having difficulty presenting it nicely in the question.

Thanks all and if this has been asked and answered elsewhere please feel free to abuse me but I did have a good look before posting,

MMB

sp_configure.txt (2.5 kB)
more ▼

asked Sep 14, 2012 at 03:03 PM in Default

megamanblue gravatar image

megamanblue
310 6 6 8

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
I don't know how to create this at will, but it was a problem I was running into a lot with a 2008 machine. Spending tons of time, I actually tracked it down to an out of date driver on the client side. Nothing on the server. Check there first.
more ▼

answered Sep 14, 2012 at 03:16 PM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

@Grant Fritchey Thanks for the pointer. Will get some profiler data and attempt to track down the client. Will post back with findings.
Sep 14, 2012 at 03:42 PM megamanblue
In our environemt it seems this message is a result of availability issues with our domain controllers. Still would like to understand why DC availability results in the above error and why it is not reported for all clients and just select ones. #none_the_wiser :|
Sep 26, 2012 at 08:30 AM megamanblue
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x597
x75
x9

asked: Sep 14, 2012 at 03:03 PM

Seen: 6171 times

Last Updated: Sep 26, 2012 at 08:30 AM