Solved

Error when patching SQL Server 2005

Posted on 2013-10-22
4
590 Views
Last Modified: 2013-11-18
Hello,

Security Update KB970895 for SLQ Server 2005 SP2 fails to install for the following reason.  What do we do next to get around this issue?

Setup Log shows this:

Products Detected                         Language  Level  Patch Level       Platform  Edition
SQL Server Database Services 2005 (ACT7)  ENU       SP1    2005.090.2170.00  x86       EXPRESS
SQL Server Database Services 2005 (MSSQLSERVER)  ENU       SP2    2005.090.3042.00  x86       STANDARD
SQL Server Analysis Services 2005 (MSSQLSERVER)  ENU       SP4    2005.090.5000.00  x86       STANDARD
SQL Server Notification Services 2005     ENU       SP4       9.00.5057.00  x86       STANDARD
SQL Server Integration Services 2005      ENU       SP4       9.00.5057.00  x86       STANDARD
SQL Server Tools and Workstation Components 2005  ENU       SP4           9.4.5057  x86       STANDARD

**********************************************************************************
Products Disqualified & Reason
Product                                   Reason
SQL Server Database Services 2005 (ACT7)  The product instance ACT7 has had update 2170 applied. You cannot install GDR update 3080 overtop update 2170. An update of build equal to or greater than 3353 should be downloaded.
SQL Server Database Services 2005 (MSSQLSERVER)  Service was found to be disabled
SQL Server Analysis Services 2005 (MSSQLSERVER)  The product instance MSSQLSERVER has had update 5000 applied. You cannot install GDR update 3080 overtop update 5000. An update of build equal to or greater than 3353 should be downloaded.
SQL Server Notification Services 2005     The product instance NS has had update 5057 applied. You cannot install GDR update 3080 overtop update 5057. An update of build equal to or greater than 3353 should be downloaded.
SQL Server Integration Services 2005      The product instance Integration Services has had update 5057 applied. You cannot install GDR update 3080 overtop update 5057. An update of build equal to or greater than 3353 should be downloaded.
SQL Server Tools and Workstation Components 2005  The product instance SQL Tools has had update 5057 applied. You cannot install GDR update 3080 overtop update 5057. An update of build equal to or greater than 3353 should be downloaded.


Thanks
0
Comment
Question by:cloughs
  • 3
4 Comments
 
LVL 13

Expert Comment

by:Alexios
ID: 39593667
0
 
LVL 1

Author Comment

by:cloughs
ID: 39593678
No it hasnt worked.  Any more ideas?
0
 
LVL 1

Accepted Solution

by:
cloughs earned 0 total points
ID: 39646427
Managed to resolve this myself by reinstalling SQL Server 2005 then re-service packing it in sequence.
0
 
LVL 1

Author Closing Comment

by:cloughs
ID: 39656012
Question got ignored by the experts :(
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Microsoft Surface -- Factory Reset ? 5 36
Simulate file lock 5 32
PerfMon Report Time Out 6 26
Problem to file 4 21
A Bare Metal Image backup allows for the restore of an entire system to a similar or dissimilar hardware. They are highly useful for migrations and disaster recovery. Bare Metal Image backups support Full and Incremental backups. Differential backup…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This video Micro Tutorial explains how to clone a hard drive using a commercial software product for Windows systems called Casper from Future Systems Solutions (FSS). Cloning makes an exact, complete copy of one hard disk drive (HDD) onto another d…
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question