Error installing Visual Studio 2008 Service Pack 1

While installing Service Pack 1 for Visual Studio 2008 Team Test Load Controller ENU its failing with the below error message in the Install Log:

Log Snippet:

MSI (s) (D8:88) [10:49:01:243]: Transforming table Binary.

MSI (s) (D8:88) [10:49:01:243]: Note: 1: 2262 2: Binary 3: -2147287038

MSI (s) (D8:00) [10:49:01:259]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSIAF.tmp, Entrypoint: GetSQLInstanceId

MSI (s) (D8:28) [10:49:01:259]: Generating random cookie.

MSI (s) (D8:28) [10:49:01:259]: Created Custom Action Server with PID 1916 (0x77C).

MSI (s) (D8:4C) [10:49:01:275]: Running as a service.

MSI (s) (D8:4C) [10:49:01:275]: Hello, I'm your 32bit Impersonated custom action server.

Action start 10:49:01: CA_GetSQLInstanceId.

MSI (s) (D8:88) [10:49:01:681]: Transforming table InstallExecuteSequence.

MSI (s) (D8:88) [10:49:01:681]: Transforming table InstallExecuteSequence.

MSI (s) (D8:88) [10:49:01:681]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038

Action ended 10:49:01: CA_GetSQLInstanceId. Return value 3.

Action ended 10:49:01: INSTALL. Return value 3.

Property(S): DiskPrompt = [1]

Property(S): UpgradeCode = {9E906A11-9706-373E-ADE9-693555097942}

Property(S): SystemFolder = C:\WINDOWS\SysWOW64\

Property(S): WindowsFolder_x86.3643236F_FC70_11D3_A536_0090278A1BB8 = C:\WINDOWS\

Property(S): SystemFolder_x86.3643236F_FC70_11D3_A536_0090278A1BB8 = C:\WINDOWS\SysWOW64\

Property(S): VersionNT = 502

Event Viewer:

EventType spinstaller, P1 microsoft visual studio 2008 sp1, P2 i, P3 1603, P4 dte90sp1-kb950425-enu.msp, P5 e, P6 9.0.30703.1, P7 1, P8 9.0.30729 1033, P9 x64_win2k3r2, P10 0.

Product: Microsoft Visual Studio 2008 Team Test Load Controller- ENU - Update 'KB950425' could not be installed. Error code 1603. Additional information is available in the log file C:\DOCUME~1\SayalaSu\LOCALS~1\Temp\Microsoft Visual Studio 2008 SP1_20080926_110206020-Microsoft Visual Studio 2008 Team Test Load Controller- ENU-MSP0.txt.

Screen Shots:

clip_image002

clip_image002[4]

image

Root Cause Identified:

2.1.6 SQLPubWiz 1.2 fails to be installed on Visual Studio 2008 SP1

SQL Publishing Wizard cannot be installed in Visual Studio side-by-side installations.
SQL Publishing Wizard installation fails when you try to install a version of Visual Studio 2008 or Visual Web Developer Express 2008 on a computer where the service pack of these products is already installed. This is because Visual Studio 2008 SP1 installs a later version of SQL Publishing Wizard than the one that is included in Visual Studio 2008 or Visual Web Developer Express 2008, and SQL Publishing Wizard will not be installed if a later version is detected.

Existing scenarios include:
Attempting to install Visual Studio 2008 English on a computer that has Visual Web Developer SP1 English already installed. Attempting to install Visual Studio 2008 Japanese on a computer that has Visual Studio 2008 SP1 English or Visual Web Developer SP1 English already installed. The Setup program will finish and display this error message: "The following component failed to install: Microsoft SQL Publishing Wizard." However, both products will work with no loss of functionality.

Resolution:

Uninstall SQL Web Developer Web Edition from control panel and then try installing the service pack 1 for Visual Studio 2008.