Error running reports

[usdiwaya]

I get the following error when running reports in either the SCCM console or the web.

 

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. (rsRuntimeErrorInExpression)

 

More Details:

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.

-------------------------------

Microsoft.ConfigurationManagement.ManagementProvider.SmsException

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.

Stack Trace:

at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.GetParameters()

at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.LoadParameters(IReport report, Collection`1 navigationParameters, IResultObject resultObject)

at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerPresenter.Worker_DoWork(Object sender, DoWorkEventArgs e)

at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)

at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

-------------------------------

System.Web.Services.Protocols.SoapException

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.

Stack Trace:

at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.GetParameters()

at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ParameterPresenter.LoadParameters(IReport report, Collection`1 navigationParameters, IResultObject resultObject)

at Microsoft.ConfigurationManagement.AdminConsole.SrsReporting.ReportViewerPresenter.Worker_DoWork(Object sender, DoWorkEventArgs e)

at System.ComponentModel.BackgroundWorker.OnDoWork(DoWorkEventArgs e)

at System.ComponentModel.BackgroundWorker.WorkerThreadStart(Object argument)

-------------------------------

 

I have checked the permissions and everything looks good. Any ideas?

[GarthMJ]

Exactly what permission do you check?

 

Do you get the same error within the Web interface?

 

BTW I never recommend accessing SSRS from the console.

[usdiwaya]

Permissions for the reports folder that config manager created when installing the role.

Yes, I get the same error when accessing through the web interface.

[GarthMJ]

have you seen this? http://www.enhansoft.com/blog/configuration-manager-2012-r2-ssrs-and-windows-authorization-access-group

[usdiwaya]

Yeah, i have seen that. Verified the account is a member of the Windows Authorization Access Group.

[GarthMJ]

Have you seen this one.

http://blogs.msdn.com/b/chrissu/archive/2014/07/22/ssrs-error-the-defaultvalue-expression-for-the-report-parameter-usertokensids-contains-an-error-there-are-currently-no-logon-servers-available-to-service-the-logon-request-rsruntimeerrorinexpression.aspx

[usdiwaya]

Was able to resolve this issue by setting up a new reporting server and configure SCCM to use it.