Skip to main content
Delphix

"Network Connection Reset" when linking a SQL Server Database From Windows Server 2003

Problem:

Linking a SQL Server database from a Windows Server 2003 Source fails with a "Network Connection Reset" error.

Resolution:

This failure occur if the SMB (Windows File Sharing) client on the source host times out after writing the backup file to the Delphix TEMP share, while waiting for data to be flushed to disk (as part of a FlushFileBuffers() operation).

A workaround for this issue is to increase the SMB client session timeout value, SESSTIMEOUT.

Microsoft KB Article KB102067 describes the process of setting this value:

SESSTIMEOUT can be set using REGEDT32. It is found under HKEY_LOCAL_MACHINE\SYSTEM\CURRENTCONTROLSET\SERVICES\ LANMANWORKSTATION\PARAMETERS\SESSTIMEOUT. It has a variable type of REG_DWORD. The value is stored in decimal seconds. The default is 45. Range 10 to 65535 seconds. SESSTIMEOUT is never automatically adjusted. If you manually adjust the value it will take effect immediately. 

The appropriate value for this setting will vary, based on the network throughput between the Delphix Engine and the Staging/PPT host, and the available RAM for file system cache on the Staging/PPT host.