Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Help!non-admin user cannot read report content Expand / Collapse
Author
Message
Posted Monday, February 23, 2009 8:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 5, 2009 7:43 PM
Points: 2, Visits: 19
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)
Post #663199
Posted Tuesday, February 24, 2009 7:23 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:07 AM
Points: 11,157, Visits: 12,899
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.




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #663460
Posted Tuesday, February 24, 2009 8:46 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 5, 2009 7:43 PM
Points: 2, Visits: 19
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???
Post #663975
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse