Hello,

I have some users reporting issues accessing reports. We have created a 
Reporting User Only role and have assigned a Reporting User AD group 
permissions to this security role in SCCM. Users are unable to access reports 
via ConfigMgr admin console installed locally on their machines. The error is 
"The DefaultValue expression for the report parameter 'UserTokenSIDs' contains 
and error. The username or password is incorrect." The temp work around has 
been to modify the HKLM\Software\Microsoft\SMS\SMSRP\EnableRBACReporting from 1 
to 0. However, the setting will revert back to 0 after some time.


SQL Reporting Services is using the NT Service\ReportServer account. I came 
across the following and wonder if we need to switch to a domain account?


https://www.anoopcnair.com/2014/02/10/sccm-2012-r2-upgrade-breaks-ssrs-usertokensids-error/

SCCM 2012 R2 Upgrade Breaks SSRS with UserTokenSIDs 
...<https://www.anoopcnair.com/2014/02/10/sccm-2012-r2-upgrade-breaks-ssrs-usertokensids-error/>
www.anoopcnair.com
Follow @anoopmannur. Recently, We had a discussion in Facebook Group for SCCM 
ConfigMgr Professionals about SSRS reporting issue after upgrading from SCCM 
2012 SP1 to R2.

Thank you,

Brian





Reply via email to