Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
evmisu
Starting Member
17 Posts |
 Posted - 2009-02-21 : 02:52:45
|
| Hi all, Thank you for reading my Problem. Here is my problem.I have two account:1. Andy ==== in Administrators Group and SQLSERVER2005ReportServerUser2. Sam ==== in Other Group and SQLSERVER2005ReportServerUserI can read report via Andy Account but when I use Sam Account, the Report show "rsInternalError". If I add Sam into Administrators Group, things go well.How can I solve this problem, since Sam account could not be in Administrators.Thank you all for your kind help!!!! Andy Sam |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-21 : 04:06:29
|
| what is role Sam is assigned in report server? |
 |
|
|
evmisu
Starting Member
17 Posts |
Posted - 2009-02-21 : 19:34:19
|
| VISA!!! Hello!! Thank you all tha time.Andy ====> Content ManagerSam ====> browser. I try to set Sam in Manager also but failed in loading the table of the report.Have a Nice day! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-22 : 01:29:14
|
| then he should be able to view the reports. do you he couldnt until he was added to admin group? |
|
|
|
evmisu
Starting Member
17 Posts |
Posted - 2009-02-22 : 23:15:30
|
| That's why I am really confused.Yes you are right. He cannot read the report (meet "rsInternalError") until i put him in to the admin group in the server. meet so many problem in reporting service....sigh... |
|
|
|
Cody
Starting Member
24 Posts |
Posted - 2009-02-23 : 17:35:35
|
| Sam doesn't have permission to see the report. Making him a Browser isn't enough. You need to add him to either the report or the root item of the report (ie: its directory, or the main directory if you want him to have access to everything).Logon to the Reports interface as an Admin. Click the Properties button. It will show you the security list for "everything" and you can add him here.If you just want to give him access to this report go back to the reports list and click the Show Detail button. Click the edit button to the left of the report name, then click Security, and you can add him to the report here.I'm not sure if there's a way to add "everyone". |
|
|
|
evmisu
Starting Member
17 Posts |
Posted - 2009-02-23 : 21:42:20
|
| Thank you very much Cody, I've tried your way in very first. But no matter how I put Sam in content manager of Report interface, Sam cannot view the report content unless I put Sam into Administrator Group. That make me very confused.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) |
|
|
|
Cody
Starting Member
24 Posts |
Posted - 2009-02-23 : 21:54:19
|
| I haven't seen that error before. But if it says it can't get the computer name then I think something other than reporting services is set up wrong. Are you using windows authentication? On my system I have sql and reporting services on the same machine as the domain controller, so I don't get this problem ... |
|
|
|
evmisu
Starting Member
17 Posts |
Posted - 2009-02-24 : 22:48: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??? |
|
|
|
|
|
|
|
|
non-admin users browse Report through SSRS