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 (897014)


The information in this article applies to:

  • Microsoft SQL Server 2000 Reporting Services
BUG #: 342746 (SQLBUDT)SQL BU Defect Tracking:342746

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 "Applies to" 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://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp

Modification Type:MajorLast Reviewed:5/11/2005
Keywords:kbReport KBSQLServ2005fix kbtshoot kbbug KB897014 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.