Juneau /SSDT/ SQL Server Data tools won’t install even with Visual Studio SP1 installed
Many people have reported that you can’t install the CTP4 of Juneau/SQLServer Data Tools (SSDT) even though you already have Visual Studio SP1 installed.
The problem is the install for SSDT requires Visual Studio SP1 and if it can’t find it, the setup tells you to install it. But you have it installed so what can you do?
Well the team have found one cause of this problem and have detailed in this blog post
For your ease I’ve copied the supported resolution here
“Since the release of SSDT CTP4, we have become aware of an installation issue dealing with Visual Studio 2010 Service Pack 1. We are working on a fix, but below is temporary workaround that can be employed to successfully install SSDT CTP4.
Symptom: When attempting to install SSDT, you will receive an error, stating the following, “You have to upgrade your Visual Studio 2010 to SP1 before installing SQL Server Data Tools,” even when you have previously taken steps to install SP1.
We have identified the primary scenario in which this error is wrongfully encountered:
1. Install VS2010 Professional or above from the install media
2. Install full VS2010 SP1
3. Install SQL Server 2012 setup, including Management Tools
4. Attempt to install SSDT CTP4
Installation of SSDT CTP4 in step 4 of this sequence should be successful, as VS2010 SP1 is applied when SQL Server Management Tools are installed. However, due to an issue in the application of SP1, you will indeed be blocked from installing CTP4.
The suggested workaround for this scenario is to reinstall VS2010 SP1 from http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=23691. Manually reapplying this pack will perform the necessary actions to repair this problem. After reinstalling SP1, you will then be able to successfully install SSDT CTP4.”
There is an unsupported solution but I will let you go to the blog post (http://blogs.msdn.com/b/ssdt/archive/2011/11/30/ctp4-installation-issue-with-vs2010-service-pack-1.aspx) to get those details.