.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

MS SQL 2008 R2 service pack

Posted By:      Posted Date: October 19, 2010    Points: 0   Category :Sql Server

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

View Complete Post

More Related Resource Links

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()

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.


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



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





C++ Plus: Beef Up Windows Apps with the Visual C++ 2008 Feature Pack


Kenny Kerr sings the praises of the new Visual C++ 2008 Feature Pack, which brings modern conveniences to Visual C++.

Kenny Kerr

MSDN Magazine May 2008

Net Framework 3.5 service pack Failure to instal

Microsoft .NET Framework 3.5 Service Pack 1 and .NET Framework 3.5 Family Update for .NET versions 2.0 through 3.5 (KB951847) x86 tries to instal but fails without any reason as I am running XP professional can anyone explain why as I have all the previos updates. after trying to instal I come up with this error Installation Failure Error Code: 0x80070645

.net Framework 2.0 Service Pack 2

I am trying to clear space on my old hard drive. I have Service Pak 2, 3 & 3.5. Question is can I delete the older versions without jepordizing the performance of my computer? cannudigit

SQL Server 2005 Express Edition Service Pack 3 (KB955706) update is successful but repeats installin

  Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) (update 1 of 1) This update seems to be stuck in a loop of installing, each time it successfull installs acccording to automatic updates. Then says it requires installing again straight away. This has been happening for 10 days now. I have tried a manual update from the website rather than automatic updates, no change. Any ideas why? Have posted in Windows update which is where I think the problem lies but they have suggested I post here also.

Microsoft SQL Server 2005 Express Edition Service Pack 3 (KB955706) - will not download.install on W

I have tried and tried unsuccessfully to get this download to install properly. I get no error message at all but it quite clearly is not working properly. This has all ready taken me hours and hours of my time with no success (after following the fixes mentioned on this site). I look forward to suggestions at to how to proceed that may actually work. Many thanks cdbc81

Which SQL Server 2005 Express Edition Service Pack to Install?

I have Windows 2008 Small Business Server Standard Edition.  When I scan for updates I get two different SQL service packs showing up, with the same KB955706 number.  I'm wondering which I should install, or if both, what order to install them in?  The first one is labeled: Microsoft SQL Server 2005 Express Edition Service Pack 3 The second one is labeled: Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 3 For applications, I have Blackbaud The Financial Edge v7.78 (accounting package for clubs) installed that uses SQL Server 2005 Express Edition for its database engine.  The new upgrade for this software requires SP3 which is why I need to know which service pack to install.  Also, please let me know if there are any tricks to getting the service packs installed on 2008 SBS Standard Edition.  I know sometimes registry settings need to be changed for SQL service packs to be installed properly. Thank you for your help.  

Windows service can't use Reporting Services on SQL Service 2008 R2

Hello. I have a Windows service that run as Local System account. The service uses the Reporting Services ReportService2005.asmx web service. When I have SQL Server 2008 installed, I have no problems and my service is able to browse and create report. After I have installed SQL Server 2008 R2 I get the error "The request failed with HTTP status 401: Unauthorized." when the service tries to use the web service. If I change my service to log on as a user with administrator rights, it is able to use Reposting Services again. What has changes in SQL Server 2008 R2, that doesn't allow the Local System account to use Repoting Services? And is it possible to configure Reporting Services to allow it?   - Per

SQL Agent - service account permissions - SQL Server 2008

Hi @ all   I installed two SQL Server 2008 on Server 2008 R2 Std (principal and mirror) and an AD Server 2008, with sperate service accounts, connect as SA, localy all works fine. I created some agent tasks (PowerShell, T-SQL), but I get some Error massages in the history, that service account of SQL Agent didn't have the permission to query a remote machine(access denied for wmi (HRESULT: 0x80070005 (E_ACCESSDENIED)) and linked database(SQLSTATE 42000 Error(7314)). The simple query with SA permissions on the remote machine works and the powershell scripts with the local domain user works too. But not with the SQL Agent. WHY?? Where ist the different between the user account permisions and service account permissions? Which settings are needed? Example: get-wmiobject -class win32_service -computername 192.168.xxx.xxx| where {$_.name -like '*SQL*'} Powershell Console: works                                     SQL Agent Job: access denied I tried some solutions with user rights, group policies and security permissions but nothing works. like: Configuration -Service Accounts, SQL Server or SQL Server Agent service account http://support.microsoft.com/kb/283811/en-us http://msdn2.microsoft.com/

SSMS 2008 - Shows Service Status as Stopped Though Service is started

Hi, I have a SQL Server 2008 - Active/Passive Cluster. The issue I am facing here is that, when I do a Failover from Node A to Node B, All the Cluster Services come online and the SQL Services are running (checked using the SQL Configuration Manager and Services console). However when I open the management studio, The Service status Indicator shows a Red Block mark against the ServerName and the SQL Server Agent. When I try connecting to the server remotely from another server, the status is displayed correctly in the SSMS(i.e the green sign with the arrow) .  This issue happens when I locally login to the server and connect using ssms. I am an Admin on both the boxes and even the service account with which the services run also has admin privileges. Any pointers? Thanks,
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