Error: Another Version of Microsoft Visual Studio 2008 has been Detected on this System that must be Updated to SP1

Error: Another Version of Microsoft Visual Studio 2008 has been Detected on this System that must be Updated to SP1

book

Article ID: CTX128280

calendar_today

Updated On:

Description

While attempting to install the SQL database and management tools from Microsoft on Windows 2008 R2 server that has XenApp 6.0 or later version installed, the following error occurs:

“Another version of Microsoft Visual Studio 2008 has been detected on this system that must be updated to SP1. Please update all Visual Studio 2008 installations to SP1 level, by visiting Microsoft update.”
User-added image

The following table provides information about where the installation of SQL 2008 database and management tools fails.

Machine Type

SQL 2008 database and management tools: Install

XenApp Installed, Configured on Windows 2008 R2 using SQL Express as data store

Fails

XenApp Installed, Configured on Windows 2008 R2 using SQL Enterprise as data store

Fails

XenApp Installed, SQL NOT Configured on Windows 2008 R2

Fails

Clean Windows 2008 R2 with no XenApp installed

Success

 

Resolution

Citrix recommends installing the SQL database and management tools on a machine that does not have XenApp installed. After the database and management tools have been installed, connect to the specific database instance by using the Microsoft SQL Server Management Studio.
User-added image

Alternative Installation

Run the following command, after installing XenApp 6.0 or later:

msiexec /i D:\x64\Setup\vs_shell.msi PATCH=D:\x64\Setup\VS90sp1-KB945140.msp /qb (where D:\ is the location of your SQL media)

The other known workaround to get the SQL database and management tools installed on the same computer which is running XenApp 6.0 or later is to use the following registry edit.

Caution! Refer to the Disclaimer at the end of this article before using Registry Editor.

  1. Open the Registry on XenApp machine using Start > Run > Regedit.

  1. Browse for HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS.

  1. Rename this key to VS_1 or a similar name.

  1. Install the SQL database and management tools.

  1. Rename 
    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS_1
    to 
    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS

  1. Restart the XenApp machine.

  1. Navigate to Start > All programs > Microsoft SQL Server 2008 > SQL Server Management Studio and connect to your database instance.
    User-added image

Issue/Introduction

This article contains information to successfully install the SQL database and management tools from Microsoft on a Windows 2008 R2 server that has XenApp 6.0 or later installed.
Powered by Wolken Software