Sql-server – Connect SQL Server 2016 SSDT with TFS

I had a similar problem with my installation of VS 2012 (Premium). I installed VS 2012, at the custom installation options screen I chose the option for SSDT, but when actually using it, it was really absent (same error as yours).

My idea is that the default installer only adds the template for the project, but not SSDT itself. I also had to install SSDT separately (in this case only for VS 2012) and it worked (SSDT for VS 2010 is necessary only if you want to open SQL projects in VS 2010, but I guess you know that already).

In my case, I had Visual Studio 2010 Enterprise on my system when I initiated the setup for SQL Server 2012 Standard. After the SQL 2012 got underway, it stopped and prompted for the VS 2010 setup.msi. At that point, I ejected the SQL Server disc and inserted the VS 2010 setup disc. Then I used the dialog presented by the SQL Server 2012 setup program to browse to the root of the VS 2010 DVD, selected the msi there, and opened it. The SQL 2012 setup continued and when I saw that it was again installing SQL components (rather than VS 2010 components), I ejected the VS 2010 disc (which caused the SQL 2012 setup program to display an error that there was no disc in the drive), placed the SQL 2012 setup disc back into the drive, then clicked the Try Again button. At that point, SQL Server 2012 resumed and after some time it completed successfully.