?
Solved

Error when patching SQL Server 2005

Posted on 2013-10-22
4
Medium Priority
?
600 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

WordPress Tutorial 2: Terminology

An important part of learning any new piece of software is understanding the terminology it uses. Thankfully WordPress uses fairly simple names for everything that make it easy to start using the software.

Question has a verified solution.

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

There are many software programs on offer that will claim to magically speed up your computer. The best advice I can give you is to avoid them like the plague, because they will often cause far more problems than they solve. Try some of these "do it…
In the absence of a fully-fledged GPO Management product like AGPM, the script in this article will provide you with a simple way to watch the domain (or a select OU) for GPOs changes and automatically take backups when policies are added, removed o…
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…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

764 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