Submit My Question - Recent Questions - Recent Answer
Msdn Tech >> SQL Server Katmai >> SQL Server Katmai Manageability & Tools

JULY CTP (WORKSTATION COMPONENTS FAIL INSTALL)

AMD ATHLON 64-BIT

WINDOWS XP PRO X64 EDITION

SQL SERVER KATMAI X64 BIT INSTALLTION (JULY CTP)

I've been trying to install the WorkStation components from the JULY CTP. I previously had the JUNE CTP installed. The entire instllation of the database engine and integration services went fine. The workstation components failed. After this failure, I removed the JUNE CTP workstation components and rebooted the PC. I attempted to install JUST the workstation components and the install failed. I then UNINSTALLED all SQL Server components. ALL SQL 2005 and SQL KATMAI. Another reboot. On the 3rd attempt to install just the Workstation components, the install again failed. Here's the error (summary.txt)

Machine : 24331036PC
Product : Workstation Components, Books Online and Development Tools
Error : Upgrade Failed due to the following Error.The error code is :-2147467259.Message:Unspecified error
--
Machine : 24331036PC
Product : Microsoft SQL Server 2008 Tools (64-bit)
Product Version : 10.0.1049.14
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\LOG\Files\SQLSetup0009_24331036PC_Tools.log
Last Action : InstallFinalize
Error String : Upgrade Failed due to the following Error.The error code is :-2147467259.Message:Unspecified error
Error Number : 29547

MORE LOG INFO (SQLSetup.log)

Doing Action: Do_sqlCopyXML
PerfTime Start: Do_sqlCopyXML : Fri Aug 03 09:47:28 2007
<Func Name='Do_sqlCopyXML'>
_LoadXMLFile(C:\Program Files (x86)\Microsoft Visual Studio 8\Common7\IDE\devenv.exe.config).IID_IXMLDOMDocument->load returned 2147500037.
Error Code: -2147467259
Windows Error Text: Unspecified error
Source File Name: sqlca\sqlxmlca.cpp
Compiler Timestamp: Wed Jul 25 09:56:12 2007
Function Name: Do_sqlCopyXML
Source Line Number: 863

- Context --


Setting status of unmanaged components and removing unmanaged resources

Error Code: -2147467259
MSI (s) (58!1C) [09:47:35:841]: Product: Microsoft SQL Server 2008 Tools (64-bit) -- Error 29547. Upgrade Failed due to the following Error.The error code is :-2147467259.Message:Unspecified error

Error 29547. Upgrade Failed due to the following Error.The error code is :-2147467259.Message:Unspecified error

[2455 byte] By [SteveBouff] at [2008-2-11]
«« How to connect a custom hardware
»» How to build an Analysis Services project
# 1

Hmmm, something is still dirty on teh machine and it thinks the sql 2005 tools or the earlier 2008 tools are there, hence the "upgrade" messages.

If this is a test machine and you can take some risk, and you've really uninstalled everything, make sure HKLM/Software/Microsoft/Microsoft SQL Server isn't in the registry, make sure c:\program files\microsoft sql server isn't there on the hard drive, and of course before that make sure add/remove programs shows no sql server components.

RichardWaymire-MSFT at 2007-10-2 > top of Msdn Tech,SQL Server Katmai,SQL Server Katmai Manageability & Tools...
# 2

I removed the registry entries and SQL Server directory. Still no luck. I'm just going to rebuild this PC and start over.

SteveBouff at 2007-10-2 > top of Msdn Tech,SQL Server Katmai,SQL Server Katmai Manageability & Tools...
# 3

OK, good luck with that and sorry it's not easier.

My guess if you nuked those things is that the MSI registry isn't cleaned up. Unfortunately I don't know of a tool to clean this up.... Maybe someone else will jump in.

-Richard

RichardWaymire-MSFT at 2007-10-2 > top of Msdn Tech,SQL Server Katmai,SQL Server Katmai Manageability & Tools...
# 4

One of my team mate also faced similar issue.

Do you have Visual Studio installed on the drive other than C or not on the same drive as of SQL Server?

Not sure whether the workaround works for you.

Workaround : Copy the devenv.exe.config from the installed location of Visual Studio to C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv.exe.config

You can report this issue through MSDN product feedback center by selecting “Send Feedback” menu item under “Community” Menu in SQL Server Management Studio. You can also file bugs directly on http://connect.microsoft.com/sqlserver/feedback which will help you to track the status of the bug.

Regards,

Rajesh

RajeshNagpal-MSFT at 2007-10-2 > top of Msdn Tech,SQL Server Katmai,SQL Server Katmai Manageability & Tools...
SQL Server Katmai
SQL Server Katmai Manageability & Tools

SQL Server Katmai Hot Topic

SQL Server Katmai New Topic

SQL Server Katmai

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech

Site Classified