I got this error when I installed SQL Server 2005 SP2. I have searched
internet but there seems no solution yet. Can someone please with this
issue? Thank you.

Here is the error msg from summery.txt
--------------------------------------------------------
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 2047
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_s ql.msp.log
Error Number : 29537
Error Description : MSP Error: 29537 SQL Server Setup has
encountered the following problem: [Microsoft][SQL Native Client][SQL
Server]CREATE DATABASE failed. Some file names listed could not be created.
Check related errors.. To continue, correct the problem, and then run SQL
-------------------------------------------------------------------------------------------

And from SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
--------------------------------------------------------------------------------------
MSI (s) (1C:1C) [07:04:40:418]: Note: 1: 1729
MSI (s) (1C:1C) [07:04:40:418]: Transforming table Error.

MSI (s) (1C:1C) [07:04:40:418]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (1C:1C) [07:04:40:433]: Transforming table Error.

MSI (s) (1C:1C) [07:04:40:449]: Transforming table Error.

MSI (s) (1C:1C) [07:04:40:449]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (1C:1C) [07:04:40:449]: Transforming table Error.

MSI (s) (1C:1C) [07:04:40:449]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (1C:1C) [07:04:40:449]: Transforming table Error.

MSI (s) (1C:1C) [07:04:40:449]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (1C:1C) [07:04:40:449]: Transforming table Error.

MSI (s) (1C:1C) [07:04:40:449]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (1C:1C) [07:04:40:464]: Transforming table Error.

MSI (s) (1C:1C) [07:04:40:464]: Transforming table Error.

MSI (s) (1C:1C) [07:04:40:464]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (1C:1C) [07:04:40:464]: Transforming table Error.

MSI (s) (1C:1C) [07:04:40:464]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (1C:1C) [07:04:40:464]: Transforming table Error.

MSI (s) (1C:1C) [07:04:40:464]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (1C:1C) [07:04:40:464]: Product: Microsoft SQL Server 2005 --
Configuration failed。

MSI (s) (1C:1C) [07:04:40:464]: Attempting to delete file
C:\WINDOWS\Installer\380974f3.msp
MSI (s) (1C:1C) [07:04:40:464]: Unable to delete the file. LastError = 32
MSI (s) (1C:1C) [07:04:40:480]: Cleaning up uninstalled install packages, if
any exist
MSI (s) (1C:1C) [07:04:40:480]: Post-install cleanup: removing installer
file 'C:\WINDOWS\Installer\380974f3.msp'
MSI (s) (1C:1C) [07:04:40:496]: MainEngineThread is returning 1603
MSI (s) (1C8) [07:04:40:496]: Destroying RemoteAPI object.
MSI (s) (1C:28) [07:04:40:496]: Custom Action Manager thread ending.
=== Logging stopped: 2007/10/15 07:04:40 ===
MSI (c) (74:1C) [07:04:40:574]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (74:1C) [07:04:40:574]: MainEngineThread is returning 1603
--------------------------------------------------------------------------------------

I had this isse and none of the solutions I could find online worked.

The problem seems to be that I joined this server to a domain after
installing SQL 2005.

If I run setup from a domain account in the local administrator group
instead of using the local administrator account, it works.

This may be because the local Admin account isn't able to resolve the
domain account ACLs on some of the objects.

I had this isse and none of the solutions I could find online worked.

The problem seems to be that I joined this server to a domain after
installing SQL 2005.

If I run setup from a domain account in the local administrator group
instead of using the local administrator account, it works.

This may be because the local Admin account isn't able to resolve the
domain account ACLs on some of the objects.