Advertisement

01.03.2008 at 10:42PM PST, ID: 23057899
[x]
Attachment Details

SQL 2005 SP2 install failure

Asked by QuarryAdmin in SQL Server 2005, Windows 2003 Server

Tags: Microsoft, SQL 2005 32 bit, Std edn, 2 node cluster active\passive on WK2003, Dell, Power Edge 2950, MSP Error: 29549; 11009, MSSQLDBSERVER component failed and client tools upgrade failed

Unable to complete SQL 2005 SP2 installation on Windows Server 2003 SP1 Cluster. Some components failing including SQL Server and Client Tools. Log attached below:
Ran install using domain administrator accountStart Free Trial
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109:
110:
111:
112:
113:
114:
115:
116:
117:
118:
119:
120:
121:
122:
123:
124:
125:
126:
127:
128:
129:
130:
131:
132:
133:
134:
135:
136:
137:
138:
139:
140:
Time: 01/04/2008 16:27:07.228
KB Number: KB921896
Machine: BM-SQL-01
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 1 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x86
Package SP Level: 2
Package Version: 3042
Command-line parameters specified:
Cluster Installation: Yes
Log Location on Passive Nodes:
     (BM-SQL-01) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
     (BM-SQL-02) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
     (BM-SQL-01) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
     (BM-SQL-02) C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix
 
**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed
 
**********************************************************************************
Products Detected                         Language  Level  Patch Level       Platform  Edition
Setup Support Files                       ENU                     9.2.3042  x86       
Database Services (MSSQLSERVER)           ENU       SP1    2005.090.2047.00  x86       STANDARD
Analysis Services (MSSQLSERVER)           ENU       SP1    2005.090.2047.00  x86       STANDARD
Notification Services                     ENU       SP1       9.00.2047.00  x86       STANDARD
Integration Services                      ENU       SP2       9.00.3042.00  x86       STANDARD
SQL Server Native Client                  ENU                 9.00.3042.00  x86       
Client Components                         ENU       SP1           9.1.2047  x86       STANDARD
MSXML 6.0 Parser                          ENU                  6.10.1129.0  x86       
SQLXML4                                   ENU                 9.00.3042.00  x86       
Backward Compatibility                    ENU                    8.05.2004  x86       
Microsoft SQL Server VSS Writer           ENU                 9.00.3042.00  x86       
 
**********************************************************************************
Products Disqualified & Reason
Product                                   Reason
 
**********************************************************************************
Processes Locking Files
Process Name          Feature               Type          User Name                  PID
msftesql              Database Services     Service                                  3320
MSSQLSERVER           Database Services     Service                                  2040
SQLSERVERAGENT        Database Services     Service                                  2928
ResrcMon.exe          Database Services     Application   DJWHS\SVC-CLUSTER-BM-SQL   216
SQLBrowser            Database Services     Service                                  2468
MSSQLServerOLAPService  Analysis Services     Service                                  3408
 
**********************************************************************************
Product Installation Status
Product                   : Setup Support Files
Product Version (Previous): 3042
Product Version (Final)   : 
Status                    : Not Selected
Log File                  : 
Error Description         :
----------------------------------------------------------------------------------
Product                   : Database Services (MSSQLSERVER)
Product Version (Previous): 2047
Product Version (Final)   : 
Status                    : Failure
Log File                  : 
Error Number              : 11009
Error Description         : No passive nodes were successfully patched
----------------------------------------------------------------------------------
Product                   : Analysis Services (MSSQLSERVER)
Product Version (Previous): 2047
Product Version (Final)   : 3042
Status                    : Success
Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\OLAP9_Hotfix_KB921896_sqlrun_as.msp.log
Error Number              : 0
Error Description         :
----------------------------------------------------------------------------------
Product                   : Notification Services
Product Version (Previous): 2047
Product Version (Final)   : 
Status                    : Failure
Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\NS9_Hotfix_KB921896_sqlrun_ns.msp.log
Error Number              : 29549
Error Description         : MSP Error: 29549  Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: The transaction has aborted.
----------------------------------------------------------------------------------
Product                   : Integration Services
Product Version (Previous): 3042
Product Version (Final)   : 
Status                    : Not Selected
Log File                  : 
Error Description         :
----------------------------------------------------------------------------------
Product                   : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final)   : 
Status                    : Not Selected
Log File                  : 
Error Description         :
----------------------------------------------------------------------------------
Product                   : Client Components
Product Version (Previous): 2047
Product Version (Final)   : 
Status                    : Failure
Log File                  : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log
Error Number              : 29549
Error Description         : MSP Error: 29549  Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2146233087
Error message: Unknown error 0x80131501
Error description: The transaction has aborted.
----------------------------------------------------------------------------------
Product                   : MSXML 6.0 Parser
Product Version (Previous): 1129
Product Version (Final)   : 
Status                    : Not Selected
Log File                  : 
Error Description         :
----------------------------------------------------------------------------------
Product                   : SQLXML4
Product Version (Previous): 3042
Product Version (Final)   : 
Status                    : Not Selected
Log File                  : 
Error Description         :
----------------------------------------------------------------------------------
Product                   : Backward Compatibility
Product Version (Previous): 2004
Product Version (Final)   : 
Status                    : Not Selected
Log File                  : 
Error Description         :
----------------------------------------------------------------------------------
Product                   : Microsoft SQL Server VSS Writer
Product Version (Previous): 3042
Product Version (Final)   : 
Status                    : Not Selected
Log File                  : 
Error Description         :
----------------------------------------------------------------------------------
 
**********************************************************************************
Summary
     No passive nodes were successfully patched
     Exit Code Returned: 11009
[+][-]01.04.2008 at 12:28AM PST, ID: 20580579

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.04.2008 at 12:33AM PST, ID: 20580597

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.04.2008 at 12:51AM PST, ID: 20580651

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: SQL Server 2005, Windows 2003 Server
Tags: Microsoft, SQL 2005 32 bit, Std edn, 2 node cluster active\passive on WK2003, Dell, Power Edge 2950, MSP Error: 29549; 11009, MSSQLDBSERVER component failed and client tools upgrade failed
Sign Up Now!
Solution Provided By: santhoshu
Participating Experts: 1
Solution Grade: A
 
 
[+][-]01.04.2008 at 02:59AM PST, ID: 20581027

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]01.04.2008 at 04:30PM PST, ID: 20587239

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628