Unable to install SQL Server 2005 on a Windows XP machine

When we try to install SQL Server 2005 on a Windows XP with Service pack 3, we get the following error :

 

---------------------------
setup.exe - Application Error
---------------------------

The application failed to initialize properly (0xc0150004). Click on OK to terminate the application.

---------------------------
OK
---------------------------

We get this error message as soon as we click on the setup.exe file.


Resolution:

We can install the Dependancywalker tool and take a profiler trace in Dependancywalker. The steps are as below,  

1. Download link : https://www.dependencywalker.com

2. Open the Dependencywalker

3. Go to FILE —OPEN —Select the SETUP.EXE [Ex- C:\SQLServer 2005\Servers\setup.exe]

4. Go to PROFILE from the Menubar, select “Start Profiling(F7)”

5. Select the path to save “Starting directory”

6. Select the following 2 options along with the default selection and click OK

—Log first chance exceptions

—Use full paths when logging file names

7. Reproduce the Issue

8. Stop the profiling

—Go to PROFILE from the Menubar, select “Stop Profiling(Shift + F7)”

9. To save the trace

—Go to FILE—SAVE

10. Check the Log window for Errors. We should be seeing the following error :

- Error from Dependencywalker Log window

--------------------------------------------------------------------------------------------------------------------------------------------------

SXS: Unable to resolve storage root for assembly directory x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.4053_x-ww_e6967989 in 2 tries

SXS: RtlGetAssemblyStorageRoot() unable to resolve storage map entry. Status = 0xc0150004

SXS: Unable to resolve storage root for assembly directory x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.4053_x-ww_e6967989 in 2 tries

SXS: RtlGetAssemblyStorageRoot() unable to resolve storage map entry. Status = 0xc0150004

SXS: Unable to resolve storage root for assembly directory x86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.4053_x-ww_e6967989 in 2 tries

SXS: RtlGetAssemblyStorageRoot() unable to resolve storage map entry. Status = 0xc0150004

--------------------------------------------------------------------------------------------------------------------------------------------------

- From the above it is clear that its failing to resolve the storage root for assembly

    "Unable to resolve storage root for assembly directory x86_Microsoft.VC80.CRT 8.0.50727.4053"

Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.4053 points to ------> Microsoft Visual C++ 2005 version 8.0.50727.4053

So it’s clear that “Microsoft.VC80.CRT Version 8.0.50727.4053” is missing therefore we downloaded and installed the following:

“Microsoft Visual C++ 2005 Service Pack 1 Redistributable Package ATL Security Update".

https://www.microsoft.com/downloads/details.aspx?familyid=766a6af7-ec73-40ff-b072-9112bab119c2&displaylang=en

- After this we should be able to successfully install the SQL Server 2005 & apply the service pack.

By
Raghavendra Srinivasan
SE, Microsoft SQL server

Reviewed By,
Karthick Krishnamurthy
Tech Lead, Microsoft SQL Server