Error installing SQL 2008 July CTP

During my first install.

- on a XP SP2 machine.

- no SQL 2000 or 2005 installed.

- Uninstalled SQL 2005 workstation components.

Error:

TITLE: Microsoft SQL Server 2008 Setup

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

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=10.0.1049.14&EvtSrc=setup.rll&EvtID=29547&EvtType=sqlca%5csqlxmlca.cpp%40Do_sqlCopyXML%40Do_sqlCopyXML%40x80004005

From that link:

Details
ID: 29547
Source: setup.rll

We're sorry
There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time. You can use the links in the Support area to determine whether any additional information might be available elsewhere.

It appeared to be during:

workstation components, booksonline step:

--"upgrading Microsoft Report Server"

Image here:

Further on this:

-- My 1st install had all components selected: SQL DB Engine, SSIS, SSRS, SSAS, Workstation Components.

I did a second install with only DB engine selected - this completed successfully.

I then tried something install workstation components as standalone, and had what appears to be exactly the same error.

From the summary log:

--
Machine : WANDERER
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 : WANDERER
Product : Microsoft SQL Server 2008 Tools
Product Version : 10.0.1049.14
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\LOG\Files\SQLSetup0005_WANDERER_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
--

And from the LOG install, the following ERROR or FAIL message:

--1:

<Func Name='GetXMLAttributeValue'>
Error to find XML node /configuration/system.web/compilation
<EndFunc Name='GetXMLAttributeValue' Return='2' GetLastError='0'>
Failed to get ModuleID_RS_Server when getting the ASP Temp directory.

--2:

<Func Name='Do_sqlCopyXML'>
_LoadXMLFile(C:\Program Files\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: Tue Jul 24 04:08:57 2007
Function Name: Do_sqlCopyXML
Source Line

Number: 863

- Context --

Setting status of unmanaged components and removing unmanaged resources

Error Code: -2147467259
MSI (s) (3C!18) [19:49:54:703]: Product: Microsoft SQL Server 2008 Tools -- 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
<EndFunc Name='LaunchFunction' Return='-2147467259' GetLastError='203'>

--3:

MSI (s) (3C:00) [19:50:07:562]: Product: Microsoft SQL Server 2008 Tools -- Installation failed.

--

I've naturally allowe the error reports tog et sent in.

anyone have any suggestions as to possible problem/resolutions?

|||I had a problem on a re-install, and found the error output equally unsatisfying.
I decided that my best chance was for a complete installation. The chances were not good that something this fragile would work in a partial install situation.
I had three main issues. Some of these issues may apply to your problem.
The service control program conflict really threw me.
1) SQL Server uninstall may not remove a registry key indicating that it is still installed.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL
2) SQL Server uninstall may not remove the service control program, which shows up in Control Panel|Services.
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER
3) Data (even the ssrs database) from a previous server may fail the installation.
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
Good Luck
|||Hi Regan,

We have had the same problem. We removed all of SQL Server 2005 and then installed SQL Server 2008. All went well until the install of the Workstation Components which failed with error -2147467259 which a number of forum users have encountered. We then tried installing the various tools components using the individual .msi installers. This failed with a variety of error messages.
We next selected Control Panel, Programs and Features, Microsoft SQL Server 2008, Change and WorkStation Components. This makes it possible to update the Work Station components. The update failed with the same -214... error until, as suggested by another forum member, we removed Business Intelligence Development Studio from the update. Actually, as we did it, we only installed the Management Tools. The installation now completed without errors and SQL 2008 seems to be running properly.|||

Robbiex wrote:

Hi Regan,

We have had the same problem. We removed all of SQL Server 2005 and then installed SQL Server 2008. All went well until the install of the Workstation Components which failed with error -2147467259 which a number of forum users have encountered. We then tried installing the various tools components using the individual .msi installers. This failed with a variety of error messages.
We next selected Control Panel, Programs and Features, Microsoft SQL Server 2008, Change and WorkStation Components. This makes it possible to update the Work Station components. The update failed with the same -214... error until, as suggested by another forum member, we removed Business Intelligence Development Studio from the update. Actually, as we did it, we only installed the Management Tools. The installation now completed without errors and SQL 2008 seems to be running properly.

Thanks Robbie. I've phased across to testing using the new virtual server setup (after the 2GB download), and I plan to hold off a CTP or 2 for a hopefully more stable installer...

sql