Microsoft KB Archive/897014

= BUG: You are redirected to the logon Web page when you try to run more than 18 different reports and you use a Forms Authentication extension in SQL Server 2000 Reporting Services =

Article ID: 897014

Article Last Modified on 3/15/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Reporting Services

-



BUG #: 342746 (SQLBUDT)



SYMPTOMS
In Microsoft SQL Server 2000 Reporting Services, when you use a Forms Authentication extension for Reporting Services and you try to run more than 18 different reports, you are redirected to the logon Web page. This problem occurs when you try to run the nineteenth report.

Note Setting the value of the UseSessionCookie record to false does not correct this problem and may cause other problems when you use Forms Authentication. The ConfigurationInfo table contains the UseSessionCookie record.



CAUSE
This problem occurs because you reached the limit of 20 cookies per individual domain. Each report uses 1 cookie. Additionally, Forms Authentication uses 1 cookie, and the Microsoft ASP.NET session uses 1 cookie. Therefore, running the nineteenth report requires a total of 21 cookies. When you try to run the nineteenth report, the Forms Authentication cookie is discarded, and you are redirected to the logon Web page.



WORKAROUND
To work around this problem, close Microsoft Internet Explorer to remove the report session cookies.



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
For more information about how to use a Forms Authentication extension for Reporting Services, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn2.microsoft.com/en-us/library/aa902691(SQL.80).aspx

Additional query words: SRS

Keywords: kbreport kbsqlserv2005fix kbtshoot kbbug KB897014

-

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

© Microsoft Corporation. All rights reserved.