FIX: Report server project error in a build, clean, or preview operation in SQL Server 2008 R2 BIDS

Article translations Article translations
Article ID: 2452564 - View products that this article applies to.
Microsoft distributes Microsoft SQL Server 2008 R2 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 fix release.
Expand all | Collapse all

On This Page

SYMPTOMS

Consider the following scenario:
  • You install Microsoft Visual SourceSafe (VSS) on a computer that has Microsoft SQL Server 2008 R2 Business Intelligence Development Studio (BIDS) installed.
  • You click to select the Add to Source Control check box while you create a new report server project in BIDS.

    Note You can create the report server project by selecting the Report Server Project or Report Server Project Wizard template in the New Project dialog box.
  • The TargetServerVersion property of the report server project is set to SQL Server 2008 R2.
  • You check out an .rdl file, and then you check in the .rdl file in BIDS or in VSS.
  • You try to build, clean, or preview the project in BIDS.

In this scenario, you receive the following error message, and the project is not built, cleaned, or previewed:
Access to the path '<RDL Path>' is denied.

CAUSE

This issue occurs because the files are marked as read-only when you use VSS.

When you build the project for the first time, BIDS copies the project files to the following path and then sets the files to read-only:
<Report Server Project Folder>\bin\Debug folder
However, BIDS tries to change the read-only files. Therefore, an access error occurs.

Note<Report Server Project Folder> is a placeholder for the folder name where the report server project is stored.

RESOLUTION

Cumulative update information

Cumulative Update 5 for SQL Server 2008 R2

The fix for this issue was first released in Cumulative Update 5. For more information about how to obtain this cumulative update package for SQL Server 2008 R2, click the following article number to view the article in the Microsoft Knowledge Base:
2438347 Cumulative Update package 5 for SQL Server 2008 R2
Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
981356 The SQL Server 2008 R2 builds that were released after SQL Server 2008 R2 was released

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

WORKAROUND

To work around this issue, use one of the following methods:
  • Use another folder for the output path of the report server project instead of the following folder:
    <Report Server Project Folder>\bin\Debug folder"
  • Delete the .rdl file in the current output path of the report server project.

Properties

Article ID: 2452564 - Last Review: December 20, 2010 - Revision: 1.0
APPLIES TO
  • Microsoft SQL Server 2008 R2 Reporting Services
Keywords: 
kbqfe kbexpertiseadvanced kbsurveynew kbfix KB2452564

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com