Home > MS CRM 4.0 > Unable to connect to the remote server when bulk import of data

Unable to connect to the remote server when bulk import of data


The Underlying connection was closed: Unable to connect to the remote server

Had this tip sent to me earlier not sure what the original source is but it works so im passing it on. 

The Underlying connection was closed: Unable to connect to the remote server this error is a problem due to running out of TCP ports. You can minimize or eliminate this problem by setting the following registry keys on the Microsoft CRM Server(s). This is typically seen in scenarios with Microsoft CRM when the server is under high user load or more typically when it is under high load from a Bulk import or a Microsoft CRM SDK application that is importing thousands of records into the application. Note that these are both REGDWORD Keys and the values should be set as decimal values.

 HKLMSystemCurrentControlSetServicesTCPIPParameters

Create a new REGDWORD value named MaxUserPort with a value of 65534.

Also create a new REGDWORD value named TcpTimedWaitDelay with a value of 30. What this means is that we now have a total of 65534 TCP ports available and that they will recycle for use again after 30 seconds. This compares to the default of 5000 ports and a TcpTimedWaitDelay default of 240 (4 min).

 

Advertisements
Categories: MS CRM 4.0
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: