Improve company productivity with a Business Account.Sign Up

x
?
Solved

Error when patching SQL Server 2005

Posted on 2013-10-22
4
Medium Priority
?
612 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I. Introduction There's an interesting discussion going on now in an Experts Exchange Group — Attachments with no extension . This reminded me of questions that come up here at EE along the lines of, "How can I tell the type of file from its cont…
This tutorial is about creating a new Microsoft Online User Profile account along with how to transfer your files and settings. You may be faced with this situation if your existing user profile has become corrupted.
The viewer will learn how to successfully create a multiboot device using the SARDU utility on Windows 7. Start the SARDU utility: Change the image directory to wherever you store your ISOs, this will prevent you from having 2 copies of an ISO wit…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

579 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