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

Reporting Services Error - SQL Server does not exist or access denied

Hi, I am unable to view my reports once deploying them. The error I get in Report Manager is SQL "Server does not exist or access denied". What is weird about this is that I am able to run the reports within the preview tab (in visual studio .net 2003). When I try to use the same connection string in Report Manager I get the error. Please note that I deploy the reports from my computer onto a different server where I am trying to access them. This problem started after installing some critical windows updates onto my local computer and it is driving me crazy. If anyone could suggest a course of action it would be greatly appreciated - so far I have not been able to make sense of what the problem is.
Thanks.Problem Solved - the database was using port 2433 - so i just changed that in my connection string.