.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Installing service pack for SQL 2008 (SQL 2008 R2) after cumulative update packages

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :


First of all, sorry for my English. I have a question.

Whether we should first remove cumulative update packages before install service pack in SQL 2008 (SQL 2008 R2) as it was in SQL 2005?

 I don't found such information in available links, for example http://support.microsoft.com/kb/958734/en-us



View Complete Post

More Related Resource Links

Problem installing Cumulative Update 6 for SQL 2008 SP1 on Windows XP

I am attempting to apply SQL Server 20008 SP1 Cumulative Update 6 on my Windows XP desktop. The update executable is unpacked and I get a brief flash of a Command Screen and then nothing. I have searched for any update files but have not found any. My Desktop Configuration: Windows XP SP3, Windows Installer 4. SQL Server 2008 SP1 Developer Edition. I am also attempting to install the Client Tools for SQL 2008R2 on this same desktop and am getting the same results. I click on SETUP and get a brief flash of the Command Screen and the installation does not continue. Internet searches speak of a problem with a registry entry in the Boostrap Key for a valid Setup directory, but this key exists in my desktop registry. Thanks,

SQL Server 2008 offline while installing Cumulative update


I've been asked to install SQL 2008 CU 10 for SP1 and was wondering if the sql server is still available during the install of the cumulative update.  Is a restart necessary after installing a cumulative update?  I don't have a test machine and I need to apply it to a production server.


Cumulative Update CU4 For SSRS 2008

trying to download CU4 For SSRS 2008 SP1, I'm confused as to what the different suffixes mean at the end of the CU name, I seeRRB2ClickOnSNACRSSharepoinCan someone explain to me what these are or what the differences are?  SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_CU_Updated_Ref_KB_976761 2008 10.00.2740.00 237625057 11/4/2009 7:06:28 PM SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_Cumlative_Update_4_RRB2ClickOn 2008 10.00.2734.00 122189228 9/22/2009 4:18:56 PM SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_Cumlative_Update_4 2008 10.00.2734.00 237547729 9/22/2009 7:13:01 AM SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_Cumulative_Update_4_SNAC 2008 10.00.2734.00 7012764 9/22/2009 7:23:53 AM SQL Server 2008 All (Global) x64 sp1 SQL_Server_2008_SP1_Cumlative_Update_4_RSSharepoin

SQL Server 2008 R2 Installation and Service Pack 1 Question

I am migrating a SQL 2000 server to a SQL 2008 R2 server (on different physical servers) . When I ordered SQL Server 2008 the volume licensing allowed me to download sql server web 2008, sql server web 2008 R2 and sql server 2008 service pack 1. I don't know why I have three options to download. Don't I just need to just install the sql server 2008 Web R2? Are there any sql 2008 R2 service packs available?   

Service pack for SQL Server 2008 R2

Hi all, I did SQL Server 2008 R2  Installation,I want update with Service packs,Please help what are latest services packs available.       Thanks in AdvanceSNIVAS

SQL Server 2008 R2 Service Pack or Hotfix for ReportExecutionService2005 broken with IMAGE/EMF

Posted by edwardforgacs on 8/23/2010 at 4:13 AM
Vlad_MSFT, any update on the ExecutionInfo.NumPages workaround? It's well over a month since you posted to this thread and by the looks of it I'm not the only person who is unable to get any useful information out of that.

As Bob_eBlueprint mentioned, it always seems to return zero. Do you actually have a tested code sample where it works?
Posted by edwardforgacs on 7/20/2010 at 2:11 AM
Yes, ExecutionInfo does not return the number of pages properly either. I have tried every possible combination including GetExecutionInfo, GetExecutionInfo2, before and after render, and combined with Render, and Render2. Guess we need to open another bug about GetExecutionInfo not working in 2008 either?
Posted by Bob_eBlueprint on 7/9/2010 at 10:32 AM
I tried using the code posted by JasonRAC, but I am not getting an exception thrown when I try to render a page that doesn't exist. Instead a zero byte array is returned. So I'm using code like this to stop rendering when the end of the report is researched:

        Dim DidPageLoad As Boolean
        Dim TempPage As Byte()

Cumulative Update 5 - wrong SQL 2008 version number


Hi all,

I installed Service Pack 1 for SQL 2008 on one of my servers. This server has multiple instances. In this case, it is the instance "SHAREPOINT2010" that is giving me difficulties.

For Sharepoint 2010, we need to install cumulative update 5. This update fails due to the fact I do not have the correct SQL version. It is expecting version 10.0.2531 (SP1), but it says I have the 10.0.1600 (RTM). When I check in my management studio and via the @@version, I do see the confirmation I have version 10.0.2531. (also see attached screenshot).

Does anyone know why the cumulative update fails to see the correct server version ? If I try to install it on another SQL 2008 SP1, it works fine..;

Thank you !



screenshot sql version

Removing SQL 2008 R2 Cumulative Update 3


Cumulative Update 3 completely destroyed my SQL 2008 R2 installation.  We were hoping it resolved some of the issue we are seeing with R2 but unfortunately now SQL will not start.  Is there any way to completely remove cumulative update 3 from the server?  We are running SQL 2008 R2 on Server 2008 r2 x64. 

Any insight will be greatly appreciated. 



Trouble installing SQL Server 2008 Cumulative 4


I have a server that is currently at 10.00.2723 (CU3).  I want to patch it to 10.00.2734 (CU4).  The service pack installer tells me that it can not find an instance of SQL Server on the machine.

SQL Server 2008 Enterprise x64
Windows Server 2008 R2 x64
This is a VM using VMware

Any body have suggestions, run into this before, etc..?



Cannot download Cumulative update package 2 for SQL Server 2008 !


Hi all,


I currently need to install Cumulative update package 2 for SQL Server 2008 service pack 1.

It is located at :


When i click on View and request hotfix downloads it has the following error :

Unfortunately it says "The system is currently unavailable. Please try back later"


Where can i fin this package ?


I need to install this to finish off the installation of Sharepoint 2010.


SQLXML 4.0 with Service Pack 1 - Do I Need With SQL Server 2008 R2


I am in the middle of doing a Biztalk Server 2010 install on a developer machine. In the instructions it reads:

SQLXML 4.0 with Service Pack 1  Enables XML support for your SQL Server database and allows developers to bridge the gap between XML and relational data. You can create an XML view of your existing relational data and work with it as if it were an XML file. To install SQLXML 4.0 SP1, see Microsoft SQL Server 2008 Feature Pack (http://go.microsoft.com/fwlink/?LinkID=189325).


My question is, do I still need to install this if I'm using SQL Server 2008 R2 Developer?  Thanks.


MS SQL 2008 R2 service pack


I have a question / issue realated to the installtion of SQL server 2008 R2. I just installed SQL 2008 R2 on a new windows 2008 R2 server. I had no issues during the this straigh forward install. After the install I went to Microsoft website to search for any latest service packs \ updates that might be available. I noticed that SQL 2008 server has 2 service packs available, (SP1 and SP2) The requirments state that these SP will work with any version of SQL server 2008. In my mind, any flavor would include SQL server 2008 R2. After downloading the SPs I attempted to install only to receive an error stating that the installer was expecting to see SQL version 10.50.1600.22 when my version is 10.50.1600.1.

So my questions are... Are these service packs applicable to SQL server 2008 r2? are there any service packs available for SQL server 2008 R2?

thanks in advance

David Hunt

Trouble installing SSRS 2008 R2, XP Pro SP3, can't access Web Service or Report Manager URLs


I found a great thread by Uday titled "SQL 2008 Reporting Services Win XP SP2" and worked through it, but I am still stumped.

I am using port 8080 cause this was default.  I tried changeing to 80, but it didn't help, so changed back.  IIS is using port 80 and is currently stopped.

I see both databases in SQL Server and can query while logged in as Account that is used for the service account.  SSRS is running. 

URL reservations look good in the rsreportserver.config file.  In Native mode.

While in RS Config Manger I can test database connection and it is good.  When I click the webservice URL or the Report Manger URL in the Config Manager I get errors "Web site can not be found" and "Website can not display page"  I just upgraded to IE 8.  Can't figure out what to do next.

When I use httpcfg.exe I see a URL for http://+:8080/ReportServer/   and http://+:80/Reports/.  This could be the problem.  How can I chages seconfd to port 8080?

Any help would be appreciated.



cumulative update 4 for 2008 R2


Has anyone succeeded in downloading this in the last week?  Whenever I click on the link to request a hotfix (i.e. download the update), it says "try back later":


Thank you.

Unable to extract SQL Server 2008 SP1 Cumulative Update 2 executable.



Requested the SQL Server 2008 SP1 CU2 hotfix and got an email with the location (see below) and password.

KB Article Number(s): 960616, 961106, 961760, 961811, 963061, 965217, 967206, 967337, 967561, 967983, 967984, 968085, 968290, 968449, 968834, 968900, 969007, 969131, 969235, 969362, 969469, 969588, 969775, 969872, 970070, 970184, 970198, 970255, 970315, 970461, 970550
Language: All (Global)
Platform: x64
Location: (http://hotfixv4.microsoft.com/SQL%20Server%202008/sp1/SQL_Server_2008_SP1_Cumulative_Update_2/10.00.2714.00/free/381569_intl_x64_zip.exe)

Ran the executable  381569_intl_x64_zip.exe and get prompted for the password.    Doesn't accept the password supplied in the same email.    No error, just nothing happens and nothing is extracted.

Password is 6 characters long and starts with a pound sign (#).

Trying the download again after a second request.    Noticed the password is the same.

Any ideas?


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend