Solved

Error when patching SQL Server 2005

Posted on 2013-10-22
4
578 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
Comment Utility
0
 
LVL 1

Author Comment

by:cloughs
Comment Utility
No it hasnt worked.  Any more ideas?
0
 
LVL 1

Accepted Solution

by:
cloughs earned 0 total points
Comment Utility
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
Comment Utility
Question got ignored by the experts :(
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
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…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

771 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now