<p>Here is the full error: <code>SqlException: A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 1 - I/O Error detected in read/write operation)</code></p>

<p>I've started seeing this message intermittently for a few of the unit tests in my application (there are over 1100 unit &amp; system tests).  I'm using the test runner in ReSharper 4.1.</p>

<p>One other thing: my development machine is a VMWare virtual machine.</p>

[{'answer_id': 52729, 'author': 'David Basarab', 'author_id': 2469, 'author_profile': 'https://Stackoverflow.com/users/2469', 'pm_score': 3, 'selected': False, 'text': '<p>I ran into this many moons ago.  Bottom line is you are running out of available ports.</p>\n\n<p>First make sure your calling application has connection pooling on.</p>\n\n<p>If that does then check the number of available ports for the SQL Server.</p>\n\n<p>What is happening is that if pooling is off then every call takes a port and it takes by default 4 minutes to have the port expire, and you are running out of ports.</p>\n\n<p>If pooling is on then you need to profile all the ports of SQL Server and make sure you have enough and expand them if necessary.</p>\n\n<p>When I came across this error, connection pooling was off and it caused this issue whenever a decent load was put on the website.  We did not see it in development because the load was 2 or 3 people at max, but once the number grew over 10 we kept seeing this error.  We turned pooling on, and it fixed it.</p>\n'}, {'answer_id': 52741, 'author': 'JasonS', 'author_id': 1865, 'author_profile': 'https://Stackoverflow.com/users/1865', 'pm_score': 2, 'selected': False, 'text': "<p>I ran into this many moons ago as well.  However, not to discount @Longhorn213s explanation, but we had the exact opposite behavior.  We received the error in development and testing, but not production where obviously the load was much greater.  We ended up tolerating the issue in development as it was sporadic and didn't materially slow down progress.  I think there could be several reasons for this error, but was never able to pin point the cause myself.</p>\n"}, {'answer_id': 52783, 'author': 'Jay Mooney', 'author_id': 733, 'author_profile': 'https://Stackoverflow.com/users/733', 'pm_score': 0, 'selected': False, 'text': '<p>We saw this in our environment, and traced part of it down to the "NOLOCK" hint in our queries.  We removed the NOLOCK hint and set our servers to use Snapshot Isolation mode, and the frequency of these errors was reduced quite a bit.</p>\n'}, {'answer_id': 52963, 'author': 'Sir Rippov the Maple', 'author_id': 2822, 'author_profile': 'https://Stackoverflow.com/users/2822', 'pm_score': 1, 'selected': False, 'text': "<p>We've also run across this error and figured out that we were killing a SQL server connection from the database server. The client application is under the impression that the connection is still active and tries make use of that connection, but fails because it was terminated.</p>\n"}, {'answer_id': 10307003, 'author': 'Jim Reineri', 'author_id': 92325, 'author_profile': 'https://Stackoverflow.com/users/92325', 'pm_score': 0, 'selected': False, 'text': '<p>We have seen this error a few times and tried different resolutions with varying success.  One common underlying theme has been that the system giving the error was running low on memory.  This is especially true if the server that is hosting Sql Server is running ANY other non-OS process.  By default SQL Server will grab any memory that it can, then if leaving little for other processes/drivers.  This can cause erratic behavior and intermittent messages.  It is good practice to configure your SQL Server for a maximum memory that leaves some headroom is there are other processes that might need it.  Example: Visual Studio on a dev machine that is running a copy of SQL Server developers edition on the same machine.</p>\n'}]
['https://Stackoverflow.com/questions/52711', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/3475/']