Friday, February 26, 2016

SQL Server 2014 surprises - ( missing SSDT)




After  installing   SQL Server 2014 ( fresh install) , I found out the SQL Server Data tools ( as called in SQL Server 2012)  /  SQL Server Business Intelligence Studio ( Pre SQL Server 2012 versions) is missing .

After few "google searches" , found a way to install to SSDT for SQL 2014.  Downloaded the installer from  Microsoft Downloads site ( https://www.microsoft.com/en-us/download/confirmation.aspx?id=42313 ) .

In my first attempt , check failed on me complaining on the rule "Same architecture installation ".  In this attempt , choose "Add features to an existing instance of SQL Server 2014".







I was able to get it to working by choosing "Perform a new installation of SQL Server 2014"



Why can't be this be bundled in the SQL Server install  as usual? I hope Microsoft changes its mind in bundling these features in SQL Server 2016 and beyond.