Help!non-admin user cannot read report content

  • Hi all, Thank you for reading my Problem on Reporting Service.

    Here is my problem.

    I have two account:

    1. Andy ==== in server's Administrators Group and SQLSERVER2005ReportServerUser Group === in Report Service, role as Content Manager

    2. Sam ==== in server's Other Group and SQLSERVER2005ReportServerUser Group === in Report Service, role as Content Manager

    I can read report content via Andy Account but when I use Sam Account, click into the report and it shown "rsInternalError". If I add Sam into Administrators Group, things go well.

    How can I solve this problem, since Sam's account could not be in Administrators. I think the problem is about the Sam's account in Server.

    Thank you all for your kind help!!!!

    my errorlog:

    w3wp!library!5!02/24/2009-09:58:26:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: RsInternalerror, please read the log (translated from Chinese), ;

    Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: RsInternalerror, please read the log (translated from Chinese) ---> System.InvalidOperationException: cannot get the computer name (or cannot get the name from computer, Translated from chinese 無法取得電腦名稱)。

    於 System.Environment.get_MachineName()

    於 Microsoft.ReportingServices.Diagnostics.RunningJobContext..ctor(String jobId, String requestPath, JobActionEnum action, JobType type, RunningJobList parentList, String userName, HttpContext optionalWebCtx)

    於 Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase..ctor(String jobId, String requestPath, JobActionEnum action, JobType jobType, String userName)

    於 Microsoft.ReportingServices.Library.ProcessReportParametersCancelableStep..ctor(RSService rs, CatalogItemContext reportContext, Guid reportID, Guid linkID, DateTime historyDate, Int32 executionOption, ReportSnapshot compiledDefinition, ReportSnapshot snapshotData, String savedParametersXml, NameValueCollection values, RuntimeDataSourceInfoCollection allDataSources, JobType jobType, String userName)

    於 Microsoft.ReportingServices.Library.RSService.GetReportParametersForRendering(CatalogItemContext reportContext, Guid reportID, Guid linkID, DateTime snapshotExecutionDate, Int32 executionOption, ReportSnapshot compiledDefinition, ReportSnapshot snapshotData, String savedParametersXml, NameValueCollection values, RuntimeDataSourceInfoCollection allDataSources, JobType jobType)

    於 Microsoft.ReportingServices.Library.GetDataForExecutionAction._GetDataForExecution(CatalogItemContext reportContext, ClientRequest session, String historyID, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& snapshotExecutionDate, ReportSnapshot& snapshotData, PageSettings& reportPageSettings)

    於 Microsoft.ReportingServices.Library.GetDataForExecutionAction.ExecuteStep(CatalogItemContext reportContext, ClientRequest session, DataSourcePromptCollection& prompts, ExecutionSettingEnum& execSetting, DateTime& executionDateTime, ReportSnapshot& snapshotData, PageSettings& reportPageSettings)

  • I've never seen this before and the only thing I can find on-line that might be helpful is this:

    http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/ad9bdf44-e492-4d7a-893e-abed5179bf2a/

    but it specifically addresses SSRS 2008. You may want to take a look though.

  • thank you very much for your all information!!!

    Finally I find out the solution: Sam should be in the user group!!! Now I put Sam into "user" group of the Server, everything become great!!

    But I have a question, should all people login to read report be in the user group???

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply