Access to snapshot tempfiles is denied

I take a snapshot of a report an it views fine the first time but I get the
following error on subsequent viewings:
An internal error occurred on the report server. See the error log for more
details. (rsInternalError) Get Online Help
Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\RSTempFiles\RSFile_6b4351c3-0cfb-4c51-bda1-ac280f1d7eea" is denied.
where the name of the file changes when i re-snapshot it. I've checked the
permissions on the RSTempFiles folder and both the System and ASPNET have
Full Control over it.
Any ideas why this is still happening?
TIA,
Dan Fell.Has anyone solved this issue? I am having the same exact problem with users
who are browsers.
"Dan Fell" wrote:
> I take a snapshot of a report an it views fine the first time but I get the
> following error on subsequent viewings:
> An internal error occurred on the report server. See the error log for more
> details. (rsInternalError) Get Online Help
> Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\RSTempFiles\RSFile_6b4351c3-0cfb-4c51-bda1-ac280f1d7eea" is denied.
> where the name of the file changes when i re-snapshot it. I've checked the
> permissions on the RSTempFiles folder and both the System and ASPNET have
> Full Control over it.
> Any ideas why this is still happening?
> TIA,
> Dan Fell.|||I am having the same exact problem too with snapshots but it doesn't
happen with all the reports. I am assuming that it's a new issue with
reporting services SP2, because snapshots always worked for me prior to
upgrading to SP2. Any help is greatly appreciated. Thanks.
T Robichaux wrote:
> Has anyone solved this issue? I am having the same exact problem with users
> who are browsers.
> "Dan Fell" wrote:
> >
> > I take a snapshot of a report an it views fine the first time but I get the
> > following error on subsequent viewings:
> >
> > An internal error occurred on the report server. See the error log for more
> > details. (rsInternalError) Get Online Help
> > Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> > Services\RSTempFiles\RSFile_6b4351c3-0cfb-4c51-bda1-ac280f1d7eea" is denied.
> >
> > where the name of the file changes when i re-snapshot it. I've checked the
> > permissions on the RSTempFiles folder and both the System and ASPNET have
> > Full Control over it.
> >
> > Any ideas why this is still happening?
> >
> > TIA,
> >
> > Dan Fell.|||I had the same Problem: Only one of many reports with the same settings
as the others (render with temporary copy for 30 min) creates always a
file in the RSTempFiles Folder.
I checked the Readme Files and found that since SP1 (section 4.4.4 New
Configuration Settings in sp2Readme_EN.htm) there are settings for
FileSharing.
I added the settings to the configuration
...
<Add Key="WebServiceUseFileShareStorage" Value="false" />
...
<WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>
<FileShareStorageLocation>
<Path> XXXXX </Path>
</FileShareStorageLocation>
but it still creates the temporary file. You can see that the settings
are regarded when you change the Path. Then the tempfile is placed there
and the errormessage shows the access denied for this path. Either the
setting for the useFileShare = false is ignored or there is some other
setting (in the report?) which "overwrites" the setting.
WORKAROUND:
I gave read permission to everyone on the folder
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles
and it works.
System:
SQL Server 2000, Reporting Services SP2 on as w2k Server, Windows 2003
AD, Integrated Security for SQLServer and IIS, mixed language (englisch,
german) for OS and Applications.
I hope the workaround helps and I still wait for a better solution or
explanation for this file creation.
Best regards,
Markus Mahlitz
Vasu Bojja schrieb:
> I am having the same exact problem too with snapshots but it doesn't
> happen with all the reports. I am assuming that it's a new issue with
> reporting services SP2, because snapshots always worked for me prior to
> upgrading to SP2. Any help is greatly appreciated. Thanks.
>
> T Robichaux wrote:
>> Has anyone solved this issue? I am having the same exact problem with users
>> who are browsers.
>> "Dan Fell" wrote:
>> I take a snapshot of a report an it views fine the first time but I get the
>> following error on subsequent viewings:
>> An internal error occurred on the report server. See the error log for more
>> details. (rsInternalError) Get Online Help
>> Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
>> Services\RSTempFiles\RSFile_6b4351c3-0cfb-4c51-bda1-ac280f1d7eea" is denied.
>> where the name of the file changes when i re-snapshot it. I've checked the
>> permissions on the RSTempFiles folder and both the System and ASPNET have
>> Full Control over it.
>> Any ideas why this is still happening?
>> TIA,
>> Dan Fell.
>