We are running SQL 2005 STD on a Windows 2003 STD R2 SP2 and having the
repeated failures applying the SQL 2005 SP2.
Summary:
________________________________________________________________
Time: 01/04/2008 22:31:23.978
KB Number: KB921896
Machine: GONLCHSQL01
OS Version: Microsoft Windows Server 2003 family, Standard Edition Service
Pack 2 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x86
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.2.3042
x86
Database Services (MSSQLSERVER) ENU RTM 2005.090.1406.00
x86 STANDARD
Analysis Services (MSSQLSERVER) ENU RTM 2005.090.1406.00
x86 STANDARD
Reporting Services (MSSQLSERVER) ENU RTM 9.00.1406.00
x86 STANDARD
Notification Services ENU RTM 9.00.1406.00
x86 STANDARD
Integration Services ENU RTM 9.00.1406.00
x86 STANDARD
SQL Server Native Client ENU 9.00.1399.06
x86
SQL Server Native Client ENU 9.00.3042.00
x86
Client Components ENU RTM 9.00.1406.00
x86 STANDARD
MSXML 6.0 Parser ENU 6.10.1129.0
x86
MSXML 6.0 Parser ENU 6.10.1200.0
x86
SQLXML4 ENU 9.00.1399.06
x86
SQLXML4 ENU 9.00.3042.00
x86
Backward Compatibility ENU 8.05.1054
x86
Backward Compatibility ENU 8.05.2004
x86
Microsoft SQL Server VSS Writer ENU 9.00.1399.06
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
2988
MSSQLSERVER Database Services Service
1604
qrdrsvc.exe Database Services Application NKF\sql_visual
3800
SQLSERVERAGENT Database Services Service
3832
ReportServer Database Services Service
2340
MsDtsServer Integration Services Service
1784
**********************************************************************************
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): 1406
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number : 1635
Error Description : Unable to install Windows Installer MSP file
----
Product : Analysis Services (MSSQLSERVER)
Product Version (Previous): 1406
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\OLAP9_Hotfix_KB921896_sqlrun_as.msp.log
Error Number : 1635
Error Description : Unable to install Windows Installer MSP file
----
Product : Reporting Services (MSSQLSERVER)
Product Version (Previous): 1406
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\RS9_Hotfix_KB921896_sqlrun_rs.msp.log
Error Number : 1635
Error Description : Unable to install Windows Installer MSP file
----
Product : Notification Services
Product Version (Previous): 1406
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 : 1635
Error Description : Unable to install Windows Installer MSP file
----
Product : Integration Services
Product Version (Previous): 1406
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB921896_sqlrun_dts.msp.log
Error Number : 1635
Error Description : Unable to install Windows Installer MSP file
----
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_KB921896_sqlncli.msi.log
Error Number : 0
Error Description :
----
Product : SQL Server Native Client
Product Version (Previous): 3042
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_sqlncli.msi.log
Error Number : 0
Error Description :
----
Product : Client Components
Product Version (Previous): 1406
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 : 1635
Error Description : Unable to install Windows Installer MSP file
----
Product : MSXML 6.0 Parser
Product Version (Previous): 1129
Product Version (Final) :
Status : Not Selected
Log File :
Error Description :
----
Product : MSXML 6.0 Parser
Product Version (Previous): 1200
Product Version (Final) :
Status : Not Selected
Log File :
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_KB921896_sqlxml4.msi.log
Error Number : 0
Error Description :
----
Product : SQLXML4
Product Version (Previous): 3042
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_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_KB921896_SQLServer2005_BC.msi.log
Error Number : 0
Error Description :
----
Product : Backward Compatibility
Product Version (Previous): 2004
Product Version (Final) : 2004
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_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_KB921896_SqlWriter.msi.log
Error Number : 0
Error Description :
----
Product : Microsoft SQL Server VSS Writer
Product Version (Previous): 3042
Product Version (Final) : 3042
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlWriter.msi.log
Error Number : 0
Error Description :
----
**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 1635
_____________________________________________________________
This is a known issue and we have already tried the solution proposed in a
previous post by Peter Yang. Unfortunately we have the still issue. Does
someone have any other ideas?
Thanks.Sorry, forgot to mention the solution tried:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;925976|||Jeffry,
You are running a hotfix build 1406 not RTM 1399. Have you tried to install
SP1 first? Seems that SP2 might not like upgrading 1406.
Chris
"Jeffry van Amson" <Jeffry van Amson@.discussions.microsoft.com> wrote in
message news:F56972B6-DDB2-4FED-8747-210F2C2F4F99@.microsoft.com...
> We are running SQL 2005 STD on a Windows 2003 STD R2 SP2 and having the
> repeated failures applying the SQL 2005 SP2.
> Summary:
> ________________________________________________________________
> Time: 01/04/2008 22:31:23.978
> KB Number: KB921896
> Machine: GONLCHSQL01
> OS Version: Microsoft Windows Server 2003 family, Standard Edition Service
> Pack 2 (Build 3790)
> Package Language: 1033 (ENU)
> Package Platform: x86
> 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.2.3042
> x86
> Database Services (MSSQLSERVER) ENU RTM
> 2005.090.1406.00
> x86 STANDARD
> Analysis Services (MSSQLSERVER) ENU RTM
> 2005.090.1406.00
> x86 STANDARD
> Reporting Services (MSSQLSERVER) ENU RTM 9.00.1406.00
> x86 STANDARD
> Notification Services ENU RTM 9.00.1406.00
> x86 STANDARD
> Integration Services ENU RTM 9.00.1406.00
> x86 STANDARD
> SQL Server Native Client ENU 9.00.1399.06
> x86
> SQL Server Native Client ENU 9.00.3042.00
> x86
> Client Components ENU RTM 9.00.1406.00
> x86 STANDARD
> MSXML 6.0 Parser ENU 6.10.1129.0
> x86
> MSXML 6.0 Parser ENU 6.10.1200.0
> x86
> SQLXML4 ENU 9.00.1399.06
> x86
> SQLXML4 ENU 9.00.3042.00
> x86
> Backward Compatibility ENU 8.05.1054
> x86
> Backward Compatibility ENU 8.05.2004
> x86
> Microsoft SQL Server VSS Writer ENU 9.00.1399.06
> 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
> 2988
> MSSQLSERVER Database Services Service
> 1604
> qrdrsvc.exe Database Services Application NKF\sql_visual
> 3800
> SQLSERVERAGENT Database Services Service
> 3832
> ReportServer Database Services Service
> 2340
> MsDtsServer Integration Services Service
> 1784
> **********************************************************************************
> 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): 1406
> Product Version (Final) :
> Status : Failure
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
> Error Number : 1635
> Error Description : Unable to install Windows Installer MSP file
> ----
> Product : Analysis Services (MSSQLSERVER)
> Product Version (Previous): 1406
> Product Version (Final) :
> Status : Failure
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\OLAP9_Hotfix_KB921896_sqlrun_as.msp.log
> Error Number : 1635
> Error Description : Unable to install Windows Installer MSP file
> ----
> Product : Reporting Services (MSSQLSERVER)
> Product Version (Previous): 1406
> Product Version (Final) :
> Status : Failure
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\RS9_Hotfix_KB921896_sqlrun_rs.msp.log
> Error Number : 1635
> Error Description : Unable to install Windows Installer MSP file
> ----
> Product : Notification Services
> Product Version (Previous): 1406
> 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 : 1635
> Error Description : Unable to install Windows Installer MSP file
> ----
> Product : Integration Services
> Product Version (Previous): 1406
> Product Version (Final) :
> Status : Failure
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB921896_sqlrun_dts.msp.log
> Error Number : 1635
> Error Description : Unable to install Windows Installer MSP file
> ----
> 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_KB921896_sqlncli.msi.log
> Error Number : 0
> Error Description :
> ----
> Product : SQL Server Native Client
> Product Version (Previous): 3042
> Product Version (Final) : 3042
> Status : Success
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_sqlncli.msi.log
> Error Number : 0
> Error Description :
> ----
> Product : Client Components
> Product Version (Previous): 1406
> 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 : 1635
> Error Description : Unable to install Windows Installer MSP file
> ----
> Product : MSXML 6.0 Parser
> Product Version (Previous): 1129
> Product Version (Final) :
> Status : Not Selected
> Log File :
> Error Description :
> ----
> Product : MSXML 6.0 Parser
> Product Version (Previous): 1200
> Product Version (Final) :
> Status : Not Selected
> Log File :
> 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_KB921896_sqlxml4.msi.log
> Error Number : 0
> Error Description :
> ----
> Product : SQLXML4
> Product Version (Previous): 3042
> Product Version (Final) : 3042
> Status : Success
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_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_KB921896_SQLServer2005_BC.msi.log
> Error Number : 0
> Error Description :
> ----
> Product : Backward Compatibility
> Product Version (Previous): 2004
> Product Version (Final) : 2004
> Status : Success
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_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_KB921896_SqlWriter.msi.log
> Error Number : 0
> Error Description :
> ----
> Product : Microsoft SQL Server VSS Writer
> Product Version (Previous): 3042
> Product Version (Final) : 3042
> Status : Success
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlWriter.msi.log
> Error Number : 0
> Error Description :
> ----
> **********************************************************************************
> Summary
> One or more products failed to install, see above for details
> Exit Code Returned: 1635
> _____________________________________________________________
> This is a known issue and we have already tried the solution proposed in a
> previous post by Peter Yang. Unfortunately we have the still issue. Does
> someone have any other ideas?
> Thanks.
>
>|||Check compatibility with the .NET framework 2.0 and any service packs.
Check the logs that the install creates during installation. It will have
more details on the particular error. Should be in the 90 sql server
directory
--
Sincerely,
John K
Knowledgy Consulting, LLC
knowledgy.org
Atlanta's Business Intelligence and Data Warehouse Experts
"Jeffry van Amson" <Jeffry van Amson@.discussions.microsoft.com> wrote in
message news:F56972B6-DDB2-4FED-8747-210F2C2F4F99@.microsoft.com...
> We are running SQL 2005 STD on a Windows 2003 STD R2 SP2 and having the
> repeated failures applying the SQL 2005 SP2.
> Summary:
> ________________________________________________________________
> Time: 01/04/2008 22:31:23.978
> KB Number: KB921896
> Machine: GONLCHSQL01
> OS Version: Microsoft Windows Server 2003 family, Standard Edition Service
> Pack 2 (Build 3790)
> Package Language: 1033 (ENU)
> Package Platform: x86
> 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.2.3042
> x86
> Database Services (MSSQLSERVER) ENU RTM
> 2005.090.1406.00
> x86 STANDARD
> Analysis Services (MSSQLSERVER) ENU RTM
> 2005.090.1406.00
> x86 STANDARD
> Reporting Services (MSSQLSERVER) ENU RTM 9.00.1406.00
> x86 STANDARD
> Notification Services ENU RTM 9.00.1406.00
> x86 STANDARD
> Integration Services ENU RTM 9.00.1406.00
> x86 STANDARD
> SQL Server Native Client ENU 9.00.1399.06
> x86
> SQL Server Native Client ENU 9.00.3042.00
> x86
> Client Components ENU RTM 9.00.1406.00
> x86 STANDARD
> MSXML 6.0 Parser ENU 6.10.1129.0
> x86
> MSXML 6.0 Parser ENU 6.10.1200.0
> x86
> SQLXML4 ENU 9.00.1399.06
> x86
> SQLXML4 ENU 9.00.3042.00
> x86
> Backward Compatibility ENU 8.05.1054
> x86
> Backward Compatibility ENU 8.05.2004
> x86
> Microsoft SQL Server VSS Writer ENU 9.00.1399.06
> 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
> 2988
> MSSQLSERVER Database Services Service
> 1604
> qrdrsvc.exe Database Services Application NKF\sql_visual
> 3800
> SQLSERVERAGENT Database Services Service
> 3832
> ReportServer Database Services Service
> 2340
> MsDtsServer Integration Services Service
> 1784
> **********************************************************************************
> 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): 1406
> Product Version (Final) :
> Status : Failure
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
> Error Number : 1635
> Error Description : Unable to install Windows Installer MSP file
> ----
> Product : Analysis Services (MSSQLSERVER)
> Product Version (Previous): 1406
> Product Version (Final) :
> Status : Failure
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\OLAP9_Hotfix_KB921896_sqlrun_as.msp.log
> Error Number : 1635
> Error Description : Unable to install Windows Installer MSP file
> ----
> Product : Reporting Services (MSSQLSERVER)
> Product Version (Previous): 1406
> Product Version (Final) :
> Status : Failure
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\RS9_Hotfix_KB921896_sqlrun_rs.msp.log
> Error Number : 1635
> Error Description : Unable to install Windows Installer MSP file
> ----
> Product : Notification Services
> Product Version (Previous): 1406
> 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 : 1635
> Error Description : Unable to install Windows Installer MSP file
> ----
> Product : Integration Services
> Product Version (Previous): 1406
> Product Version (Final) :
> Status : Failure
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB921896_sqlrun_dts.msp.log
> Error Number : 1635
> Error Description : Unable to install Windows Installer MSP file
> ----
> 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_KB921896_sqlncli.msi.log
> Error Number : 0
> Error Description :
> ----
> Product : SQL Server Native Client
> Product Version (Previous): 3042
> Product Version (Final) : 3042
> Status : Success
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_sqlncli.msi.log
> Error Number : 0
> Error Description :
> ----
> Product : Client Components
> Product Version (Previous): 1406
> 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 : 1635
> Error Description : Unable to install Windows Installer MSP file
> ----
> Product : MSXML 6.0 Parser
> Product Version (Previous): 1129
> Product Version (Final) :
> Status : Not Selected
> Log File :
> Error Description :
> ----
> Product : MSXML 6.0 Parser
> Product Version (Previous): 1200
> Product Version (Final) :
> Status : Not Selected
> Log File :
> 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_KB921896_sqlxml4.msi.log
> Error Number : 0
> Error Description :
> ----
> Product : SQLXML4
> Product Version (Previous): 3042
> Product Version (Final) : 3042
> Status : Success
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_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_KB921896_SQLServer2005_BC.msi.log
> Error Number : 0
> Error Description :
> ----
> Product : Backward Compatibility
> Product Version (Previous): 2004
> Product Version (Final) : 2004
> Status : Success
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_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_KB921896_SqlWriter.msi.log
> Error Number : 0
> Error Description :
> ----
> Product : Microsoft SQL Server VSS Writer
> Product Version (Previous): 3042
> Product Version (Final) : 3042
> Status : Success
> Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlWriter.msi.log
> Error Number : 0
> Error Description :
> ----
> **********************************************************************************
> Summary
> One or more products failed to install, see above for details
> Exit Code Returned: 1635
> _____________________________________________________________
> This is a known issue and we have already tried the solution proposed in a
> previous post by Peter Yang. Unfortunately we have the still issue. Does
> someone have any other ideas?
> Thanks.
>
>|||Chris,
SP1 had failed too with exact the same errors. This is a known issue, the
problem is that the workaround proposed by Microsoft is not working in this
case.
"Chris Wood" wrote:
> Jeffry,
> You are running a hotfix build 1406 not RTM 1399. Have you tried to install
> SP1 first? Seems that SP2 might not like upgrading 1406.
> Chris
> "Jeffry van Amson" <Jeffry van Amson@.discussions.microsoft.com> wrote in
> message news:F56972B6-DDB2-4FED-8747-210F2C2F4F99@.microsoft.com...
> > We are running SQL 2005 STD on a Windows 2003 STD R2 SP2 and having the
> > repeated failures applying the SQL 2005 SP2.
> >
> > Summary:
> > ________________________________________________________________
> > Time: 01/04/2008 22:31:23.978
> > KB Number: KB921896
> > Machine: GONLCHSQL01
> > OS Version: Microsoft Windows Server 2003 family, Standard Edition Service
> > Pack 2 (Build 3790)
> > Package Language: 1033 (ENU)
> > Package Platform: x86
> > 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.2.3042
> > x86
> > Database Services (MSSQLSERVER) ENU RTM
> > 2005.090.1406.00
> > x86 STANDARD
> > Analysis Services (MSSQLSERVER) ENU RTM
> > 2005.090.1406.00
> > x86 STANDARD
> > Reporting Services (MSSQLSERVER) ENU RTM 9.00.1406.00
> > x86 STANDARD
> > Notification Services ENU RTM 9.00.1406.00
> > x86 STANDARD
> > Integration Services ENU RTM 9.00.1406.00
> > x86 STANDARD
> > SQL Server Native Client ENU 9.00.1399.06
> > x86
> > SQL Server Native Client ENU 9.00.3042.00
> > x86
> > Client Components ENU RTM 9.00.1406.00
> > x86 STANDARD
> > MSXML 6.0 Parser ENU 6.10.1129.0
> > x86
> > MSXML 6.0 Parser ENU 6.10.1200.0
> > x86
> > SQLXML4 ENU 9.00.1399.06
> > x86
> > SQLXML4 ENU 9.00.3042.00
> > x86
> > Backward Compatibility ENU 8.05.1054
> > x86
> > Backward Compatibility ENU 8.05.2004
> > x86
> > Microsoft SQL Server VSS Writer ENU 9.00.1399.06
> > 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
> > 2988
> > MSSQLSERVER Database Services Service
> > 1604
> > qrdrsvc.exe Database Services Application NKF\sql_visual
> > 3800
> > SQLSERVERAGENT Database Services Service
> > 3832
> > ReportServer Database Services Service
> > 2340
> > MsDtsServer Integration Services Service
> > 1784
> >
> > **********************************************************************************
> > 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): 1406
> > Product Version (Final) :
> > Status : Failure
> > Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> > Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
> > Error Number : 1635
> > Error Description : Unable to install Windows Installer MSP file
> > ----
> > Product : Analysis Services (MSSQLSERVER)
> > Product Version (Previous): 1406
> > Product Version (Final) :
> > Status : Failure
> > Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> > Bootstrap\LOG\Hotfix\OLAP9_Hotfix_KB921896_sqlrun_as.msp.log
> > Error Number : 1635
> > Error Description : Unable to install Windows Installer MSP file
> > ----
> > Product : Reporting Services (MSSQLSERVER)
> > Product Version (Previous): 1406
> > Product Version (Final) :
> > Status : Failure
> > Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> > Bootstrap\LOG\Hotfix\RS9_Hotfix_KB921896_sqlrun_rs.msp.log
> > Error Number : 1635
> > Error Description : Unable to install Windows Installer MSP file
> > ----
> > Product : Notification Services
> > Product Version (Previous): 1406
> > 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 : 1635
> > Error Description : Unable to install Windows Installer MSP file
> > ----
> > Product : Integration Services
> > Product Version (Previous): 1406
> > Product Version (Final) :
> > Status : Failure
> > Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> > Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB921896_sqlrun_dts.msp.log
> > Error Number : 1635
> > Error Description : Unable to install Windows Installer MSP file
> > ----
> > 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_KB921896_sqlncli.msi.log
> > Error Number : 0
> > Error Description :
> > ----
> > Product : SQL Server Native Client
> > Product Version (Previous): 3042
> > Product Version (Final) : 3042
> > Status : Success
> > Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> > Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_sqlncli.msi.log
> > Error Number : 0
> > Error Description :
> > ----
> > Product : Client Components
> > Product Version (Previous): 1406
> > 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 : 1635
> > Error Description : Unable to install Windows Installer MSP file
> > ----
> > Product : MSXML 6.0 Parser
> > Product Version (Previous): 1129
> > Product Version (Final) :
> > Status : Not Selected
> > Log File :
> > Error Description :
> > ----
> > Product : MSXML 6.0 Parser
> > Product Version (Previous): 1200
> > Product Version (Final) :
> > Status : Not Selected
> > Log File :
> > 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_KB921896_sqlxml4.msi.log
> > Error Number : 0
> > Error Description :
> > ----
> > Product : SQLXML4
> > Product Version (Previous): 3042
> > Product Version (Final) : 3042
> > Status : Success
> > Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> > Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_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_KB921896_SQLServer2005_BC.msi.log
> > Error Number : 0
> > Error Description :
> > ----
> > Product : Backward Compatibility
> > Product Version (Previous): 2004
> > Product Version (Final) : 2004
> > Status : Success
> > Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> > Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_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_KB921896_SqlWriter.msi.log
> > Error Number : 0
> > Error Description :
> > ----
> > Product : Microsoft SQL Server VSS Writer
> > Product Version (Previous): 3042
> > Product Version (Final) : 3042
> > Status : Success
> > Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> > Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlWriter.msi.log
> > Error Number : 0
> > Error Description :
> > ----
> >
> > **********************************************************************************
> > Summary
> > One or more products failed to install, see above for details
> > Exit Code Returned: 1635
> >
> > _____________________________________________________________
> >
> > This is a known issue and we have already tried the solution proposed in a
> > previous post by Peter Yang. Unfortunately we have the still issue. Does
> > someone have any other ideas?
> >
> > Thanks.
> >
> >
> >
>
>|||I have checked the logs you are talking about. All the logs suggest no
permission to unzip the hotfix. The installation fails because the package is
not were it should be.
"Knowledgy" wrote:
> Check compatibility with the .NET framework 2.0 and any service packs.
> Check the logs that the install creates during installation. It will have
> more details on the particular error. Should be in the 90 sql server
> directory
> --
> Sincerely,
> John K
> Knowledgy Consulting, LLC
> knowledgy.org
> Atlanta's Business Intelligence and Data Warehouse Experts
>
> "Jeffry van Amson" <Jeffry van Amson@.discussions.microsoft.com> wrote in
> message news:F56972B6-DDB2-4FED-8747-210F2C2F4F99@.microsoft.com...
> > We are running SQL 2005 STD on a Windows 2003 STD R2 SP2 and having the
> > repeated failures applying the SQL 2005 SP2.
> >
> > Summary:
> > ________________________________________________________________
> > Time: 01/04/2008 22:31:23.978
> > KB Number: KB921896
> > Machine: GONLCHSQL01
> > OS Version: Microsoft Windows Server 2003 family, Standard Edition Service
> > Pack 2 (Build 3790)
> > Package Language: 1033 (ENU)
> > Package Platform: x86
> > 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.2.3042
> > x86
> > Database Services (MSSQLSERVER) ENU RTM
> > 2005.090.1406.00
> > x86 STANDARD
> > Analysis Services (MSSQLSERVER) ENU RTM
> > 2005.090.1406.00
> > x86 STANDARD
> > Reporting Services (MSSQLSERVER) ENU RTM 9.00.1406.00
> > x86 STANDARD
> > Notification Services ENU RTM 9.00.1406.00
> > x86 STANDARD
> > Integration Services ENU RTM 9.00.1406.00
> > x86 STANDARD
> > SQL Server Native Client ENU 9.00.1399.06
> > x86
> > SQL Server Native Client ENU 9.00.3042.00
> > x86
> > Client Components ENU RTM 9.00.1406.00
> > x86 STANDARD
> > MSXML 6.0 Parser ENU 6.10.1129.0
> > x86
> > MSXML 6.0 Parser ENU 6.10.1200.0
> > x86
> > SQLXML4 ENU 9.00.1399.06
> > x86
> > SQLXML4 ENU 9.00.3042.00
> > x86
> > Backward Compatibility ENU 8.05.1054
> > x86
> > Backward Compatibility ENU 8.05.2004
> > x86
> > Microsoft SQL Server VSS Writer ENU 9.00.1399.06
> > 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
> > 2988
> > MSSQLSERVER Database Services Service
> > 1604
> > qrdrsvc.exe Database Services Application NKF\sql_visual
> > 3800
> > SQLSERVERAGENT Database Services Service
> > 3832
> > ReportServer Database Services Service
> > 2340
> > MsDtsServer Integration Services Service
> > 1784
> >
> > **********************************************************************************
> > 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): 1406
> > Product Version (Final) :
> > Status : Failure
> > Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> > Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
> > Error Number : 1635
> > Error Description : Unable to install Windows Installer MSP file
> > ----
> > Product : Analysis Services (MSSQLSERVER)
> > Product Version (Previous): 1406
> > Product Version (Final) :
> > Status : Failure
> > Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> > Bootstrap\LOG\Hotfix\OLAP9_Hotfix_KB921896_sqlrun_as.msp.log
> > Error Number : 1635
> > Error Description : Unable to install Windows Installer MSP file
> > ----
> > Product : Reporting Services (MSSQLSERVER)
> > Product Version (Previous): 1406
> > Product Version (Final) :
> > Status : Failure
> > Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> > Bootstrap\LOG\Hotfix\RS9_Hotfix_KB921896_sqlrun_rs.msp.log
> > Error Number : 1635
> > Error Description : Unable to install Windows Installer MSP file
> > ----
> > Product : Notification Services
> > Product Version (Previous): 1406
> > 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 : 1635
> > Error Description : Unable to install Windows Installer MSP file
> > ----
> > Product : Integration Services
> > Product Version (Previous): 1406
> > Product Version (Final) :
> > Status : Failure
> > Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> > Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB921896_sqlrun_dts.msp.log
> > Error Number : 1635
> > Error Description : Unable to install Windows Installer MSP file
> > ----
> > 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_KB921896_sqlncli.msi.log
> > Error Number : 0
> > Error Description :
> > ----
> > Product : SQL Server Native Client
> > Product Version (Previous): 3042
> > Product Version (Final) : 3042
> > Status : Success
> > Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> > Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_sqlncli.msi.log
> > Error Number : 0
> > Error Description :
> > ----
> > Product : Client Components
> > Product Version (Previous): 1406
> > 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 : 1635
> > Error Description : Unable to install Windows Installer MSP file
> > ----
> > Product : MSXML 6.0 Parser
> > Product Version (Previous): 1129
> > Product Version (Final) :
> > Status : Not Selected
> > Log File :
> > Error Description :
> > ----
> > Product : MSXML 6.0 Parser
> > Product Version (Previous): 1200
> > Product Version (Final) :
> > Status : Not Selected
> > Log File :
> > 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_KB921896_sqlxml4.msi.log
> > Error Number : 0
> > Error Description :
> > ----
> > Product : SQLXML4
> > Product Version (Previous): 3042
> > Product Version (Final) : 3042
> > Status : Success
> > Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> > Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_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_KB921896_SQLServer2005_BC.msi.log
> > Error Number : 0
> > Error Description :
> > ----
> > Product : Backward Compatibility
> > Product Version (Previous): 2004
> > Product Version (Final) : 2004
> > Status : Success
> > Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> > Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_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_KB921896_SqlWriter.msi.log
> > Error Number : 0
> > Error Description :
> > ----
> > Product : Microsoft SQL Server VSS Writer
> > Product Version (Previous): 3042
> > Product Version (Final) : 3042
> > Status : Success
> > Log File : C:\Program Files\Microsoft SQL Server\90\Setup
> > Bootstrap\LOG\Hotfix\Redist9_Hotfix_KB921896_SqlWriter.msi.log
> > Error Number : 0
> > Error Description :
> > ----
> >
> > **********************************************************************************
> > Summary
> > One or more products failed to install, see above for details
> > Exit Code Returned: 1635
> >
> > _____________________________________________________________
> >
> > This is a known issue and we have already tried the solution proposed in a
> > previous post by Peter Yang. Unfortunately we have the still issue. Does
> > someone have any other ideas?
> >
> > Thanks.
> >
> >
> >
>
>
Showing posts with label repeated. Show all posts
Showing posts with label repeated. Show all posts
Tuesday, March 27, 2012
Error installing SQL 2005 SP2 KB 921896
I am running Windows 2003 Enterprise SP2 running SQL 2005 Enterprise and am
getting repeated failures applying SQL 2005 SP2. The error is always the
same (see below).
I have made sure that there are no disabled services in the SQL Server
family of services, but this does not appear to have helped. This SQL
installation is pretty minimal, basically just the Database Engine. The
services list is:
SQL Server (MSSQLSERVER) StartedAutomaticLocal System
SQL Server Active Directory Helper Manual (was disabled) Network Service
SQL Server Agent (MSSQLSERVER) StartedAutomaticLocal System
SQL Server Browser Manual (was disabled)Local System
SQL Server FullText Search (MSSQLSERVER) StartedAutomaticLocal System
SQL Server VSS Writer StartedAutomaticLocal System
from the summary:
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 : 29528
Error Description : MSP Error: 29528 The setup has encountered an
unexpected error while Setting Internal Properties. The error is: Fatal error
during installation.
from the event log:
Event Type:Error
Event Source:MsiInstaller
Event Category:None
Event ID:1023
Date:5/3/2007
Time:6:37:36 PM
User:RLTESTENV002\Administrator
Computer:RLTESTENV002
Description:
Product: Microsoft SQL Server 2005 - Update 'Service Pack 2 for SQL Server
Database Services 2005 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_KB921896_sqlrun_s ql.msp.log.
Event Type:Error
Event Source:MsiInstaller
Event Category:None
Event ID:10005
Date:5/3/2007
Time:6:37:35 PM
User:RLTESTENV002\Administrator
Computer:RLTESTENV002
Description:
Product: Microsoft SQL Server 2005 -- Error 29528. The setup has encountered
an unexpected error while Setting Internal Properties. The error is: Fatal
error during installation.
I can send the detailed log if you need it.
Hello,
From the error message "Error Description : MSP Error: 29528 The setup has
encountered an unexpected error while Setting Internal Properties. The
error is: Fatal error during installation", this is a known issue. This
issue occurs because of one of the following reasons:
An operation has removed the local groups for the initial installation of
SQL Server 2005.
An operation has changed the security identifiers (SID) for the local
groups.
Considering your SQL Server is not a clustered instance, please follow the
below steps to workaround the problem:
Warning: Serious problems might occur if you modify the registry
incorrectly by using Registry Editor or by using another method. These
problems might require that you reinstall your operating system. Microsoft
cannot guarantee that these problems can be solved. Modify the registry at
your own risk.
1. Remove the following registry subkeys that store SID settings:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.X\Setup\SQLGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.X\Setup\AGTGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.X\Setup\FTSGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.X\Setup\ASGroup
Note In these registry subkeys, MSSQL.X is a placeholder for the
corresponding value on a specific system. You can determine MSSQL.X on a
specific system by examining the value of the MSSQLSERVER registry entry
under the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance
Names\SQL\
2. Reinstall the SQL Server 2005 service pack or the SQL Server 2005 hotfix
package.
For more information about this issue, please refer to KB 925976:
<http://support.microsoft.com/default.aspx?scid=kb;EN-US;925976>
Please let em know if this resolve the problem. If you encounter any
further error, please also let's know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hello,
I'm still interested in this issue. If you have any comments or questions,
please feel free to let's know. We look forward to hearing from you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hello,
I had the same problem and your solution helped upgrade the Database
service, but not analysis service.
Any idea why ?
Thanks...
"Peter Yang [MSFT]" wrote:
> Hello,
> I'm still interested in this issue. If you have any comments or questions,
> please feel free to let's know. We look forward to hearing from you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
>
getting repeated failures applying SQL 2005 SP2. The error is always the
same (see below).
I have made sure that there are no disabled services in the SQL Server
family of services, but this does not appear to have helped. This SQL
installation is pretty minimal, basically just the Database Engine. The
services list is:
SQL Server (MSSQLSERVER) StartedAutomaticLocal System
SQL Server Active Directory Helper Manual (was disabled) Network Service
SQL Server Agent (MSSQLSERVER) StartedAutomaticLocal System
SQL Server Browser Manual (was disabled)Local System
SQL Server FullText Search (MSSQLSERVER) StartedAutomaticLocal System
SQL Server VSS Writer StartedAutomaticLocal System
from the summary:
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 : 29528
Error Description : MSP Error: 29528 The setup has encountered an
unexpected error while Setting Internal Properties. The error is: Fatal error
during installation.
from the event log:
Event Type:Error
Event Source:MsiInstaller
Event Category:None
Event ID:1023
Date:5/3/2007
Time:6:37:36 PM
User:RLTESTENV002\Administrator
Computer:RLTESTENV002
Description:
Product: Microsoft SQL Server 2005 - Update 'Service Pack 2 for SQL Server
Database Services 2005 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_KB921896_sqlrun_s ql.msp.log.
Event Type:Error
Event Source:MsiInstaller
Event Category:None
Event ID:10005
Date:5/3/2007
Time:6:37:35 PM
User:RLTESTENV002\Administrator
Computer:RLTESTENV002
Description:
Product: Microsoft SQL Server 2005 -- Error 29528. The setup has encountered
an unexpected error while Setting Internal Properties. The error is: Fatal
error during installation.
I can send the detailed log if you need it.
Hello,
From the error message "Error Description : MSP Error: 29528 The setup has
encountered an unexpected error while Setting Internal Properties. The
error is: Fatal error during installation", this is a known issue. This
issue occurs because of one of the following reasons:
An operation has removed the local groups for the initial installation of
SQL Server 2005.
An operation has changed the security identifiers (SID) for the local
groups.
Considering your SQL Server is not a clustered instance, please follow the
below steps to workaround the problem:
Warning: Serious problems might occur if you modify the registry
incorrectly by using Registry Editor or by using another method. These
problems might require that you reinstall your operating system. Microsoft
cannot guarantee that these problems can be solved. Modify the registry at
your own risk.
1. Remove the following registry subkeys that store SID settings:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.X\Setup\SQLGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.X\Setup\AGTGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.X\Setup\FTSGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.X\Setup\ASGroup
Note In these registry subkeys, MSSQL.X is a placeholder for the
corresponding value on a specific system. You can determine MSSQL.X on a
specific system by examining the value of the MSSQLSERVER registry entry
under the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance
Names\SQL\
2. Reinstall the SQL Server 2005 service pack or the SQL Server 2005 hotfix
package.
For more information about this issue, please refer to KB 925976:
<http://support.microsoft.com/default.aspx?scid=kb;EN-US;925976>
Please let em know if this resolve the problem. If you encounter any
further error, please also let's know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hello,
I'm still interested in this issue. If you have any comments or questions,
please feel free to let's know. We look forward to hearing from you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hello,
I had the same problem and your solution helped upgrade the Database
service, but not analysis service.
Any idea why ?
Thanks...
"Peter Yang [MSFT]" wrote:
> Hello,
> I'm still interested in this issue. If you have any comments or questions,
> please feel free to let's know. We look forward to hearing from you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
>
Error installing SQL 2005 SP2 KB 921896
I am running Windows 2003 Enterprise SP2 running SQL 2005 Enterprise and am
getting repeated failures applying SQL 2005 SP2. The error is always the
same (see below).
I have made sure that there are no disabled services in the SQL Server
family of services, but this does not appear to have helped. This SQL
installation is pretty minimal, basically just the Database Engine. The
services list is:
SQL Server (MSSQLSERVER) Started Automatic Local System
SQL Server Active Directory Helper Manual (was disabled) Network Service
SQL Server Agent (MSSQLSERVER) Started Automatic Local System
SQL Server Browser Manual (was disabled) Local System
SQL Server FullText Search (MSSQLSERVER) Started Automatic Local System
SQL Server VSS Writer Started Automatic Local System
from the summary:
----
--
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_KB92189
6_sqlrun_sql.msp.log
Error Number : 29528
Error Description : MSP Error: 29528 The setup has encountered an
unexpected error while Setting Internal Properties. The error is: Fatal erro
r
during installation.
from the event log:
Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 1023
Date: 5/3/2007
Time: 6:37:36 PM
User: RLTESTENV002\Administrator
Computer: RLTESTENV002
Description:
Product: Microsoft SQL Server 2005 - Update 'Service Pack 2 for SQL Server
Database Services 2005 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.
Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 10005
Date: 5/3/2007
Time: 6:37:35 PM
User: RLTESTENV002\Administrator
Computer: RLTESTENV002
Description:
Product: Microsoft SQL Server 2005 -- Error 29528. The setup has encountered
an unexpected error while Setting Internal Properties. The error is: Fatal
error during installation.
I can send the detailed log if you need it.Hello,
From the error message "Error Description : MSP Error: 29528 The setup has
encountered an unexpected error while Setting Internal Properties. The
error is: Fatal error during installation", this is a known issue. This
issue occurs because of one of the following reasons:
An operation has removed the local groups for the initial installation of
SQL Server 2005.
An operation has changed the security identifiers (SID) for the local
groups.
Considering your SQL Server is not a clustered instance, please follow the
below steps to workaround the problem:
Warning: Serious problems might occur if you modify the registry
incorrectly by using Registry Editor or by using another method. These
problems might require that you reinstall your operating system. Microsoft
cannot guarantee that these problems can be solved. Modify the registry at
your own risk.
1. Remove the following registry subkeys that store SID settings:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
Server\MSSQL.X\Setup\SQLGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
Server\MSSQL.X\Setup\AGTGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
Server\MSSQL.X\Setup\FTSGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
Server\MSSQL.X\Setup\ASGroup
Note In these registry subkeys, MSSQL.X is a placeholder for the
corresponding value on a specific system. You can determine MSSQL.X on a
specific system by examining the value of the MSSQLSERVER registry entry
under the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL Server\Instance
Names\SQL\
2. Reinstall the SQL Server 2005 service pack or the SQL Server 2005 hotfix
package.
For more information about this issue, please refer to KB 925976:
<http://support.microsoft.com/defaul...kb;EN-US;925976>
Please let em know if this resolve the problem. If you encounter any
further error, please also let's know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
<http://msdn.microsoft.com/subscript...ps/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscript...rt/default.aspx>.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello,
I'm still interested in this issue. If you have any comments or questions,
please feel free to let's know. We look forward to hearing from you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
getting repeated failures applying SQL 2005 SP2. The error is always the
same (see below).
I have made sure that there are no disabled services in the SQL Server
family of services, but this does not appear to have helped. This SQL
installation is pretty minimal, basically just the Database Engine. The
services list is:
SQL Server (MSSQLSERVER) Started Automatic Local System
SQL Server Active Directory Helper Manual (was disabled) Network Service
SQL Server Agent (MSSQLSERVER) Started Automatic Local System
SQL Server Browser Manual (was disabled) Local System
SQL Server FullText Search (MSSQLSERVER) Started Automatic Local System
SQL Server VSS Writer Started Automatic Local System
from the summary:
----
--
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_KB92189
6_sqlrun_sql.msp.log
Error Number : 29528
Error Description : MSP Error: 29528 The setup has encountered an
unexpected error while Setting Internal Properties. The error is: Fatal erro
r
during installation.
from the event log:
Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 1023
Date: 5/3/2007
Time: 6:37:36 PM
User: RLTESTENV002\Administrator
Computer: RLTESTENV002
Description:
Product: Microsoft SQL Server 2005 - Update 'Service Pack 2 for SQL Server
Database Services 2005 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.
Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 10005
Date: 5/3/2007
Time: 6:37:35 PM
User: RLTESTENV002\Administrator
Computer: RLTESTENV002
Description:
Product: Microsoft SQL Server 2005 -- Error 29528. The setup has encountered
an unexpected error while Setting Internal Properties. The error is: Fatal
error during installation.
I can send the detailed log if you need it.Hello,
From the error message "Error Description : MSP Error: 29528 The setup has
encountered an unexpected error while Setting Internal Properties. The
error is: Fatal error during installation", this is a known issue. This
issue occurs because of one of the following reasons:
An operation has removed the local groups for the initial installation of
SQL Server 2005.
An operation has changed the security identifiers (SID) for the local
groups.
Considering your SQL Server is not a clustered instance, please follow the
below steps to workaround the problem:
Warning: Serious problems might occur if you modify the registry
incorrectly by using Registry Editor or by using another method. These
problems might require that you reinstall your operating system. Microsoft
cannot guarantee that these problems can be solved. Modify the registry at
your own risk.
1. Remove the following registry subkeys that store SID settings:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
Server\MSSQL.X\Setup\SQLGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
Server\MSSQL.X\Setup\AGTGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
Server\MSSQL.X\Setup\FTSGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL
Server\MSSQL.X\Setup\ASGroup
Note In these registry subkeys, MSSQL.X is a placeholder for the
corresponding value on a specific system. You can determine MSSQL.X on a
specific system by examining the value of the MSSQLSERVER registry entry
under the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Mi
crosoft SQL Server\Instance
Names\SQL\
2. Reinstall the SQL Server 2005 service pack or the SQL Server 2005 hotfix
package.
For more information about this issue, please refer to KB 925976:
<http://support.microsoft.com/defaul...kb;EN-US;925976>
Please let em know if this resolve the problem. If you encounter any
further error, please also let's know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
<http://msdn.microsoft.com/subscript...ps/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscript...rt/default.aspx>.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello,
I'm still interested in this issue. If you have any comments or questions,
please feel free to let's know. We look forward to hearing from you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
Error installing SQL 2005 SP2 KB 921896
I am running Windows 2003 Enterprise SP2 running SQL 2005 Enterprise and am
getting repeated failures applying SQL 2005 SP2. The error is always the
same (see below).
I have made sure that there are no disabled services in the SQL Server
family of services, but this does not appear to have helped. This SQL
installation is pretty minimal, basically just the Database Engine. The
services list is:
SQL Server (MSSQLSERVER) Started Automatic Local System
SQL Server Active Directory Helper Manual (was disabled) Network Service
SQL Server Agent (MSSQLSERVER) Started Automatic Local System
SQL Server Browser Manual (was disabled) Local System
SQL Server FullText Search (MSSQLSERVER) Started Automatic Local System
SQL Server VSS Writer Started Automatic Local System
from the summary:
----
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_sql.msp.log
Error Number : 29528
Error Description : MSP Error: 29528 The setup has encountered an
unexpected error while Setting Internal Properties. The error is: Fatal error
during installation.
from the event log:
Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 1023
Date: 5/3/2007
Time: 6:37:36 PM
User: RLTESTENV002\Administrator
Computer: RLTESTENV002
Description:
Product: Microsoft SQL Server 2005 - Update 'Service Pack 2 for SQL Server
Database Services 2005 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_KB921896_sqlrun_sql.msp.log.
Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 10005
Date: 5/3/2007
Time: 6:37:35 PM
User: RLTESTENV002\Administrator
Computer: RLTESTENV002
Description:
Product: Microsoft SQL Server 2005 -- Error 29528. The setup has encountered
an unexpected error while Setting Internal Properties. The error is: Fatal
error during installation.
I can send the detailed log if you need it.Hello,
From the error message "Error Description : MSP Error: 29528 The setup has
encountered an unexpected error while Setting Internal Properties. The
error is: Fatal error during installation", this is a known issue. This
issue occurs because of one of the following reasons:
· An operation has removed the local groups for the initial installation of
SQL Server 2005.
· An operation has changed the security identifiers (SID) for the local
groups.
Considering your SQL Server is not a clustered instance, please follow the
below steps to workaround the problem:
Warning: Serious problems might occur if you modify the registry
incorrectly by using Registry Editor or by using another method. These
problems might require that you reinstall your operating system. Microsoft
cannot guarantee that these problems can be solved. Modify the registry at
your own risk.
1. Remove the following registry subkeys that store SID settings:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.X\Setup\SQLGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.X\Setup\AGTGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.X\Setup\FTSGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.X\Setup\ASGroup
Note In these registry subkeys, MSSQL.X is a placeholder for the
corresponding value on a specific system. You can determine MSSQL.X on a
specific system by examining the value of the MSSQLSERVER registry entry
under the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance
Names\SQL\
2. Reinstall the SQL Server 2005 service pack or the SQL Server 2005 hotfix
package.
For more information about this issue, please refer to KB 925976:
<http://support.microsoft.com/default.aspx?scid=kb;EN-US;925976>
Please let em know if this resolve the problem. If you encounter any
further error, please also let's know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello,
I'm still interested in this issue. If you have any comments or questions,
please feel free to let's know. We look forward to hearing from you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello,
I had the same problem and your solution helped upgrade the Database
service, but not analysis service.
Any idea why ?
Thanks...
"Peter Yang [MSFT]" wrote:
> Hello,
> I'm still interested in this issue. If you have any comments or questions,
> please feel free to let's know. We look forward to hearing from you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
>
getting repeated failures applying SQL 2005 SP2. The error is always the
same (see below).
I have made sure that there are no disabled services in the SQL Server
family of services, but this does not appear to have helped. This SQL
installation is pretty minimal, basically just the Database Engine. The
services list is:
SQL Server (MSSQLSERVER) Started Automatic Local System
SQL Server Active Directory Helper Manual (was disabled) Network Service
SQL Server Agent (MSSQLSERVER) Started Automatic Local System
SQL Server Browser Manual (was disabled) Local System
SQL Server FullText Search (MSSQLSERVER) Started Automatic Local System
SQL Server VSS Writer Started Automatic Local System
from the summary:
----
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_sql.msp.log
Error Number : 29528
Error Description : MSP Error: 29528 The setup has encountered an
unexpected error while Setting Internal Properties. The error is: Fatal error
during installation.
from the event log:
Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 1023
Date: 5/3/2007
Time: 6:37:36 PM
User: RLTESTENV002\Administrator
Computer: RLTESTENV002
Description:
Product: Microsoft SQL Server 2005 - Update 'Service Pack 2 for SQL Server
Database Services 2005 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_KB921896_sqlrun_sql.msp.log.
Event Type: Error
Event Source: MsiInstaller
Event Category: None
Event ID: 10005
Date: 5/3/2007
Time: 6:37:35 PM
User: RLTESTENV002\Administrator
Computer: RLTESTENV002
Description:
Product: Microsoft SQL Server 2005 -- Error 29528. The setup has encountered
an unexpected error while Setting Internal Properties. The error is: Fatal
error during installation.
I can send the detailed log if you need it.Hello,
From the error message "Error Description : MSP Error: 29528 The setup has
encountered an unexpected error while Setting Internal Properties. The
error is: Fatal error during installation", this is a known issue. This
issue occurs because of one of the following reasons:
· An operation has removed the local groups for the initial installation of
SQL Server 2005.
· An operation has changed the security identifiers (SID) for the local
groups.
Considering your SQL Server is not a clustered instance, please follow the
below steps to workaround the problem:
Warning: Serious problems might occur if you modify the registry
incorrectly by using Registry Editor or by using another method. These
problems might require that you reinstall your operating system. Microsoft
cannot guarantee that these problems can be solved. Modify the registry at
your own risk.
1. Remove the following registry subkeys that store SID settings:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.X\Setup\SQLGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.X\Setup\AGTGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.X\Setup\FTSGroup
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\MSSQL.X\Setup\ASGroup
Note In these registry subkeys, MSSQL.X is a placeholder for the
corresponding value on a specific system. You can determine MSSQL.X on a
specific system by examining the value of the MSSQLSERVER registry entry
under the following registry subkey:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance
Names\SQL\
2. Reinstall the SQL Server 2005 service pack or the SQL Server 2005 hotfix
package.
For more information about this issue, please refer to KB 925976:
<http://support.microsoft.com/default.aspx?scid=kb;EN-US;925976>
Please let em know if this resolve the problem. If you encounter any
further error, please also let's know. Thank you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello,
I'm still interested in this issue. If you have any comments or questions,
please feel free to let's know. We look forward to hearing from you.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello,
I had the same problem and your solution helped upgrade the Database
service, but not analysis service.
Any idea why ?
Thanks...
"Peter Yang [MSFT]" wrote:
> Hello,
> I'm still interested in this issue. If you have any comments or questions,
> please feel free to let's know. We look forward to hearing from you.
> Best Regards,
> Peter Yang
> MCSE2000/2003, MCSA, MCDBA
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
>
Subscribe to:
Posts (Atom)