Microsoft KB Archive/842571

= BUG: An HTTP connection to an instance of SQL Server 2005 may time out =

Article ID: 842571

Article Last Modified on 11/1/2005

-

APPLIES TO


 * Microsoft SQL Server 2005 Beta 2, when used with:
 * Microsoft Windows Server 2003, Standard Edition (32-bit x86)

-





Beta Information
This article discusses a Beta release of a Microsoft product. The information in this article is provided as-is and is subject to change without notice.

No formal product support is available from Microsoft for this Beta product. For information about how to obtain support for a Beta release, see the documentation that is included with the Beta product files, or check the Web location where you downloaded the release.



SYMPTOMS
If you use HTTP to connect to an instance of Microsoft SQL Server 2005 on a computer that is running the original release version of Microsoft Windows Server 2003, the HTTP connection may time out and may end unexpectedly. This problem occurs after the instance of SQL Server 2005 receives the SQL Server data that you sent as an HTTP request over the HTTP connection.



CAUSE
The timer in Http.sys is the kernel mode driver that handles HTTP requests in Windows Server 2003. This timer is not reset correctly after the instance of SQL Server receives the data as an HTTP request. Because the default connection time-out period is set to 120 seconds, the HTTP connection times out and ends if SQL Server 2005 takes more than 120 seconds to process the client request and to send the processing results as an HTTP response to the client.



WORKAROUND
To work around this problem, you must increase the connection time-out value of the Web sites on the computer that is running Microsoft Internet Information Services (IIS). For example, if IIS is installed on the computer that is running your instance of SQL Server 2005, follow these steps on the computer to increase the connection time-out value:
 * 1) Click Start, click Run, type inetmgr, and then click OK.
 * 2) In the left pane of the Internet Information Services (IIS) Manager window, expand Internet Information Services, expand , and then expand Web Sites.
 * 3) Right-click Default Web Site, and then click Properties.
 * 4) In the Default Web Site Properties dialog box, click the Web Site tab.
 * 5) Under the Connections section, type the new connection time-out value in the Connection timeout box.
 * 6) Click Apply, and then click OK.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the &quot;Applies to&quot; section.



MORE INFORMATION
The following list describes some situations where this problem may occur:
 * A SOAP/HTTP client sends a SOAP request to the instance of SQL Server 2005 over HTTP to start a stored procedure. The stored procedure may require more than 120 seconds to run successfully.
 * A SOAP/HTTP client sends a batch that contains Transact-SQL to the instance of SQL Server 2005. The batch may require more than 120 seconds to process the batch.

Additional query words: connection Times out time-out out closes ends disconnect HTTPSYS Yukon

Keywords: kbtshoot kbbug kbtimer kbhttp kbsqlclient kbserver kbupgrade kbclientserver kbclient kbhttphandlers KB842571

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.