SSRS Integrated Mode, raise error : Request for the permission of type 'System.DirectoryServices.Director yServicesPermission
Hi there, I have a case where I have a SSRS report which has custom code inside to help the SSRS grab Group Name of the User ID from Active Directory. When I open the report from Report Manager (Native Mode), it works very well. But when I upload the report into SharePoint Server, which I want to use SSRS Integrated Mode, the SharePoint cannot render the report instead it raise error : An error has occurred during report processing. (rsProcessingAborted) The Value expression for the query parameter @RptGroupAD contains an error: Request for the permission of type 'System.DirectoryServices.DirectoryServicesPermission, System.DirectoryServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' failed. (rsRuntimeErrorInExpression) Is there any setup configuration to be made in SharePoint administration or SSRS setup to solve fixing this error ? Thanks
August 15th, 2012 5:48am

Hi Octoni, Based on the current error message, the issue may be caused by the lacking of SecurityClass in the RSPreviewPolicy.config file. To avoid the the issue, please refer to the following steps: 1. If you are using SQL Server 2008 and earlier, open the C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies folder. If you are using SQL Server 2008 R2, open the %ProgramFiles%\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies folder. If you are using SQL Server 2012, open the %ProgramFiles%\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies folder. 2. Please make a copy of the RSPreviewPolicy.config file. 3. Open the RSPreviewPolicy.config file, and add the following element to the <SecurityClasses> </SecurityClasses> section: <SecurityClass Name="DirectoryServicesPermission" Description="System.DirectoryServices.DirectoryServicesPermission, System.DirectoryServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/> 4. Save the file. Hope this helps. Regards, Mike YinMike Yin TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
August 20th, 2012 7:15am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics