Solved

Disabling Shared Memory - SQL Native Client Configuration

Posted on 2009-04-14
2
1,567 Views
Last Modified: 2012-08-14
We have 5 front end Windows Server 2003 servers connecting to a Dell R900 server with 24 cores. All machines are 64 bit operating systems.   We have started seeing this error:

---> System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)

I have read many articles saying that we should disable Shared Memory in the SQL Native Client Configuration, and set the order of the TCP/IP client protocol to 1.

By disabling Shared Memory - what effect will this setting have on our current web applications?  If we are connecting to SQL Server using the SQL machine name, will we be affected?  I want to make sure our applications do not break.  

Isn't Shared Memory only used if a connection to SQL is made locally?
0
Comment
Question by:JWeb Admin
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 25

Accepted Solution

by:
reb73 earned 500 total points
ID: 24140921
AFAIK, shared memory protocol (if enabled) is used when connecting locally using (local) or . as the servername prefix
(e.g. (local) or (local)\namedinstance ) and should provide the fastest connection to the backend. This is done bypassing the network stack and using an in-memory pipe for direct communication.

If you are connecting from a webserver, there is no way shared memory protocol can be used, so disabling shared memory is unlikely to change anything in terms of remote connections.

Have a look at the link below to see if that helps in terms of resolving the error -

http://social.msdn.microsoft.com/forums/en-US/sqlnetfx/thread/4895d56b-716f-4f82-860f-0aa161d327cc/
0
 

Author Closing Comment

by:JWeb Admin
ID: 31570027
Thanks!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question