I have been researching this error:
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:
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,
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.
answered Sep 14, 2012 at 03:16 PM
Grant Fritchey ♦♦