You may be prompted for your credentials when you use Report Viewer to run a report in Systems Management Server 2003 (899714)


The information in this article applies to:

  • Microsoft Systems Management Server 2003

SYMPTOMS

In Microsoft Systems Management Server (SMS) 2003, you can use Report Viewer to run a report from a reporting point that is hosted on a Microsoft Internet Information Services (IIS) 6.0 server. However, if the report returns a very large results set, you may be prompted for your credentials after the report has been running for several minutes.

CAUSE

This problem occurs because the Active Server Pages (ASP) page buffers the data into 2 KB chunks for each send operation. The Http.sys driver allows only 10,000 chunks for each send operation. Any file that is larger than 20 MB causes the Http.sys driver to prematurely stop the data transfer. Therefore, this problem occurs when a report that returns a results set that exceeds 20 MB.

RESOLUTION

To resolve this problem, apply the hotfix that is mentioned in the following article:

826756 The Response.BinaryWrite method fails when you use it to send files that are larger than 20 MB

Note After you apply this hotfix, you may have to increase the value of the following IIS metabase properties to successfully return all the results sets:
  • AspBufferingLimit
  • AspScriptTimeout

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

The AspBufferingLimit property sets the maximum size of the ASP buffer. If response buffering is turned on, this property controls the maximum number of bytes that an ASP page can write to the response buffer before the buffer is flushed.

For more information about the AspBufferingLimit property, visit the following Microsoft Web site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/iissdk/html/ecfc3d4a-0178-45e8-89f8-304429b7fda5.asp

To find the AspScriptTimeout property, follow these steps.

Note These steps assume that you are running IIS 6.0.
  1. Click Start, click Run, type %SystemRoot%\system32\inetsrv\iis.msc, and then click OK.
  2. Double-click the computer that the reporting point is running on, double-click Web Sites, and then click Default Web Site.
  3. Right-click SMSReporting_SMSSitename, and then click Properties.
  4. Click the Virtual Directory tab, and then click Configuration under Application settings.
  5. Click the Options tab.

    The ASP script time-out setting is in the Application configuration group.
Modification Type:MajorLast Reviewed:6/20/2005
Keywords:kbSMSReporting kbtshoot kbprb KB899714 kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.