Wednesday, March 28, 2012

Reporting Services Snapshots Access Denied

Hi guys,
I've set up a scheduled execution snapshots on a report; however, the
snapshot could only be viewed once. After the snapshot file being created on
rstempfiles directory, it cannot be acessed anymore. The error was 'Access to
path "C:\Program Files\Microsoft SQL Server\RSTempFiles\RSFile_da9ed300-e4a9-
4f7f-8ee7-48edf9ebedcd" is dnied.'
I've checked the security on the RSTempFiles directory and the snapshot file,
they both have users ASP.NET and SYSTEM with all permissions except the Full
Control permission.
Any help is appreciated.
Paul
--
Message posted via http://www.sqlmonster.comI think the login that the Reporting Services Services uses must also be
granted permissions on that directory..
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul L via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:54476CB0823F7@.SQLMonster.com...
> Hi guys,
> I've set up a scheduled execution snapshots on a report; however, the
> snapshot could only be viewed once. After the snapshot file being created
> on
> rstempfiles directory, it cannot be acessed anymore. The error was 'Access
> to
> path "C:\Program Files\Microsoft SQL
> Server\RSTempFiles\RSFile_da9ed300-e4a9-
> 4f7f-8ee7-48edf9ebedcd" is dnied.'
> I've checked the security on the RSTempFiles directory and the snapshot
> file,
> they both have users ASP.NET and SYSTEM with all permissions except the
> Full
> Control permission.
> Any help is appreciated.
> Paul
>
> --
> Message posted via http://www.sqlmonster.comsql

No comments:

Post a Comment