Prev: Add Function code to SSRS to PARSE the URL and use result in report qry
Next: Multi-select parameter default?
From: Bruce L-C [MVP] on 29 Apr 2010 13:46
Too bad. I was hoping you were just on Windows 7 or Vista or Windows 2008
server. If you are seeing this on XP SP3 then the higher security that
Windows 7 provides is not the problem.

So if you are in Report Manager, click on a folder, click on a report, click
on properties tab, security is that when you get an error?

I am now on 2008 but I have not see this sort of problem myself or seen it
posted in the newsgroup. The most common security problem is that IIS has
been set to anonymous (2008 doesn't use IIS so this problem has gone away).
But that issue prevents you from even getting this far, it doesn't cause an
error.

--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

"Duwaine" <user(a)msgroups.net/> wrote in message
news:#B8Cwq65KHA.420(a)TK2MSFTNGP02.phx.gbl...
> Run it from Windows XP SP3 and Windows 7 and get the same behavior. I also
> get the same behavior when I run it locally on the host server which is
> Windows server 2003.
>
> -Duwaine
>
> ---
> frmsrcurl:
> http://msgroups.net/microsoft.public.sqlserver.reportingsvcs/Reporting-Services-2005-Item-Security-Issue

From: Duwaine on 30 Apr 2010 18:26
Hi Bruce,

I think I am closer to the root cause of the issue. I tried editing the security in SSMS 2005 and I got an internal error in Reporting Services.

Below is the error that I get on Report Manager.


An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote errors

I get this error in Management Studio.

"Unhandled exception has ocurred in a component in your application. ...."

"An internal error occurred on the report server. See error log for details. (rsInternalError)."

The StackTrace is too long to put here but it points to security.

Microsoft.SqlServer.ReportingServices.ReportServiceDetailsException: An internal error occurred on the report server. See the error log for more details. (rsInternalError) ---> Microsoft.SqlServer.ReportingServices.ReportServiceMoreInformationException: An internal error occurred on the report server. See the error log for more details. (rsInternalError) ---> Microsoft.SqlServer.ReportingServices.ReportServiceMoreInformationException: Object reference not set to an instance of an object. ()
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.GetPermissions(String item)
at Microsoft.SqlServer.Management.UI.RSUserInterface.MenuAccessHandler2.PermissionsCacheItem.get_ParentPermissions()
at Microsoft.SqlServer.Management.UI.RSUserInterface.MenuAccessHandler2.EvaluateNode(XPathNavigator navigator, PermissionsCacheItem cache)
at Microsoft.SqlServer.Management.UI.RSUserInterface.MenuAccessHandler2.Evaluate(String xmlExpression, INodeInformation source)



---
frmsrcurl: http://msgroups.net/microsoft.public.sqlserver.reportingsvcs/Reporting-Services-2005-Item-Security-Issue
First  |  Prev  | 
Pages: 1 2
Prev: Add Function code to SSRS to PARSE the URL and use result in report qry
Next: Multi-select parameter default?