Peopleschamp Posted December 5, 2014 Report post Posted December 5, 2014 Sorry if this has been reported before but this is my 1st post and i'm new to the world of sccm But when I try and run reports the following error occurs The DefaultValue expression for the report parameter ‘UserTokenSIDs’ contains an error: Request for the permission of type 'System.Security.Permissions.SecurityPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=***********' failed SQL has been upgraded from express to 2008 r2 Anyone point me in the right direction as to where I should be looking at please? Quote Share this post Link to post Share on other sites More sharing options...
ludi2014 Posted December 5, 2014 Report post Posted December 5, 2014 I recommend doing the following : 1. Remove the Reporting Service Point from SCCM 2. Delete C:\Program Files\SMS_SRSRP 3. Delete the ReportServer and ReportServerTMP Databases thru SQL Management Studio 4. Make Sure "NT Service\ReportServer" has sysadmin and public as Service Roles under the Logins Folder. 5. Open Report Server Configuration Manager and recreate the Report Services Databases. Make sure you are using the "ReportServer" builtin account under the Server Account section. 6. Reinstall the Report Server Point in SCCM using the Window Server's builtin Administrator account. Use this account in both sections of the wizard. 7. Check all of the "SRS" related logs in the C:\Program Files\Microsoft Configuration Manager\Logs directory. Make sure there are no errors. 8. Check the http://sccmserver/reports and SCCM console to make sure the reports appear. kind regard Safet Grahic http://www.learnmesccm.com/ https://www.linkedin...ahic/a0/842/b21 . Quote Share this post Link to post Share on other sites More sharing options...
Peopleschamp Posted December 5, 2014 Report post Posted December 5, 2014 Hi Ludi thanks for that i'll look into doing that asap and let you know how I get on Quote Share this post Link to post Share on other sites More sharing options...