Responses to Web requests are delayed from MCMS (837745)

SYMPTOMS

When the server computer that is running Microsoft Content Management Server (MCMS) 2002 becomes disconnected from the server computer that is running Microsoft SQL Server, MCMS responses to Web requests may be delayed. The responses are delayed approximately 45 seconds. This delay occurs for all Web requests on all Web sites.

Additionally, event messages that are similar to the following are logged in the application event log on the computer that is running MCMS: Type: Warning
Description:
Connection 00D314C8 <[Microsoft][ODBC Microsoft SQL Server Driver][DBNETLIB]Microsoft SQL Server does not exist or access denied.>{State=08001 NativeCode=17}

Type: Information
Description:
Connection 00D314C8 <[Microsoft][ODBC Microsoft SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).>{State=01000 NativeCode=1231}

CAUSE

The MCMS Internet Server API (ISAPI) filter determines if a Web request refers to an MCMS object. To do this, the filter verifies the information in every request that is sent to MCMS. The filter verifies this information with the computer that is running SQL Server:

If the request refers to an MCMS object, MCMS processes the request.
If the request does not refer to an MCMS object, MCMS passes the request to Microsoft Internet Information Services (IIS).

This issue occurs because, when the computer that is running MCMS becomes disconnected from the computer that is running SQL Server, the MCMS ISAPI filter cannot determine whether to process the request or to pass the request to IIS.

WORKAROUND

To work around this issue, use one of the following methods:

Create a local instance of SQL Server that contains an empty MCMS database. You can then use this database to process non-MCMS requests. This way, both MCMS requests and SQL requests can be processed without a delay if the MCMS server becomes disconnected from the default computer that is running SQL Server.
Remove the MCMS ISAPI filter.

MORE INFORMATION

For more information about Microsoft Content Management Server 2002, visit the following Microsoft Web site:

http://www.microsoft.com/cmserver/default.aspx