In this post we will see unable to run SSRS reports from other domain users and gives an error The Default Value expression for the report parameter ‘UserTokenSIDs’ contains an error: The user name or password is incorrect. (rsRuntimeErrorInExpression)"
Below are details steps to fix the issue.
Role Based Administration in MECM Current Branch, MECM will switch a flag in the registry. The registry key is HKLM\Software\Microsoft\SMS\SRSRP, value name is "EnableRbacReporting" set value to 0,
No user from trusted domains can run the reports. We have to set the value back to 0 and restart the report server for it to work again. But after sometime, SCCM set the value back to 1 and we are lost again.
We can change the value in WMI on the server where SSRS is installed.
a. Open "WBEMTEST" with admin rights
b. Click on Connect and type root\sms\site_code
c. Select the Query section and paste below query and click on Apply
Query:- Select * from sms_sci_sysresuse where itemname like '%reporting%'
D. Check the populated window and cross verify it's the reporting point and double click on Query
E. In populated window and Select "Props"
F. Select "View Embedded"
G. Window populated with the number of properties and find the property name with "EnableRbac Reporting"
H. Change the value from 1 to 0 and Value 2 from 1 to 0
Final verify the value in registry.