Wednesday, March 7, 2012

Problem viewing Reports from Network

Hi,
We have a network of XP Machines.
When i try to view the reports in the application from the same
machine itself it's coming up properly,but when i try to acess the
reports in the application from another machine it's giving me the
following error,
?The permissions granted to user ?OLDSERVER\Guest' are insufficient
for performing this operation. (rsAccessDenied)
As a solution to the problem of permissions in the help it's mentioned
that we need to create roles in the SQL Server Report Manager for the
users whom we need to give access to the reports.When we are accessing
the reports from the network by default we are accessing the server as
guests who doesn't have much rights.So I have created role (Browser )
on SQL Server Report Manager for the guest user and tried accessing
the server.
Then it's giving the following error
The Error Log description for the error was as follows,
aspnet_wp!library!cd4!10/13/2004-21:48:41:: e
ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for
more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server.
See the error log for more details. -->
System.InvalidOperationException: Computer name could not be obtained.
at System.Environment.get_MachineName()
at Microsoft.ReportingServices.Diagnostics.RunningJobContext..ctor(String
jobId, String requestPath,
JobActionEnum action, JobTypeEnum type, RunningJobList parentList,
String userName, HttpContext
optionalWebCtx)
at Microsoft.ReportingServices.Diagnostics.RunningJobList.AddJob(String
jobId, String requestPath,
JobActionEnum action, JobTypeEnum type, String userName, HttpContext
optionalCtx)
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase..ctor(String
jobId, String requestPath,
JobActionEnum action, JobTypeEnum jobType, String userName)
at 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, JobTypeEnum jobType, String userName)
at Microsoft.ReportingServices.Library.RSService.GetReportParametersForRendering(CatalogItemContext
reportContext, Guid reportID, Guid linkID, DateTime historyDate,
Int32 executionOption, ReportSnapshot
compiledDefinition, ReportSnapshot snapshotData, String
savedParametersXml, NameValueCollection values,
JobTypeEnum jobType)
at Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
report, String historyID, Boolean
forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
at Microsoft.ReportingServices.Library.RSService.GetReportParameters(String
report, String historyID, Boolean
forRendering, NameValueCollection values,
DatasourceCredentialsCollection credentials)
-- End of inner exception stack trace --
aspnet_wp!webserver!cd4!10/13/2004-21:48:41:: e ERROR:
Reporting Services error
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log
for more details. -->
System.InvalidOperationException: Computer name could not be obtained.
Thanks in Advance,
RajeshTake a look at
http://msdn.microsoft.com/library/en-us/rswork/htm/rms_security_v1_10bm.asp
. Try using built-in accounts Everyone or Users instead of Guest.
--
-- "This posting is provided 'AS IS' with no warranties, and confers no
rights."
jhmiller@.online.microsoft.com
"Rajesh" <rajeshkchandran@.gmail.com> wrote in message
news:cad1e70a.0410201456.280c018f@.posting.google.com...
> Hi,
> We have a network of XP Machines.
> When i try to view the reports in the application from the same
> machine itself it's coming up properly,but when i try to acess the
> reports in the application from another machine it's giving me the
> following error,
> 'The permissions granted to user 'OLDSERVER\Guest' are insufficient
> for performing this operation. (rsAccessDenied)
> As a solution to the problem of permissions in the help it's mentioned
> that we need to create roles in the SQL Server Report Manager for the
> users whom we need to give access to the reports.When we are accessing
> the reports from the network by default we are accessing the server as
> guests who doesn't have much rights.So I have created role (Browser )
> on SQL Server Report Manager for the guest user and tried accessing
> the server.
> Then it's giving the following error
> The Error Log description for the error was as follows,
> aspnet_wp!library!cd4!10/13/2004-21:48:41:: e
> ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more details., ;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server.
> See the error log for more details. -->
> System.InvalidOperationException: Computer name could not be obtained.
> at System.Environment.get_MachineName()
> at
> Microsoft.ReportingServices.Diagnostics.RunningJobContext..ctor(String
> jobId, String requestPath,
> JobActionEnum action, JobTypeEnum type, RunningJobList parentList,
> String userName, HttpContext
> optionalWebCtx)
> at Microsoft.ReportingServices.Diagnostics.RunningJobList.AddJob(String
> jobId, String requestPath,
> JobActionEnum action, JobTypeEnum type, String userName, HttpContext
> optionalCtx)
> at
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase..ctor(String
> jobId, String requestPath,
> JobActionEnum action, JobTypeEnum jobType, String userName)
> at
> 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, JobTypeEnum jobType, String userName)
> at
> Microsoft.ReportingServices.Library.RSService.GetReportParametersForRendering(CatalogItemContext
> reportContext, Guid reportID, Guid linkID, DateTime historyDate,
> Int32 executionOption, ReportSnapshot
> compiledDefinition, ReportSnapshot snapshotData, String
> savedParametersXml, NameValueCollection values,
> JobTypeEnum jobType)
> at
> Microsoft.ReportingServices.Library.RSService._GetReportParameters(String
> report, String historyID, Boolean
> forRendering, NameValueCollection values,
> DatasourceCredentialsCollection credentials)
> at
> Microsoft.ReportingServices.Library.RSService.GetReportParameters(String
> report, String historyID, Boolean
> forRendering, NameValueCollection values,
> DatasourceCredentialsCollection credentials)
> -- End of inner exception stack trace --
> aspnet_wp!webserver!cd4!10/13/2004-21:48:41:: e ERROR:
> Reporting Services error
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log
> for more details. -->
> System.InvalidOperationException: Computer name could not be obtained.
>
> Thanks in Advance,
> Rajesh

No comments:

Post a Comment