Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
ssrs report with custom code to validate parameters

Answered ssrs report with custom code to validate parameters

  • Friday, March 16, 2012 5:17 AM
     
     
    Sign In to Vote
    0

    Hello,

    I am new to SSRS report administration...

    Here is my question....

    I have created SSRS report with custom code in which I connected to a database and get the data to validate against the report parameters. It worked fine when i run the report from BIDS. In order to run this I need to change the configuration file's Code Group property by setting to "FullTrust". But when I deployed the report to report manager, it is giving me this error...

    Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. (rsRuntimeErrorInExpression).

    Can some one help this out why there is issue with report server....

    Thanks for your help in advance

     

All Replies

  • Friday, March 16, 2012 9:36 AM
     
     
    Sign In to Vote
    0
    Please check the service account of Reporting Services. I think it's a permission issue.

    Regards, Nighting Liu

     
  • Monday, March 19, 2012 8:40 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi,

    For security reason, you should change following two groups toFullTrustin three configure files, please follow these steps to allow executing the custom code:

    1.Open these three files:

    1).RSPreviewPolicy which located at C:\Program Files (x86)\Microsoft Visual Studio 9.0\Common7\IDE\PrivateAssemblies

    2).rsmgrpolicy which located at C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager

    3).rssrvpolicy which located at C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer

    2. Change the PermissionSetName of the following 2 groups from “Execution” to “FullTrust”:

    <CodeGroup

    class="UnionCodeGroup"

    version="1"

    PermissionSetName="FullTrust"

    Name="Report_Expressions_Default_Permissions"

    Description="This code group grants default permissions for code in report expressions and Code element.">

    </CodeGroup>

    <CodeGroup

    class="FirstMatchCodeGroup"

    version="1"

    PermissionSetName="FullTrust"

    Description="This code group grants MyComputer code Execution permission. ">

    <IMembershipCondition

    class="ZoneMembershipCondition"

    version="1"

    Zone="MyComputer" />

    </CodeGroup>

    3. Specify a execution account for Reporting Services using Report Services Configuration Manager.

    Please get some reference from this similar thread http://social.msdn.microsoft.com/Forums/is/sqlreportingservices/thread/90bc9167-af50-42ac-be5a-4f10dc7cc652

    For more information, please see: Introducing Code Access Security in Reporting Services:http://technet.microsoft.com/en-us/library/ms154658(SQL.90).aspx

    Challen Fu

    TechNet Community Support

     
  • Tuesday, March 20, 2012 5:13 AM
     
     
    Sign In to Vote
    0

    Hi Nighting,

    Yes , it is a permission issue and I edited configuration files by changing the Permission set name to 'Full Trust'. It did work for me.

    Thank you very much..

     
  • Tuesday, March 20, 2012 5:15 AM
     
     
    Sign In to Vote
    0

    Hi Challen,

    Thank you very much. It is very helpful information. I followed the same and it worked for me.....

    Thanks,

     
  • Tuesday, March 27, 2012 8:25 PM
     
     
    Sign In to Vote
    0

    Hi Challen,

    It did work fine when I change the settings in the configuration files in our dev/qa, but on our production server, i was not able to see ReportManager/ReportSErver folders and hence policy configuration files. Can you help me out what if I don't have those directories? how should I get access to those installed?

    Thanks

     
  • Wednesday, March 28, 2012 4:55 AM
    Moderator
     
     Answered
    Sign In to Vote
    0
    You should have the Admin permission on the server to achieve this. Please contact your system administrator to help this.

    Challen Fu

    TechNet Community Support

     
  • Friday, April 06, 2012 5:02 AM
     
     
    Sign In to Vote
    0

    Challen,

    Sorry to reply you back..BUSY WITH PRODUCTION RELEASES LAST WEEK. Yes it is, I got the admin permissions and hence the configuration files.

    Thank you very much...