A very common request and question is (as I have to confess that this is confusing) is which version of SQL Server (SSMS - SQL Server Management Studio, BIDS - Business Intelligence Development Studio, VS- Visual Studio) does works together with which version of SQL Sever which target version and which project type. Here is a complete list to be updated through the versions of SQL Sever and the lifecycle of Visual Studio:

 

Visual Studio 2005

 

 

Visual Studio 2008

Visual Studio 2010

Visual Studio 2012

Visual Studio 2013

Framework

.NET 2.0

.NET 2.0

.NET 3.0

.NET 3.5

.NET 2.0

.NET 3.0

.NET 3.5

.NET 4.0

.NET 2.0

.NET 3.0

.NET 3.5

.NET 4.0

.NET 4.5

.NET 2.0

.NET 3.0

.NET 3.5

.NET 4.0

.NET 4.5

SSDT / SQL tooling in Visual Studio (built into VS, non-BI) N/A N/A N/A SQL 2005 - SQL 2014 inclusive SQL 2005 - SQL 2014 inclusive
BIDS overall compat.
(SSRS, SSIS, SSAS)
SQL 2005 SQL 2008/R2 SQL 2012 SQL 2012

SQL 2014

SSRS         SQL 2008R2 - SQL 2014
SSAS         SQL 2008R2 - SQL 2014
SSIS         SQL 2014

-Jens