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.
This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported.
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