.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

SQL Server 2008 R2 Installation and Service Pack 1 Question

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :Sql Server
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?   

View Complete Post

More Related Resource Links

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.


Installation of sql server 2008 r2 (64 bit) fails with a service error (error 1053: service does'nt


If i try to install sql server 2008 r2, i have always the same error message:

service does not respond in time limit, the error code is 1053

if i try to start the sql db engine service manually, i have the same error message

do you have a tip?

Installation of sql server 2008 r2 (64 bit) fails with a service error (error 1053: service does'nt


If i try to install sql server 2008 r2, i have always the same error message:

service does not respond in time limit, the error code is 1053

if i try to start the sql db engine service manually, i have the same error message

do you have a tip?



Installation of Microsoft SQL Server 2005 Express edition service pack 4 (KB2463332) fails with erro

I have Windows XP and I can't get the KB2463332 to install. The error code in my automatic update history is error code 0xD59I. It has been failing to install since the first of 2011. Even tried to do it manually and eventually got this message, "extraction failed hotfix.exe is not a valid win32 application. I have no idea which forum to choose so if I pick wrong one, please tell me what i should have picked.

Problem in Installation of SQL Server 2008


Dear All,

I have Sqlserver2008 setup.

It is work in wndows Xp.

But I have to Install it on Windows 7 ,during installation process it requires some patch and I am unable to get it.

Plz some buddy can help the same.


Rakesh gupta

SQL Server 2008 Installation issue in Windows 7 64 bit

I'm trying to install SQL 2008, but an error message keeps appearing: Microsoft .NET Framework 3.5 installation has failed. SQL Server 2008 Setup requires .NET Framework 3.5 to be installed.   My OS is Windows 7 Ultimate 64 bits, so already has de .NET Framework 3.5, I turned on/off a lot of times and the same error occurs! I download the .NET Framework 3.5 and .NET Framework 3.5 SP1 from the links: (http://www.microsoft.com/downloads/details.aspx?FamilyId=333325fd-ae52-4e35-b531-508d977d32a6&displaylang=en http://www.microsoft.com/downloads/details.aspx?familyid=AB99342F-5D1A-413D-8319-81DA479AB0D7&displaylang=en) But, when installing the Framework 3.5 or the SP1, I get the message: "Use turn on or off disable features in Windows control panel".   Someone can help me?! - Windows 7 Ultimate 64 bits - SQL Server 2008 Developer (x86, x64, ia64).   Thanks! Marcelo.

SQL Server 2005 - Installation in Cluster Environment - "Service SQL Server Browser (SQLBrowser) fai

Windows Server 2003 R2 Enterprise Edition SP2 32-bit All updates and patches installed Two-node cluster environment configured. Cluster functions perfectly. Trying to install SQL Server 2005 Enterprise Edition (32-bit) as a clustered application. Installation proceeds fine until it begins to install the SQL Server Database Services product. Status window says "Starting Services. Service: SQL Server Browser". Error message is presented: "Service 'SQL Server Browser' (SQLBrowser) failed to start. Verify that you have sufficient privileges to start system services". SQL Server Service Account is in the Administrators group on both local systems, and is a domain account. Account used for the installation is in the Administrators group on both local systems, and is a domain account. Have cancelled out of the install and rebooted both servers numerous times. Exact same error continues to occur. Cluster is active and all resources are owned by node #1 - the node where SQL Server Installation is being run. In the event viewer, I see: Event ID: 10 Description: The SQLBrowser service was unable to establish SQL instance and connectivity discovery". I am also seeing errors like: Source: SQLBrowser. The SQL configuration for SQL is inaccessible or invalid. Source: SQLBrowser. The Configuration of the AdminConnection\TCP protocol in the SQL instance xxxxxx i

How I can remove The Microsoft SQL Server 2008 Express installation manually.

How I can remove The Microsoft SQL Server 2008 Express installation manually ?   Other components uninstalled via Add/Remove but i cant remove SQL Server 2008 Express     From Add/Remove the following is installed:Microsoft SQL Server 2008   I have attempted to uninstall it via the Add/Remove method and this also failed.

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.

SQL Server 2008 - Installation Woe - .NET Framework 3.5 SP1

On a Windows 2003 R2 x64 server, I have been unable to install SQL Server 2008 Enterprise Edition x64. When running setup.exe, I almost instantaneously receive the following Microsoft SQL Server Setup error:"Microsoft .NET Framework 3.5 installation has failed.SQL Server 2008 Setup requires .NET Framework to be installed."What does not make sense is that I successfully downloaded .NET Framework 3.5 from the Microsoft download site (published 8/11/2008) prior to the SQL Server 2008 installation attempt.http://www.microsoft.com/downloads/details.aspx?familyid=ab99342f-5d1a-413d-8319-81da479ab0d7&displaylang=enI do need to note that a few nights ago, prior to downloading the framework (3.5 SP1), I ran the SQL Server 2008 setup executable. I was prompted that in order to install SQL Server 2008, the setup program needed to first install .NET 3.5 SP1 and Windows Installer 4.5. I let the .NET 3.5 SP1 install run for about 1.5 to 2 hours and cancelled (now I wish I had just let it go).It is my understanding (correct me if I am wrong) that the SQL Server 2008 setup program initially checks for any pre-RTM versions of .NET 3.5 SP1 Framework. If one is found, it is then supposed to guide the user through both the installation of the .NET 3.5 SP1 Framework and Windows Installer 4.5. I have removed .NET 3.5 SP1 Framework (Add/Remove programs) and rebooted. However, upon runni

SQL Server 2008 installation fails There was an error generating the XML document. Error code 0x84B

My system config: window XP - SP3 4 GB RAM, I have VS2008 with SP1, VS2010 Ultimate installed First when I tried to install SQL 2008 R2 Dev edition I got an error saying vs2008 SP1 was not installed, infact I had the SP1 installed in my m/c.  I did reinstalled the SP1 and tried to install SQL again. while in the final installation process I got the error  "Setup has encountered the following error: There was an error generating the XML document. Error code 0x84B10001." I uninstall the SQL server again to remove the files which were created from Unsuccessful installation I removed the register entry as suggested by this forum. reinstalled but no chance, I have tried all the option which I can get know in web. Please help me. here is the log files details  Exception type: Microsoft.SqlServer.Chainer.Infrastructure.ChainerInfrastructureException 2010-08-26 14:54:53 Slp:     Message: 2010-08-26 14:54:53 Slp:         There was an error generating the XML document. 2010-08-26 14:54:53 Slp:     Stack: 2010-08-26 14:54:53 Slp:         at Microsoft.SqlServer.Chainer.Infrastructure.DataStoreService.SerializeObject(String rootPath, Object objectToSerialize, Boolean saveToCache) 2010-08-26 14:54:53 Slp:   &nb

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