If I have BIDS for SQL Server 2008R2 and want BIDS for 2008, how install?


  • There is always a message regarding upgrading the ssrs project when opening what I presume is a 2008 SSRS project in what I presume is 2008R2 BIDS/VS. (It's very hard to understand the versions of the rdl file and what it wants to upgrade to, so I'm assuming here) But we don't want to upgrade - the production server is running 2008 reports. So I want SQL 2008 BIDS/VS on my machine to open the 2008 report project and not be prompted to upgrade. Is this possible? Seems to be a hullava headache. Running sql server 2008 feature install the flag for BIDS is already selected (and grayed out). So what do I run or install in order to open a 2008 report project on my machine with 2008R2 BIDS/VS already installed? Any solid help appreciated.


    Monday, March 10, 2014 9:53 PM


  • Hi AskMarkus,

    In SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS) is Microsoft Visual Studio 2008 with additional project types that are specific to SQL Server business intelligence. Both Reporting Services 2008 version of BIDS and Reporting Services 2008 R2 version of BIDS are integrated in Visual Studio 2008.

    If we install SSRS 2008 R2 on our machine (the machine has been installed SSRS 2008), the version of BIDS will automatic upgrade to BIDS 2008 R2. So, we will use BIDS 2008 R2 to design reports, view reports, and so on.

    Reporting Services 2008 R2 version of BIDS supports working with both SQL Server 2008 and SQL Server 2008 R2 reports, and we can use Reporting Services 2008 R2 version of BIDS deploy either version of reports or Report Server projects.
    Reference: Introducing Business Intelligence Development Studio

    Alisa Tang

    Alisa Tang
    TechNet Community Support

    Friday, March 14, 2014 11:04 AM