patch failed ... help - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Database Design and Application Architecture

patch failed ... help

Author

Topic

zaty2405
Yak Posting Veteran

58 Posts

Posted - 2010-02-14 : 02:55:24

hi,

please help... urgent

my production failed with following error:

The product instance SSISPRD does not have prerequisite update 4035 installed.
Update 4207 is dependent on prerequisite update 4035. Exit setup and refer to the Knowledge Base article to find the prerequisite patch.
Install the prerequisite and rerun the installation.
----------------------------------------------------------------------------------
please help
Thanks you

Kristen
Test

22859 Posts

Posted - 2010-02-14 : 03:12:41

Just guessing, but are you trying to install

SQL Server 2005 SP3 CU1

without having first installed SQL Server 2005 SP3?

What does SELECT @@VERSION say? and what service pack are you trying to apply?

Check this link for descriptions of values of @@VERSION

http://www.sqlteam.com/article/sql-server-versions

zaty2405
Yak Posting Veteran

58 Posts

Posted - 2010-02-14 : 03:24:14

Hi Kristen,

Yes I tried to install SQL Server 2005 SP3 CU1

SELECT @@VERSION
Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

this is tje summary.txt:

Time: 02/14/2010 07:36:55.245
KB Number: KB959195
Machine: AMSDC2-S-6146
OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 2 (Build 3790)
Package Language: 1033 (ENU)
Package Platform: x64
Package SP Level: 3
Package Version: 4207
Command-line parameters specified:
/quiet
/instancename=SSISPRD
Cluster Installation: No

**********************************************************************************
Prerequisites Check & Status
SQLSupport: Passed

**********************************************************************************
Products Detected Language Level Patch Level Platform Edition
SQL Server Database Services 2005 (SSISPRD) ENU SP2 2005.090.3042.00 x64 ENTERPRISE
SQL Server Integration Services 2005 ENU SP3 9.00.4035.00 x64 ENTERPRISE
SQL Server Tools and Workstation Components 2005 ENU SP3 9.3.4035 x64 ENTERPRISE

**********************************************************************************
Products Disqualified & Reason
Product Reason
SQL Server Database Services 2005 (SSISPRD) The product instance SSISPRD does not have prerequisite update 4035 installed. Update 4207 is dependent on prerequisite update 4035. Exit setup and refer to the Knowledge Base article to find the prerequisite patch. Install the prerequisite and rerun the installation.

**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID

**********************************************************************************
Product Installation Status
Product : SQL Server Database Services 2005 (SSISPRD)
Product Version (Previous): 3042
Product Version (Final) :
Status : NA
Log File :
Error Description : The product instance SSISPRD does not have prerequisite update 4035 installed. Update 4207 is dependent on prerequisite update 4035. Exit setup and refer to the Knowledge Base article to find the prerequisite patch. Install the prerequisite and rerun the installation.
----------------------------------------------------------------------------------
Product : SQL Server Integration Services 2005
Product Version (Previous): 4035
Product Version (Final) : 4207
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\DTS9_Hotfix_KB959195_sqlrun_dts.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------
Product : SQL Server Tools and Workstation Components 2005
Product Version (Previous): 4035
Product Version (Final) : 4207
Status : Success
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQLTools9_Hotfix_KB959195_sqlrun_tools.msp.log
Error Number : 0
Error Description :
----------------------------------------------------------------------------------

**********************************************************************************
Summary
Success
Exit Code Returned: 0

-- should i revert back the patch? how do i do that?

Thanks

zaty2405
Yak Posting Veteran

58 Posts

Posted - 2010-02-14 : 03:54:45

help... please

Kristen
Test

22859 Posts

Posted - 2010-02-14 : 06:11:13

So did you try installing SQL Server 2005 SP3? (i.e. NOT the CU1 version)

zaty2405
Yak Posting Veteran

58 Posts

Posted - 2010-02-14 : 06:49:20

hi kristen,

i forgot to paste this error which occur together with the earlier err message that i paste :

roduct : Database Services (SSISPRD)
Product Version (Previous): 3042
Product Version (Final) :
Status : Failure
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB955706_sqlrun_sql.msp.log
Error Number : 28112
Error Description : MSP Error: 28112 Setup failed because Service MSSQLServerADHelper is disabled for the current hardware profile.
Services must be set with the current Hardware Profile logon property profile enabled.
For more information on how to enable the hardware profile logon property refer to the product documentation.
----------------------------------------------------------------------------------

What actually went wrong ? will try to install the sp3 fix this? this is my prod server

Thanks

wildstyle
Starting Member

5 Posts

Posted - 2010-02-23 : 03:43:12

Service Pack 3 is a pre-requisite of installing any POST SP3 cumulative updates.

http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en

just install SP3 first and then install 4207.

for reference ...
http://support.microsoft.com/kb/960598

regards
Gavin

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources