Microsoft Dynamics CRM 4.0 - Importing Organization fails with "The connection's state is closed"

Check the system.data.dll file properties on the Microsoft Dynamics CRM server in the %windir%\Microsoft.Net\Framework\v2.0.50727 for x86 servers and %windir%\Microsoft.Net\Framework64\v2.0.50727 if the Microsoft Dynamics CRM server is installed on x64 Windows Server.  Verify if the version is less than 2.0.50727.1813.  If it is less than 2.0.50727.1813, then install the hotfix listed in the KB article below.

PRIMARY RESOLUTION

Hotfix information

1.

To resolve this problem, install the hotfix that is mentioned in the following article in the Microsoft Knowledge Base:

You must have the .NET Framework 2.0 Service Pack 1 installed to apply this hotfix.

2.  Install the latest Microsoft CRM 4 Hotfix (Update Rollup 8 or later) and add the OptimizeOrgImport registry key value documented in the following KB article: http://support.microsoft.com/kb/977867 

Restart requirement

You do not have to restart the computer after you apply this hotfix.

SECONDARY RESOLUTION - Note that these steps may need to be performed in addition to the application of the hotfix listed above.

If you have a Microsoft CRM Dynamics 4.0 organization database that is larger than 5 GB, you may need to increase the OLEDBTimeout setting in order for the organization import to complete successfully.  After the import of the organization has completed you should either delete this registry key or set the value of it between 60 to 300 decimal to prevent long running Microsoft Dynamics CRM queries from causing SQL Server blocking.  You can do this by adding the following REG_DWORD key on the Microsoft Dynamics CRM 4.0 server by using the directions below:

   1.     On the Microsoft Dynamics CRM 4.0 Server, click Start, click Run, type regedit, and then click OK.

2.      Locate the following registry subkey: HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM.

3.      If the OLEDBTimeout key does exist, skip to step 5.

4.      If the OLEDBTimeout key does not exist, create a new one:

a.      Right-click MSCRM, click New, and then click DWORD Value.

b.      Type OLEDBTimeout for the name.

5.      Right click OLEDBTimeout, choose modify, enter 86400 in Value data, and then mark the radio button next to Decimal.  This will represent 86,400 seconds, which is equal to 24 hours.

6.      After the import organization process has completed successfully, change the value of HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM\OLEDBTimeout to a value between 60 and 300 decimal.  If you are not sure of what value to set this to, set it to 30 decimal, which is the default. 

Note that you may also need to increase the maximum number of TCP ephemeral ports available via the instructions below:

To resolve this problem, increase the number of TCP ports that are available on both the Microsoft Dynamics CRM and the Microsoft SQL Servers. Then, reduce the length of time that these TCP ports must wait before they can be re-used. To do this, modify the MaxUserPort registry setting and the TcpTimedWaitDelay registry setting as follows.  This will increase the maximum ephemeral TCP ports to 65534 and reduce the time these ports are recycled to once every 30 seconds compared to once every four minutes.

To create this entry, follow these steps:

1. Click Start, click Run, type regedit, and then click OK.

2. Locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Tcpip\Parameters

3. Right click Parameters, point to New, click DWORD Value, and then type MaxUserPort.

4. Right click MaxUserPort, click Modify, and then type 65534 for Value data, and set the radio button next to Decimal.

Note: This value controls the number of dynamic ports that are available. The valid range for this value is 5,000-65,534. Specifically, this parameter controls the maximum port number that is used when a program requests any available user port from the system.

5. Locate the following registry subkey: HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\Tcpip\Parameters

6. Right click Parameters, point to New, click DWORD Value, and then type TCPTimedWaitDelay.

7. Right click TCPTimedWaitDelay, click Modify, type 30 for the Value data, and set the radio button next to Decimal.

Note: This parameter determines the length of time that a connection stays in the TIME_WAIT state when it is closed. When a connection is in the TIME_WAIT state, the socket pair cannot be re-used. This is also known as the "2MSL" state. Typically, this value is two times the maximum segment life time on the network.

8. Exit Registry Editor.

9. Restart the Microsoft Dynamics CRM server.