Friday, March 16, 2012 5:17 AM
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=184.108.40.206, 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
Friday, March 16, 2012 9:36 AMPlease check the service account of Reporting Services. I think it's a permission issue.
Regards, Nighting Liu
Monday, March 19, 2012 8:40 AMModerator
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”:
Description="This code group grants default permissions for code in report expressions and Code element.">
Description="This code group grants MyComputer code Execution permission. ">
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
TechNet Community Support
- Marked As Answer by Challen FuModerator Monday, March 26, 2012 10:17 AM
Tuesday, March 20, 2012 5:13 AM
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
Thank you very much. It is very helpful information. I followed the same and it worked for me.....
Tuesday, March 27, 2012 8:25 PM
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?
Wednesday, March 28, 2012 4:55 AMModeratorYou should have the Admin permission on the server to achieve this. Please contact your system administrator to help this.
TechNet Community Support
- Marked As Answer by Challen FuModerator Friday, April 06, 2012 5:23 AM
Friday, April 06, 2012 5:02 AM
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...