Jump to content


Peopleschamp

Unable to Run Reports

Recommended Posts

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?

Share this post


Link to post
Share on other sites

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

.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.