UPDATED: How to fix SCCM 2012 / 2012 R2 / 16 Reporting Services Issue (When users try to run reports it shows like the DefaultValue expression for the report parameter 'UserTokeSIDs' contains an error) Updated

2 comments
UPDATED: How to fix SCCM 2012 / 2012 R2 / 16 Reporting Services Issue (When users try to run reports it shows like the DefaultValue expression for the report parameter 'UserTokeSIDs' contains an error) Updated


Problem

Users have this error message when trying to execute reports.
clip_image001

Solution 1

The RBACReporting needs to be changed form 1 to 0
Go to regedit
Navigate to -> Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\SMS\SRSP
clip_image002
Click on EnableRbacReporting change the values from 1 to 0
clip_image003
clip_image004
Restart the SQL Services / Reporting
clip_image005
clip_image006

Solution 2:

1. Open  the Reporting Service Configuration Manager
2. Connect and then go to the Execution Account Tab and Specify the account
Note: It's recommended to use a service account with admin privileges on the SSRS DB and Instance.
3. Apply the changes and then Exit
4. Restart the SCCM and SQL/SSRS services then try to run a report and it should be fixed. 

 
The problem should be gone now. If you keep experiencing any other issues feel free to comment or just contact Microsoft.















2 comments :

  1. Hi Thanks for the solution, but problem still exists

    ReplyDelete