CTP4 Installation Issue with VS2010 Service Pack 1

CTP4 Installation Issue with VS2010 Service Pack 1

Rate This
  • Comments 5

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 a 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

2. Apply the Visual Studio 2010 Service Pack 1 (SP1)

3. Run SQL Server 2012 setup and install SQL Server Management Tools (SSMS)

4. Attempt to install SSDT CTP4

Installation of SSDT CTP4 in step 4 of this sequence should be successful, as Visual Studio 2010 Service Pack 1 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 Visual Studio 2010 Service Pack 1. You may already have downloaded VS2010 SP1 and have it available for reapplication. If you don't, you can download it 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.

 

While not suggested, an alternative workaround does exist. If you are certain that you have VS2010 SP1 installed on your machine already yet you are still receiving this error, do the following using regedit.exe :

On a 32-bit machine, set the value of the following registry key to 1:

Key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VS\Servicing\10.0

Name SP

Data = 0x00000001 (1)

On a 64-bit machine, set the value of the following registry key to 1:

Key HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\vs\Servicing\10.0

Name SP

Data = 0x00000001 (1)

 

Leave a Comment
  • Please add 1 and 5 and type the answer here:
  • Post
  • Hi Adam,

    How is this different to Visual Studio Database project that is avaialble to vs ultimate users.

    thanks,

    joey

  • They have replace it with SSDT SQL Server project - sqlserverselect.blogspot.com/.../ssdt-vs-vsdb.html.

  • Hi Joey,

    For more detail on the differences between VS2010 Database Projects and SSDT, check out this blog post: blogs.msdn.com/.../sql-server-data-tools-ctp4-vs-vs2010-database-projects.aspx

  • Hi,

    Has anyone had any problems using SSDT after installing SQL 2012 RC0?  I've installed RC0 with engine etc and also selected SSMS and SSDT but when trying to create a new table in SSDT I get the following error:

    "This server version is not supported.  Only servers up to Microsoft SQL Server 2008 are supported"

    This is on a PC with no other Visual Studio products at all.

    Thanks

  • Andy,

    Have you done a full installation of SSDT after installing RC0? If not, please do so via msdn.microsoft.com/.../hh297027.

    Thanks,

    Adam

Page 1 of 1 (5 items)