error handling flow: sp2

Showing posts with label sp2. Show all posts

Thursday, March 29, 2012

Error loading resource string in SP2

After I installed the SP2 and reboot the server, when I try to print the a
report, it keep pop up the error message say"Error loading resource string",
after I click many times, I got the printer properties window, many text in
the button are disappear, but I still could print it out.
Any idea?
ThanksMy guess is that you had the beta of SP2. If so then you need to clear out
then per Brian Welcker (MS): You need to clean out any older versions of the
controls from your C:\WINDOWS\Downloaded Program Files directory.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"msnews.microsoft.com" <huangxiaohua@.hotmail.com> wrote in message
news:uYZWGkxSFHA.2304@.tk2msftngp13.phx.gbl...
> After I installed the SP2 and reboot the server, when I try to print the a
> report, it keep pop up the error message say"Error loading resource
string",
> after I click many times, I got the printer properties window, many text
in
> the button are disappear, but I still could print it out.
> Any idea?
> Thanks
>

Error installing SQL2005 SP2

I'm trying to install SP2 for SQL 2005 on Win 2003 sp1. Right now 2005 is installed as a named instance with a 2000 instance running on the same box.

I get this in the log files:

<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Wed May 23 10:09:03 2007
<Func Name='Do_sqlPerfmon2'>
Error copying file(C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSSVCPERF.INI) to file(C:\Program Files\Microsoft SQL Server\90\DTS\Binn\perf-DTSSVCPERF.INI). Error code 2
MSI (s) (5C!64) [10:09:03:671]: Transforming table Error.

MSI (s) (5C!64) [10:09:03:688]: Transforming table Error.

MSI (s) (5C!64) [10:09:03:688]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 1603
MSI (s) (5C!64) [10:09:03:723]: Transforming table Error.

MSI (s) (5C!64) [10:09:03:740]: Transforming table Error.

MSI (s) (5C!64) [10:09:03:740]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (5C!64) [10:09:03:740]: Product: Microsoft SQL Server 2005 Integration Services -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.

Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.

<EndFunc Name='LaunchFunction' Return='1603' GetLastError='0'>
MSI (s) (5C:38) [10:09:03:757]: User policy value 'DisableRollback' is 0
MSI (s) (5C:38) [10:09:03:757]: Machine policy value 'DisableRollback' is 0
Action ended 10:09:03: InstallFinalize. Return value 3.

Can you please check to see if you have the appropriate permissions for the DTSSVCPERF.INI. The error seems to indicate there is a problem copying the file.

Error copying file(C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSSVCPERF.INI) to file(C:\Program Files\Microsoft SQL Server\90\DTS\Binn\perf- DTSSVCPERF.INI). Error code 2

|||upon closer inspection I seem to be missing that file for some reason... how do I get it back?
|||Do you have any other server where in you can check to see if you can copy it from there?. I am not sure how the file went missing in the first place. If you dont have any other server then I would suggest that you perform a fresh installation of SQL 2005 on a test box and copy it to your production server.

Tuesday, March 27, 2012

Error installing SQL Server 2005 SP2 (KB 921896)

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.
> >
> >
> >
>
>

Error installing SQL Server 2005 SP2 (KB 921896)

Error installing SQL server 2005 SP2 - "Machine does not have a product that matches the in

Hi,

While I am trying to install SQL server 2005 I get the following message - "Machine does not have a product that matches the installation package". The installation does not occur.

I am using Windows 2000 Professional SP4 and using 32 bit installer - SQLServer2005SP2-KB921896-x86-ENU.exe

Help would be appreciated... thanks.

Regards,

Ravindranath Kini

Other than Sql server 2005 enterprise edition you can install everything with Windows 2000 SP..........can you provide the details available in Summary.txt file available in C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG.

Refer the system requirements http://technet.microsoft.com/en-us/library/ms143506.aspx

|||

SQLServer2005SP2-KB921896-x86-ENU.exe is service pack only. Did you installed SQL Server 2005 on your computer? Moreover, this service pack doesn't support SQL Server 2005 Express Edition (Microsoft SQL Server 2005 Service Pack 2 http://www.microsoft.com/downloads/details.aspx?FamilyID=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&DisplayLang=en). For SQL Server 2005 Express Edition SP2, please download from http://msdn2.microsoft.com/en-us/express/bb410792.aspx.

|||

Deepak,

The details of Summary.txt are available here.

Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Uninstall : Successful , Reboot required
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0004_BNGWIP-D-99927_SQLSupport_1.log
--
Product : MSXML 6.0 Parser (KB933579)
Product Version : 6.10.1200.0
Uninstall : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0004_BNGWIP-D-99927_MSXML6_1.log
--
Setup succeeded with the installation, inspect the log file completely for status on all the components.

Time : Tue Aug 21 12:08:04 2007

The setup is installing only MSXML6. It is not installing the SQL Server 2005.

Warren,

I am trying to install SP2 directly witout installing the SQL server 2005 base version. Will it not work?

Thanks for the replies,

Error installing SQL server 2005 SP2 - "Machine does not have a product that matches the in

Hi,

While I am trying to install SQL server 2005 I get the following message - "Machine does not have a product that matches the installation package". The installation does not occur.

I am using Windows 2000 Professional SP4 and using 32 bit installer - SQLServer2005SP2-KB921896-x86-ENU.exe

Help would be appreciated... thanks.

Regards,

Ravindranath Kini

Refer the system requirements http://technet.microsoft.com/en-us/library/ms143506.aspx

|||

Deepak,

The details of Summary.txt are available here.

Time : Tue Aug 21 12:08:04 2007

The setup is installing only MSXML6. It is not installing the SQL Server 2005.

Warren,

I am trying to install SP2 directly witout installing the SQL server 2005 base version. Will it not work?

Thanks for the replies,

Error installing SQL server 2005 SP2 - "Machine does not have a product that matches the in

Hi,

While I am trying to install SQL server 2005 I get the following message - "Machine does not have a product that matches the installation package". The installation does not occur.

I am using Windows 2000 Professional SP4 and using 32 bit installer - SQLServer2005SP2-KB921896-x86-ENU.exe

Help would be appreciated... thanks.

Regards,

Ravindranath Kini

Refer the system requirements http://technet.microsoft.com/en-us/library/ms143506.aspx

|||

Deepak,

The details of Summary.txt are available here.

Time : Tue Aug 21 12:08:04 2007

The setup is installing only MSXML6. It is not installing the SQL Server 2005.

Warren,

I am trying to install SP2 directly witout installing the SQL server 2005 base version. Will it not work?

Thanks for the replies,

Error installing SQL Express 2005 SP1 on XP Home/SP2

As the subject says, I am getting an error installing SQL Express 2005 SP1 on XP Home/SP2. I have never had a previous version of SQL server installed. I have never had Visual Studio installed. I have tried extracting the setup files and running from a different directory. I have tried installing the advanced package as well with the same results.

When I run the setup, the Client and support files are successfully installed. It then goes on to the system analysis, where I get one warning about my hardware but I have checked the help file and my system appears to meet the system requirements. After I click Next from this window is where I get the error,
"Error writing to file: Access is denied.
. Verify that you have access to that directory."

After looking into the log files I see this,

Error Code: 0x80070005 (5)
Windows Error Text: Access is denied.
Source File Name: t:\yukon\sql\setup\darwin\sqlcastub\streamca.cpp
Compiler Timestamp: Wed Dec 21 16:49:23 2005
Function Name: streamBinaryToDisk
Source Line Number: 238
Error 1304. Error writing to file: Access is denied.
. Verify that you have access to that directory.

Does anyone know what is wrong? I have installed this on many W2K machines at work as well as installed the full version of SQL Server 2005. I have never seen these errors on any of those machines. This is the first XP machine I have ever tried to install on so I am not sure if this is an OS problem or not.

Thanks in advance.

I have the same problem (win xp pro sp2), please help us....

thank you

|||

Are you familar with using regedit? If so, can you post the contents of the "BootstrapDir" and "WYukonBootstrapDir" values (if they exist), in the "HKLM\Software\Microsoft\Microsoft SQL Server\90" key?

|||

R. Green - MSFT wrote:
Are you familar with using regedit? If so, can you post the contents of the "BootstrapDir" and "WYukonBootstrapDir" values (if they exist), in the "HKLM\Software\Microsoft\Microsoft SQL Server\90" key?

I will check that as soon as I get home, thanks.|||Here is what I have for the BootstrapDir, C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\|||

That is the correct value. The custom action should be running with the credentials of the user running setup, which in this case would be your logged in account. Setup is trying to create a file in a "Bin" subfolder of that directory. Could you use Windows Explorer to navigate to that folder and see if you are able to create that directory? Also check to see if it the folder already exists and if it has any files. If so, try to delete the entire folder. Let me know what you find out, thanks!

|||

Could you also post the line(s) in the log immediately prior to what you posted earlier. There should be line(s) like this:

Property(SQL): Setup Bootstrap Directory = c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\
1: 0 2: Iterating through _sqlSupportFiles entries
0:Watson 1:1304 2:StreamSupportFiles 3:streamBinaryToDisk 4:32 5:t:\yukon\sql\setup\darwin\sqlcastub\streamca.cpp 6:238 7:sqlcastub.dll 8:sqlrun.msi

I would like to confirm that it is actually reading the correct value from the registry. Thanks!

|||Unfortunately I will have to wait to get home again, as that is where the PC with the problem is. I will reply as soon as I can with the requested info.

Thanks for your time as it is much appreciated,
Scott|||

R. Green - MSFT wrote:
Could you also post the line(s) in the log immediately prior to what you posted earlier. There should be line(s) like this:
Property(SQL): Setup Bootstrap Directory = c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\
1: 0 2: Iterating through _sqlSupportFiles entries
0:Watson 1:1304 2:StreamSupportFiles 3:streamBinaryToDisk 4:32 5:t:\yukon\sql\setup\darwin\sqlcastub\streamca.cpp 6:238 7:sqlcastub.dll 8:sqlrun.msi
I would like to confirm that it is actually reading the correct value from the registry. Thanks!

Here is the whole chunk again but with the extra you asked for and more, but I don't see exactly what you were looking for though:

MSI (c) (CC:B4) [23:45:05:931]: Doing action: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action 23:45:05: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2. Extracting custom action file from stream
Action start 23:45:05: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2.
MSI (c) (CC:70) [23:45:05:941]: Invoking remote custom action. DLL: C:\DOCUME~1\Owner\LOCALS~1\Temp\MSIB9.tmp, Entrypoint: StreamSupportFiles
MSI (c) (CC:3C) [23:45:05:941]: Cloaking enabled.
MSI (c) (CC:3C) [23:45:05:941]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (CC:3C) [23:45:05:941]: Connected to service for CA interface.
Property(SQL): Setup Bootstrap Directory = C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\
1: 0 2: Iterating through _sqlSupportFiles entries
Error Code: 0x80070005 (5)
Windows Error Text: Access is denied.
Source File Name: t:\yukon\sql\setup\darwin\sqlcastub\streamca.cpp
Compiler Timestamp: Wed Dec 21 16:49:23 2005
Function Name: streamBinaryToDisk
Source Line Number: 238
Error 1304. Error writing to file: Access is denied.
. Verify that you have access to that directory.
MSI (c) (CC!B8) [23:45:07:684]: Product: Microsoft SQL Server 2005 Express Edition -- Error 1304. Error writing to file: Access is denied.
. Verify that you have access to that directory.

Action ended 23:45:07: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 3.
MSI (c) (CC:B4) [23:45:07:684]: Skipping action: FatalError (condition is false)
Action ended 23:45:07: INSTALL. Return value 3.
MSI (c) (CC:B4) [23:45:07:684]: Destroying RemoteAPI object.
MSI (c) (CC:3C) [23:45:07:694]: Custom Action Manager thread ending|||I also noticed this in the CORE log file:

Loaded DLL:C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\sqlsval.dll Version:2005.90.2047.0
<EndFunc Name='DwLaunchMsiExec' Return='1603' GetLastError='0'>
Complete: InvokeSqlSetupDllAction at: 2006/10/2 23:45:8, returned false
Error: Action "InvokeSqlSetupDllAction" failed during execution.
Action "AnalyzeInstallStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "PrepareForChainingStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "SequenceChainingActionsStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Action "InstallChainedPackagesStage" will be skipped due to the following restrictions:
Condition "Action: InvokeSqlSetupDllAction has finished and passed." returned false.
Running: ReportChainingResults at: 2006/10/2 23:45:8
Error: Action "ReportChainingResults" threw an exception during execution.
DwLaunchMsiExec() returned : 1603
Error Code: 0x80070643 (1603)
Windows Error Text: Fatal error during installation.

Source File Name: sqlchaining\sqlchainingactions.cpp
Compiler Timestamp: Mon Jan 16 02:06:13 2006
Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3140

Error: Failed to add file :"C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_NOTEBOOK_.NET Framework 2.0.log" to cab file : "C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\SqlSetup0001.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2006/10/2 23:45:9
Message pump returning: 1603
|||

Thanks for the follow-up. Did you notice if any files were there already in the directory? Were you able to create the "Bin" folder if it didn't exist? Can you also try to create a file in the "Bin" subfolder?

The logs look like it is trying to create the right file in the right spot, so if you are able to create files by hand there is a mystery going on here.

|||

R. Green - MSFT wrote:
Thanks for the follow-up. Did you notice if any files were there already in the directory? Were you able to create the "Bin" folder if it didn't exist? Can you also try to create a file in the "Bin" subfolder?
The logs look like it is trying to create the right file in the right spot, so if you are able to create files by hand there is a mystery going on here.

Sorry it took so long getting back to you. Actually as it turns out, I cannot create a file in the Bin directory. I am logged in as a user with Administrative rights but not as Administrator. Could that be the problem?|||

That would be the cause of the problem, although I'm not sure how the permissions got screwed up. You shouldn't need to run as the Administrator account, running with an account that is a member of the Administrators group is good enough.

You could try logging in as Administrator and deleting the folder, which would delete the bogus ACL's on it. Then log back in again with your regular account and try setup once more. I assume this will work since setup doesn't have problems creating files in the other folders under "Setup Bootstrap", it seems localized to just the "Bin" folder.

|||Ok, I finally got it installed. It is important to note that I am running Windows XP Home. You cannot login as Administrator in Home unless in safe mode. Here is what I did,

1) Run the setup for SQL Server Express 2005. When it fails, restart the computer in Safe Mode.
2) Login to Safe Mode as the Administrator.
3) In File Explorer right click on the c:\Program Files\Microsoft SQL Server directory. Change the permissions to full control for all administrators.
4) Restart into normal mode and login as the same user you originally started the installation with.
5) Re-run the installation, without uninstalling the failed installation.
6) It should install without a problem now.

I am going to assume that this is a problem with XP Home not allowing the use of the Administrator account in normal mode. If anyone ever figures out exactly what the problem is I would love to know.

Good luck to all, and thanks for all the help.

Scott

Thursday, March 29, 2012

Error loading resource string in SP2

Error installing SQL2005 SP2

Tuesday, March 27, 2012

Error installing SQL Server 2005 SP2 (KB 921896)

Error installing SQL Server 2005 SP2 (KB 921896)

Error installing SQL server 2005 SP2 - "Machine does not have a product that matches the in

Error installing SQL server 2005 SP2 - "Machine does not have a product that matches the in

Error installing SQL server 2005 SP2 - "Machine does not have a product that matches the in

Error installing SQL Express 2005 SP1 on XP Home/SP2

error handling flow

Blog Archive

About Me