• Post Categories

  • Browse Blogs

  • Blog Stats

    • 450,649 hits
  • Syndications

    SQLServerPedia Contributor

SSRS Error: Report Preview displays Access to the path ‘…\bin\Debug\Report.rdl’ is denied

While working on Reporting Services at a client site I came across this error when trying to preview a report in BIDS:

The report preview failed because the report could not be built. Read the errors, warnings and messages in the Error List window for specific build failures.

An error was raised in the Error List window below with the following message:

Access to the path ‘C:\Users\Jose\Documents\Visual Studio 2008\Projects\Report Project\bin\Debug\Report.rdl’ is denied

The root cause why this happens is unclear to me, but it seems that the Debug folder’s permissions get changed to Read Only for no apparent reason as can be seen on the screenshot below:

The workaround is to uncheck the Read-only attribute checkbox for the entire Debug folder or simply delete the Debug folder. BIDS will recreate this folder when you click on the Preview tab. If I come up with the root cause of this issue I will update this post.

The development environment is:
– VMWare virtual machine
– Windows Server 2008-R2 64-bit
– SQL Server Reporting Services 2008-R2 64-bit

23 Responses

  1. Subscribing . . . I hope you find a resolution.

    I run into this occasionally – it’s seriously annoying.

    Not sure if you use TFS, but wondering if that is causing the issue . . .

  2. I had the same issue and I was also having VSS 2005 for source control. If you check out the report, then this issue doesn’t happen for sure. It’s only when you try to edit a report which is checked in (it used to work till SQL Server 2008 without any issue).

  3. I am facing the exact same problem, every time it build all reports in bin folder have “read only” attribute set. No matter how many times I clear this it become read only again… Tried deletingthe bin folder, checking permision… Checked Bin folder isn’t in source control

    nothing works

  4. I’m seeing this issue too – am using TFS w/ SQL Server 2008 R2.

    Thanks for posting a workaround. Saved me some time & grief! =)

  5. I am seeing this issue using VB 2010 Professional. Not using SQL or other database. Just writing a normal windows form program. This just started. I am using Windows 7 Ultimate.

  6. When the error message box appeared for me (I’m using VS 2008 SP1), under errors, warnings and messages there was nothing. I unchecked the read only box and was able to preview the report.

  7. i am also facing the same issue let me know the solution for this its urgent

  8. My entire team of report developers are all facing this same issue. We have tried the work a rounds and no matter how many times we clear the attribute, it gets reset to read only. It is frustrating and time consuming when we are working on a production deadline.

    Nothing seems to work here on a permanent basis. Please let me know when you find a solution for this. Its urgent. Thank you.

  9. I also had the same problem and am using TFS and SS 2008 R2. The workarounds did not work for me but I stumbled upon a solution. ** Check in the report and then click on build.**
    Now the report is displaying correctly in the Preview tab.

  10. Thanks for the Solutions!!! It can be a pain in the butt!!!

  11. Hey Joe,

    Initially this was annoying because I would go into the Properties of the bin folder and unset “Read-Only”, Apply the changes and then click on Save. Going back into Properties and I would find that “Read-Only” would have automatically been set again.

    Out of pure frustration, I deleted the bin folder and ran the preview of the report in Visual Studio 2008 (SSRS).

    No errors😀

    Running the preview of the report recreates the bin folder and you get no errors.

    Hope this was helpful to all of you.
    Thanks,

  12. This is obviously a bug, it would be nice if it would get fixed.

  13. thanks..deleted the bin🙂

  14. I was getting really frustrated with this same problem this morning. The folder permissions immediately reset, if not simply ignored, the removal of the Read Only. Solution was to uncheck read only at the C:\Directory\ level, which then actually propagated down and allowed me to render the report again.

  15. check it out of source control first and you’ll find you won’t have that problem

  16. Works like magic , thank you so much.

    When you are using Visual Studio TFS, the Debug folder’s permissions get changed to Read Only most probably because you didn’t check the project out for edit and trying to preview the report to view it with out that option !

  17. Thanks mate, you saved me!

  18. Thank you!!! Thank you!!! Thank you!!!! This worked!!!

  19. Its simple. Just rebuild your project and it automatically shall replace the folder.

  20. Obrigada! Funcionou

  21. Obrigada! Funcionou….

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: