Trouble Installing Cumulative Update 2

Question

Post reply

Trouble Installing Cumulative Update 2

chelleatl

Old Hand

Points: 378
More actions
November 5, 2009 at 7:03 am

#385718

I have been trying to apply CU2 to my MS SQL 08 which is SP1, version 10.0.2531.0
1) I got the hotfix (SQLServer2008-KB958186-x64.exe) from Microsoft and extract it to my C: drive.
2) I double click to open SQLServer2008-KB958186-x64.exe and it does extracts a folder to my e drive.
3) Program entitled "Install a SQL Server Patch" opens up.
4) I click oK
5) I accept the license terms
6) On the select features page, I can't select/unselect any features, so I click ok.
7) Then I get a error window that tells me to check to see what are the validation error.
8) The error I get is "There are no SQL Server instances of shared features that can be updated on this computer.".
I'm stuck. WHat do I do now?

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

chelleatl Old Hand Points: 378 More actions · Answer 1

Just to make things more interesting, when I ran

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

I got the following results:

10.0.2531.0SP1Standard Edition (64-bit)

But when I opened C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\Summary.txt file, the version for the Database Engine Services is 10.1.2531.0.

andrewkane17 SSCertifiable Points: 7529 More actions · Answer 2

Is the hotfix the 64 bit version meant for your chip set, definitley not X86?

Andrew

EdVassie SSC Guru Points: 60478 More actions · Answer 3

You have downloaded CU2 for SQL 2008 RTM, not CU2 for SQL 2008 SP1. You need the KB970315 file.

Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

support.sql Default port Points: 1444 More actions · Answer 4

You are trying to install a wrong CPU2, the correct one is

Cumulative update package 2 for SQL Server 2008 Service Pack 1

http://support.microsoft.com/kb/970315

RTM

===

Cumulative Update 2 contains hotfixes for the Microsoft SQL Server 2008 issues that have been fixed since the release of SQL Server 2008.

Note This build of the cumulative update package is also known as build 10.00.1779.00.

SP1

===

Cumulative update package 2 for SQL Server 2008 Service Pack 1 contains hotfixes for the Microsoft SQL Server 2008 issues that have been fixed since the release of SQL Server 2008 Service Pack 1.

Note This build of the cumulative update package is also known as build 10.00.2714.

SNM

Try Free Microsoft SQL Server Data Collector & Performance Monitor.

http://www.analyticsperformance.com[/url]

@nalyticsperformance - Microsoft SQL Server & Windows Server Free Data Collector

SequelDBA Ten Centuries Points: 1093 More actions · Answer 5

I am encountering a similar problem. I am trying to apply SQL 2008 Cumulative Update 7 for SP1. When I execute SQLServer2008-KB979065-x86.exe

- Click Next to accept license terms

- The next screen under Shared Service is only BOL

What's up with that? When I apply the update the engine and RS show -

Thanks...

KU

SequelDBA Ten Centuries Points: 1093 More actions · Answer 6

SequelDBA

Ten Centuries

Points: 1093

March 18, 2010 at 2:13 pm

#1136300

The version should be 10.00.2766.00

KU