Monday, March 19, 2012

An internal error occurred on the report server. See the error log

I've just installed SQL Reporting Services. I have a Report Project in
Visual Studio and added already existing reports. When I try to build the
solution, I get the following error for each report:
An internal error occurred on the report server. See the error log for more
details.
Looking in the Windows Event Viewer, there are no entries that correspond to
this. The most recent entry is an hour ago, even though I got this error
message two minutes ago.
Am I looking in the wrong place? Does anyone have any other suggestions as
to why this won't work?
BTW: I also tried to upload the report on the reportserver. When I try to
run a report from there, I get a similar error:
An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
SELECT permission denied on object 'ExecutionCache', database
'ReportServerTempDB', owner 'dbo'. SELECT permission denied on object
'ExecutionCache', database 'ReportServerTempDB', owner 'dbo'. SELECT
permission denied on object 'SnapshotData', database 'ReportServerTempDB',
owner 'dbo'.
Thank you in advance,
MKFigured it out! I had already set the permissions for the ASPNET user in the
ReportServer table to allow RSExecRole... just had to do the same for the
ReportServerTempDB
"k89mmk" wrote:
> I've just installed SQL Reporting Services. I have a Report Project in
> Visual Studio and added already existing reports. When I try to build the
> solution, I get the following error for each report:
> An internal error occurred on the report server. See the error log for more
> details.
> Looking in the Windows Event Viewer, there are no entries that correspond to
> this. The most recent entry is an hour ago, even though I got this error
> message two minutes ago.
> Am I looking in the wrong place? Does anyone have any other suggestions as
> to why this won't work?
> BTW: I also tried to upload the report on the reportserver. When I try to
> run a report from there, I get a similar error:
> An internal error occurred on the report server. See the error log for more
> details. (rsInternalError) Get Online Help
> SELECT permission denied on object 'ExecutionCache', database
> 'ReportServerTempDB', owner 'dbo'. SELECT permission denied on object
> 'ExecutionCache', database 'ReportServerTempDB', owner 'dbo'. SELECT
> permission denied on object 'SnapshotData', database 'ReportServerTempDB',
> owner 'dbo'.
> Thank you in advance,
> MK|||k89mmk wrote:
> An internal error occurred on the report server. See the error log
> for more details. (rsInternalError) Get Online Help
> SELECT permission denied on object 'ExecutionCache', database
> 'ReportServerTempDB', owner 'dbo'. SELECT permission denied on object
> 'ExecutionCache', database 'ReportServerTempDB', owner 'dbo'. SELECT
> permission denied on object 'SnapshotData', database
> 'ReportServerTempDB', owner 'dbo'.
You will find the reporting-logs normally in:
C:\Programme\Microsoft SQL Server\MSSQL\Reporting Services\LogFiles
Your error assumed that you use nt-authentification and your nt-account has
no sufficient rights on the ReportServer-DBs OR the account under wich the
reportenginge is running has no sufficient rights on his own dbs
regards
Frank
www.xax.de

No comments:

Post a Comment