CTX105318 - Slow Response To an ICA Connection When the Data Store Is Offline This document was published at: http://support.citrix.com/kb/entry.jspa?externalID=CTX105318 Document ID: CTX105318, Created on: Dec 29, 2004, Updated: Jan 6, 2005 Products: Citrix MetaFrame XP 1.0 for Microsoft Windows 2000 Symptoms There is a slow response to an ICA connection when the data store is offline. Cause If the data store is offline (for voluntary or involuntary reasons), the local host cache (LHC) will provide continued functionality to the farm for at least 96 hours. In direct mode with an SQL or Oracle database used to hold the data store, it can take up to 90 seconds until a MetaFrame server in the farm receives a time out from the database server and switches to the LHC. Resolution This behavior is discussed in the following Microsoft article: PRB: Client Login Does Not Time Out If the Server Is Offline http://support.microsoft.com/default.aspx?scid=kb;en-us;176257 A SQL Server client application may not correctly time out according to the set timeout value in the application if the server it tries to connect to is shut down or otherwise offline. For example, if the timeout value is set to 10 seconds, the application may not time out until 90 seconds later. This can happen under either Named Pipes or TCP/IP sockets Net-Libraries, although the delay may be shorter under TCP/IP sockets. The solution given by Microsoft consists of modifying (or implementing) the TcpMaxConnectRetransmissions settings in the registry of the MetaFrame servers. Caution! This fix requires you to edit the registry. Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Citrix cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk. Be sure to back up the registry before you edit it. HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters TcpMaxConnectRetransmissions Key: Tcpip\Parameters Value Type: REG_DWORD ? Number Valid Range: 0 - 0xFFFFFFFF Default: 3 (in Windows NT) Default: 2 (in Windows 2000) Description: This parameter determines the number of times TCP will retransmit a connect request (SYN) before aborting the attempt. The retransmission timeout is doubled with each successive retransmission in a given connect attempt. The initial timeout value is 3 seconds.