Forms Authentication Resulting in Blank Screen after a few minutes.

Hi – I hope someone can help,

I have developed a custom authentication extension to Reporting Services 2005, using Visual Studio 2005 C#.

In local integration tests the extension behaved as expected, honouring the role based security of our main system. Following the deployment steps laid out from numerous sources all worked perfectly. We were optimistic.

I've since deployed to a 'live' user acceptance staging server, using the same procedures used in Integration and it's behaving incorrectly.

Initially the log in page is displayed as expected, at this point SQL dumps occur in the RS Log directory, the same as is seen here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1750128&SiteID=1

Hopefully there'll be a resolution to that soon. As described in that topic, the main page of Report Manager appears.

After this it all goes wrong.

Sometimes we can browse to a folder and run a report. But after running the report, trying to run something else, or browse back to the containing folder we are presented with the error page with the message:

The permissions granted to user '' are insufficient for performing this operation.

Clicking on the home link brings up the top title and nothing else and you have no option but to close the site and re-login.

Sometimes you get the above message before you can even run a report. The error logs have the message listed at the end of this post.

Other times you log in to the website and the folders don't even appear, just the top title bar.

I have since added some verbose logging in each of the implemented methods in the extension DLL. The permission checking method return true and all the various data in each method appears as expected.

I have checked, checked again and re-checked all the configuration files, they match the local Integration files, barring the machine specific keys etc, they weren't just overwritten.

The location of the log directory where my internal logs are written is read from the configuration files via the SetConfiguration methods, if that wasn't set correctly then there wouldn't be any logs at all, so the configuration is being read correctly by the extension.

One other think that I've noticed is that the back door user that is configured in the config files works perfectly, but I can't see how this can make any sort of a difference as it returns the same result in the extension DLL as a 'normal' user does at the same point in the code.

Can someone please help me, and my poor scalp, it's losing hair at a rate of knots.

Set up:

Windows Server 2005

SQL Server 2005 Service Pack 2 (Developer)

IIS 6

Error message in the log files:

w3wp!library!1!27/06/2007-10:04:20:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation.

w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: The permissions granted to user '' are insufficient for performing this operation.

w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: HTTP status code --> 500

-Details--

Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation.

w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.

at System.Threading.Thread.AbortInternal()

at System.Threading.Thread.Abort(Object stateInfo)

at System.Web.HttpResponse.End()

at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)

at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()

at System.Threading.Thread.Abort(Object stateInfo)

at System.Web.HttpResponse.End()

at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)

at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

Additionally, once I get the error message above, and nothing is displayed apart from the headline bar, If I browse to the ReportServer web-service, in the same session, it works perfectly.

This is terribly frustrating.
|||*bump*

Any Ideas?
|||*re bump*

Forms Authentication Resulting in Blank Screen after a few minutes.

Hi – I hope someone can help,

I have developed a custom authentication extension to Reporting Services 2005, using Visual Studio 2005 C#.

In local integration tests the extension behaved as expected, honouring the role based security of our main system. Following the deployment steps laid out from numerous sources all worked perfectly. We were optimistic.

I've since deployed to a 'live' user acceptance staging server, using the same procedures used in Integration and it's behaving incorrectly.

Initially the log in page is displayed as expected, at this point SQL dumps occur in the RS Log directory, the same as is seen here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1750128&SiteID=1

Hopefully there'll be a resolution to that soon. As described in that topic, the main page of Report Manager appears.

After this it all goes wrong.

Sometimes we can browse to a folder and run a report. But after running the report, trying to run something else, or browse back to the containing folder we are presented with the error page with the message:

The permissions granted to user '' are insufficient for performing this operation.

Clicking on the home link brings up the top title and nothing else and you have no option but to close the site and re-login.

Sometimes you get the above message before you can even run a report. The error logs have the message listed at the end of this post.

Other times you log in to the website and the folders don't even appear, just the top title bar.

I have since added some verbose logging in each of the implemented methods in the extension DLL. The permission checking method return true and all the various data in each method appears as expected.

I have checked, checked again and re-checked all the configuration files, they match the local Integration files, barring the machine specific keys etc, they weren't just overwritten.

The location of the log directory where my internal logs are written is read from the configuration files via the SetConfiguration methods, if that wasn't set correctly then there wouldn't be any logs at all, so the configuration is being read correctly by the extension.

One other think that I've noticed is that the back door user that is configured in the config files works perfectly, but I can't see how this can make any sort of a difference as it returns the same result in the extension DLL as a 'normal' user does at the same point in the code.

Can someone please help me, and my poor scalp, it's losing hair at a rate of knots.

Set up:

Windows Server 2005

SQL Server 2005 Service Pack 2 (Developer)

IIS 6

Error message in the log files:

w3wp!library!1!27/06/2007-10:04:20:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation.

w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: The permissions granted to user '' are insufficient for performing this operation.

w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: HTTP status code --> 500

-Details--

Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user '' are insufficient for performing this operation.

w3wp!ui!1!27/06/2007-10:04:20:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.

at System.Threading.Thread.AbortInternal()

at System.Threading.Thread.Abort(Object stateInfo)

at System.Web.HttpResponse.End()

at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)

at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()

at System.Threading.Thread.Abort(Object stateInfo)

at System.Web.HttpResponse.End()

at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)

at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)

Additionally, once I get the error message above, and nothing is displayed apart from the headline bar, If I browse to the ReportServer web-service, in the same session, it works perfectly.

This is terribly frustrating.
|||*bump*

Any Ideas?
|||*re bump*

Formatting Problems Cont. . . MS PLEASE ANSWER

This is a variation of a post from earlier. I have noticed significant
differences between the on screen vs printed/exported versions of every
report I have done. If a report looks good on the screen, things are so out
of place on the print out/pdf versions that I would never give them to a
customer, and vice versa. Is there something I am doing wrong? Here are
some specific problems:
1) One report has a subreport with nothing more that a single table, it is
displayed at the center at the bottom of one report. When the report is
printed, the subreport is moved so far to the right that it prints on a whole
new page.
2) In that same report, I cannot leave blank space at the bottom after the
subreport, regardless of whether I leave a some space in the report,
subreport, or both.
3) Blanks in the returned data from a stored procedure are ignored
sporadically in my report matrices.
4) All reports extend an inch or so the the right for no reason, moving
everying out of center, and disconnection horizontal lines from their right
hand borders.
If you are reading this post and have not yet chosen whether to use MS
Reporting Services or Crystal, unless someone has given an answer explaining
how to fix these issues, I strongly suggest you use crystal. It will be
cheaper to pay their licensing fees than to deal with the development time of
RS. As far as I can tell, the 2000 version is a miserable excuse for a
release. It should still be a beta.I suggest you open an incident with support. Or, if you have MSDN you can
use managed newsgroups (which is posting here using a registered alias so MS
knows to monitor the post). Just posting here is not guaranteed a response
from MS. It is peer supported. It very well could be that there are work
arounds to your issues. Or ways to design that there is not a problem. RS is
not Crystal and Crystal is not RS. Some things RS does very well, others not
so well. It is a output independent development environment and things can
vary based on the capabilities of the output.
Given how you did not even try to first find out whether there was a
solution before being insulting I'll let others jump in if they want to.
That is the problem with peer support. If you are nasty your peers won't
want to help. I sure don't (and if you hang here at all you will see I help
a whole lot of people).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Evan" <Evan@.discussions.microsoft.com> wrote in message
news:4F087219-EE00-46DA-AEA5-7A073C243FCE@.microsoft.com...
> This is a variation of a post from earlier. I have noticed significant
> differences between the on screen vs printed/exported versions of every
> report I have done. If a report looks good on the screen, things are so
out
> of place on the print out/pdf versions that I would never give them to a
> customer, and vice versa. Is there something I am doing wrong? Here are
> some specific problems:
> 1) One report has a subreport with nothing more that a single table, it is
> displayed at the center at the bottom of one report. When the report is
> printed, the subreport is moved so far to the right that it prints on a
whole
> new page.
> 2) In that same report, I cannot leave blank space at the bottom after
the
> subreport, regardless of whether I leave a some space in the report,
> subreport, or both.
> 3) Blanks in the returned data from a stored procedure are ignored
> sporadically in my report matrices.
> 4) All reports extend an inch or so the the right for no reason, moving
> everying out of center, and disconnection horizontal lines from their
right
> hand borders.
> If you are reading this post and have not yet chosen whether to use MS
> Reporting Services or Crystal, unless someone has given an answer
explaining
> how to fix these issues, I strongly suggest you use crystal. It will be
> cheaper to pay their licensing fees than to deal with the development time
of
> RS. As far as I can tell, the 2000 version is a miserable excuse for a
> release. It should still be a beta.