2005 SP2 - Install failed error 29537

Hi,
We installed SP2 on SQL 2005 base a week ago. Everything seems to work and
no errors are being reported, but it failed as per the following summary. I
did not stop any services prior to installing and rebooted after the
installation.
Time: 04/27/2007 16:47:24.552
KB Number: KB921896
Machine: SQL
OS Version: Microsoft Windows Server 2003 family, Standard Edition Service
Pack 1 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x64
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: No
****************************************
************************************
******
Prerequisites Check & Status
SQLSupport: Passed
****************************************
************************************
******
Products Detected Language Level Patch Level
Platform Edition
Setup Support Files ENU 9.00.1399.06
x64
Database Services (MSSQLSERVER) ENU RTM 2005.090.1399.00
x64 STANDARD
Notification Services ENU RTM 9.00.1399.00
x64 STANDARD
Integration Services ENU RTM 9.00.1399.00
x64 STANDARD
SQL Server Native Client ENU 9.00.1399.06
x64
Client Components ENU RTM 9.00.1399.06
x64 STANDARD
MSXML 6.0 Parser ENU 6.00.3888.0
x64
SQLXML4 ENU 9.00.1399.06
x64
Backward Compatibility ENU 8.05.1054
x64
Microsoft SQL Server VSS Writer ENU 9.00.1399.06
x64
****************************************
************************************
******
Products Disqualified & Reason
Product Reason
****************************************
************************************
******
Processes Locking Files
Process Name Feature Type User Name
PID
MSSQLSERVER SQL Server Native Client Service
1472
SQLSERVERAGENT SQL Server Native Client Service
1932
msftesql Database Services Service
1672
SQLBrowser Database Services Service
1548
MsDtsServer Integration Services Service
1252
****************************************
************************************
******
Product Installation Status
Product : Setup Support Files
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB92
1896_SqlSupport.msi.log
Error Number : 0
Error Description :
----
--
Product : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB92189
6_sqlrun_sql.msp.log
Error Number : 29537
Error Description : MSP Error: 29537 SQL Server Setup has
encountered the following problem: [Microsoft][SQL Native Client]
1;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
Server Setup again.
----
--
Product : Notification Services
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\NS9_Hotfix_KB921896
_sqlrun_ns.msp.log
Error Number : 0
Error Description :
----
--
Product : Integration Services
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB92189
6_sqlrun_dts.msp.log
Error Number : 0
Error Description :
----
--
Product : SQL Server Native Client
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB92
1896_sqlncli.msi.log
Error Number : 0
Error Description :
----
--
Product : Client Components
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB
921896_sqlrun_tools.msp.log
Error Number : 0
Error Description :
----
--
Product : MSXML 6.0 Parser
Product Version (Previous): 3888
Product Version (Final) : 6.10.1129.0
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB92
1896_msxml6.msi.log
Error Number : 0
Error Description :
----
--
Product : SQLXML4
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB92
1896_sqlxml4.msi.log
Error Number : 0
Error Description :
----
--
Product : Backward Compatibility
Product Version (Previous): 1054
Product Version (Final) : 2004
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB92
1896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
----
--
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 1399
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB92
1896_SqlWriter.msi.log
Error Number : 0
Error Description :
----
--
****************************************
************************************
******
Summary
One or more products failed to install, see above for details
Exit Code Returned: 29537Hi
"Adr" wrote:

> Hi,
> We installed SP2 on SQL 2005 base a week ago. Everything seems to work an
d
> no errors are being reported, but it failed as per the following summary.
I
> did not stop any services prior to installing and rebooted after the
> installation.
> Time: 04/27/2007 16:47:24.552
> KB Number: KB921896
> Machine: SQL
> OS Version: Microsoft Windows Server 2003 family, Standard Edition Service
> Pack 1 (Build 3790)
> Package Language: 1033 (ENU)
> Package Platform: x64
> Package SP Level: 2
> Package Version: 3042
> Command-line parameters specified:
> Cluster Installation: No
> ----
--
> Product : Database Services (MSSQLSERVER)
> Product Version (Previous): 1399
> Product Version (Final) :
> Status : Failure
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB92189
6_sqlrun_sql.msp.log
> Error Number : 29537
> Error Description : MSP Error: 29537 SQL Server Setup has
> encountered the following problem: [Microsoft][SQL Native Client]&
#91;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
> Server Setup again.
> ----

****************************************
****************************************
**green">
> Summary
> One or more products failed to install, see above for details
> Exit Code Returned: 29537
>
Did you look in C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB92189
6_sqlrun_sql.msp.log ?
John|||Yes, you are referring to the 10MB logfile that is mostly greek? AT the
end, it has this if it helps. I can email the file to someone if necessary.
Thanks for reviewing my post!
MSI (s) (64:1C) [16:40:58:422]: Product: Microsoft SQL Server 2005 (64-b
it)
- Update 'Service Pack 2 for SQL Server Database Services 2005 (64-bit) ENU
(KB921896)' could not be installed. Error code 1603. Additional information
is available in the log file C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB92189
6_sqlrun_sql.msp.log.
MSI (s) (64:1C) [16:40:58:422]: Note: 1: 1729
MSI (s) (64:1C) [16:40:58:422]: Transforming table Error.
MSI (s) (64:1C) [16:40:58:422]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (64:1C) [16:40:58:438]: Transforming table Error.
MSI (s) (64:1C) [16:40:58:438]: Transforming table Error.
MSI (s) (64:1C) [16:40:58:438]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (64:1C) [16:40:58:438]: Transforming table Error.
MSI (s) (64:1C) [16:40:58:438]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (64:1C) [16:40:58:438]: Transforming table Error.
MSI (s) (64:1C) [16:40:58:438]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (64:1C) [16:40:58:438]: Transforming table Error.
MSI (s) (64:1C) [16:40:58:438]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (64:1C) [16:40:58:454]: Transforming table Error.
MSI (s) (64:1C) [16:40:58:454]: Transforming table Error.
MSI (s) (64:1C) [16:40:58:454]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (64:1C) [16:40:58:454]: Transforming table Error.
MSI (s) (64:1C) [16:40:58:454]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (64:1C) [16:40:58:454]: Transforming table Error.
MSI (s) (64:1C) [16:40:58:454]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (64:1C) [16:40:58:454]: Product: Microsoft SQL Server 2005 (64-b
it)
-- Configuration failed.
MSI (s) (64:1C) [16:40:58:454]: Attempting to delete file
C:\WINDOWS\Installer\3e7f1.msp
MSI (s) (64:1C) [16:40:58:454]: Unable to delete the file. LastError = 3
2
MSI (s) (64:1C) [16:40:58:470]: Cleaning up uninstalled install packages
, if
any exist
MSI (s) (64:1C) [16:40:58:470]: Post-install cleanup: removing installer
file 'C:\WINDOWS\Installer\3e7f1.msp'
MSI (s) (64:1C) [16:40:58:486]: MainEngineThread is returning 1603
MSI (s) (64:18) [16:40:58:486]: Destroying RemoteAPI object.
MSI (s) (64:70) [16:40:58:486]: Custom Action Manager thread ending.
=== Logging stopped: 4/27/2007 16:40:58 ===
MSI (c) (84:18) [16:40:58:535]: Decrementing counter to disable shutdown
. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (84:18) [16:40:58:535]: MainEngineThread is returning 1603
=== Verbose logging stopped: 4/27/2007 16:40:58 ===
"John Bell" wrote:

> Hi
> "Adr" wrote:
>
> ****************************************
**********************************
********
> Did you look in C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB92189
6_sqlrun_sql.msp.log ?
> John
>|||Hi
"Adr" wrote:
[vbcol=seagreen]
> Yes, you are referring to the 10MB logfile that is mostly greek? AT the
> end, it has this if it helps. I can email the file to someone if necessar
y.
> Thanks for reviewing my post!
> MSI (s) (64:1C) [16:40:58:422]: Product: Microsoft SQL Server 2005 (64
-bit)
> - Update 'Service Pack 2 for SQL Server Database Services 2005 (64-bit) EN
U
> (KB921896)' could not be installed. Error code 1603. Additional informatio
n
> is available in the log file C:\Program Files\Microsoft SQL Server\90\Setu
p
> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB92189
6_sqlrun_sql.msp.log.
> MSI (s) (64:1C) [16:40:58:422]: Note: 1: 1729
> MSI (s) (64:1C) [16:40:58:422]: Transforming table Error.
> MSI (s) (64:1C) [16:40:58:422]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (64:1C) [16:40:58:438]: Transforming table Error.
> MSI (s) (64:1C) [16:40:58:438]: Transforming table Error.
> MSI (s) (64:1C) [16:40:58:438]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (64:1C) [16:40:58:438]: Transforming table Error.
> MSI (s) (64:1C) [16:40:58:438]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (64:1C) [16:40:58:438]: Transforming table Error.
> MSI (s) (64:1C) [16:40:58:438]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (64:1C) [16:40:58:438]: Transforming table Error.
> MSI (s) (64:1C) [16:40:58:438]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (64:1C) [16:40:58:454]: Transforming table Error.
> MSI (s) (64:1C) [16:40:58:454]: Transforming table Error.
> MSI (s) (64:1C) [16:40:58:454]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (64:1C) [16:40:58:454]: Transforming table Error.
> MSI (s) (64:1C) [16:40:58:454]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (64:1C) [16:40:58:454]: Transforming table Error.
> MSI (s) (64:1C) [16:40:58:454]: Note: 1: 2262 2: Error 3: -2147287038
> MSI (s) (64:1C) [16:40:58:454]: Product: Microsoft SQL Server 2005 (64
-bit)
> -- Configuration failed.
> MSI (s) (64:1C) [16:40:58:454]: Attempting to delete file
> C:\WINDOWS\Installer\3e7f1.msp
> MSI (s) (64:1C) [16:40:58:454]: Unable to delete the file. LastError =
32
> MSI (s) (64:1C) [16:40:58:470]: Cleaning up uninstalled install packag
es, if
> any exist
> MSI (s) (64:1C) [16:40:58:470]: Post-install cleanup: removing install
er
> file 'C:\WINDOWS\Installer\3e7f1.msp'
> MSI (s) (64:1C) [16:40:58:486]: MainEngineThread is returning 1603
> MSI (s) (64:18) [16:40:58:486]: Destroying RemoteAPI object.
> MSI (s) (64:70) [16:40:58:486]: Custom Action Manager thread ending.
> === Logging stopped: 4/27/2007 16:40:58 ===
> MSI (c) (84:18) [16:40:58:535]: Decrementing counter to disable shutdo
wn. If
> counter >= 0, shutdown will be denied. Counter after decrement: -1
> MSI (c) (84:18) [16:40:58:535]: MainEngineThread is returning 1603
> === Verbose logging stopped: 4/27/2007 16:40:58 ===
> "John Bell" wrote:
>
I am not sure what that error refers to.
Although your problem is not reporting services the reply bu Jeremy to this
post has good advice you may want to try out
http://forums.microsoft.com/MSDN/Sh...519115&SiteID=1
otherwise you should call PSS.
John