Error when connecting to Staging database using BIDS for SQL Server 2008 R2 - 'This server version is not supported'

Version 1

    Details

     

    We followed the instructions for downloading and connecting through Business Intelligence Development Studio to make reports. We were able to connect through BIDS with the test connection, but after that we were unable to get the data connection to show data in BIDS. The error message below is displayed.

    cid:image001.png@01D1F302.D3F4B950

    This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported.

     


    Resolution

     

    Please note that the current instructions for configuring SSRS/BIDS (BIDS_Final_Draft_2_9_2015.pdf ) give the link and instructions for configuring BIDS for SQL Server 2008 R2. Moving forward customers will need to install the SQL 2012 version. You can download Business Intelligence for SQL Server 2012 here: https://www.microsoft.com/en-us/download/details.aspx?id=36843