Microsoft KB Archive/899714

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

Article ID: 899714

Article Last Modified on 11/5/2007

-

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 &quot;Applies to&quot; 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://msdn2.microsoft.com/en-us/library/ms525972.aspx

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_ , 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.

Keywords: kbsmsreporting kbtshoot kbprb KB899714

-

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

© Microsoft Corporation. All rights reserved.