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

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

Upgrade SQL server 2008 R2 from Evaluation Edition to Enterprise Edition

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
Hello SQL Support group, I have SQl server 2008 R2 installed on a Win 2003 R2 and it is for our SharePoint and Project server 2007 environment. Today I noticed that we have only 75 days left! Seems like we installed it on evaluation mode. Here what we have on Helpàabout : Microsoft SQL Server Management Studio Complete (expires in 75 days)    10.50.1352.12 We do have MSDN account, and we have the KEY that comes with the SQL server 2008 R2 enterprise. We would like to assign the key to our SQl server ( we want to have enterprise edition). It is in a production environment now. I would like to know how we can do it  with minimum of down time. I found this link: http://blogs.technet.com/b/sqlman/archive/2010/03/16/sql-server-2008-upgrading-to-standard-enterprise-edition-from-evaluation-edition.aspx On the internet, but doesn’t say anything that we are losing any data after upgrade or not. Please let us know the best way to assign the key, and if it has any impact in our data. Thanks Bahram  

View Complete Post

More Related Resource Links

SQL Server 2008 performance: Decision to spend budget to upgrade to enterprise edition

Hi, Currently, we use SQL Server 2008 standard edition. We are planning to improve the performance of our application. The application is built by 3<sup>rd</sup> party and we can’t change/modify database objects and they seem to be designed fine. The options are spending our budget to upgrade to sql server hardware, or upgrade to SQL Server Enterprise edition. I am a bit confused over the benefits of SQL Server Enterprise edition. The following chart suggests that SQL EE includes “Parallel Index Operations” and “Enhanced Read-ahead and Scan”: http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx  How significant are “Parallel Index Operations” and “Enhanced Read-ahead and Scan”? Considering the fact that new hardware is cheaper than sql enterprise license, Should I spend budget to upgrade enterprise edition instead of buying as server with faster CPU and RAM? Thank you, Max

how many open connection is recommended to leave - in sql server 2008 Enterprise Edition

hi i have my C# program that work with sql-server 2008 Enterprise Edition i have 40 users that connect to this database. i dont close the connection. how many open connection is recommended to leave ? or is it better to close connection ? thank's in advance

How to install Sql server 2008 Enterprise edition in windows 7 (32 bit system)

am install Sql server 2008 SP1 But same Problem again Plz Give me Reply Plzzzzzzzzzz Which edition Support in windows 7?

SQL Server 2008 trial edition upgrade process



What is the upgrade path from the trial edition to the registered Enterprise edition?


can I just type in a number somewhere, or do I need to do a complete reinstall?


how can I find out exactly how many days left in the trial?

Usage of SQL Express from Microsoft Windows Server 2008 R2 Enterprise Edition (64-bit) to Windows 7

Microsoft Visual Studio 2010 was being used along with SQL Express for website development on the Operating System, Windows Server 2008 R2 Enterprise Edition of Intel Xeon CPU @ 2.13 GHz (2 Processors) containing 12 GB RAM with 64-bit Operating System. Website was developed along with the databases of SQL Express with the help of Visual Studio. Whether the developed website along with the databases may be used on the Operating System, Windows 7 of 64-bit? The website will used within Intranet. Which Operating System and configuration to be used for the Intranet Website? Kindly guide me.

Upgrade SQL Server 2008 Standard Edition to 2008 R2

I'm trying to find the right down load to use to upgrade SQL Server 2008 Standard Edition to Standard Edition R2.  This is the first upgrade I've done for SQL Server and I can't find any download for R2 that is specifically for Standard Edition.  Can anyone point me in the right direction please?

Unable to "upgrade" SQL 2008 Enterprise to Standard Edition - Error: the credentials you provided fo


I already tried changing the logon account for SQL services and still receive the error.

Please help.

SQL Server 2008 R2 -Windows 7 Enterprise edition



Can i install SQL Server 2008 R2 64bit enterprise edition on windows 7 enterprise edition machine??


SQL Server 2008 R2 Enterprise edition -Win 7 enterprise machine


Can i load SQL server 2008 R2 enterprise edition on Windows 7 Enterprise edition 64 bit OS machine??


Problem while installing SQL Server 2008 Enterprise Edition on Window server 2003 x64 OS


I am trying to install SQL Server 2008 Enterprise Edition on Windows Server 2003 x64 OS.

I have followed below steps:

  • Installed .NET Framwork 3.5 SP1 on the system.
  • Installed Windows Installer v4.5
  • then tried to execute the setup.exe of SQL Server 2008.

Am getting below error:

"Microsoft .NET Framework 3.5 Installation has failed."

"SQL Server 2008 requires .NET Framework to be installed."

Please suggest me on how to proceed further with this installation.





Error in installing SQL Server 2008 enterprise/Developer edition.


Hi, I am trying to install sqlserver 2008 enterprise edition.

I hv already installed vs-2010 professional.

OS-windows7 Ultimate

Throwing error like :


Please help...........


SQL Server 2003 Enterprise to SQL server 2008 developer edition


Hi Experts,

   I want to change SQL Server 2005/2008 Enterprise to SQL server 2005/2008 developer edition, without uninstall the Product.

Please Help urgent bases.






sql server 2005 enterprise edition is required


sql serve 2005 enterprise edition is required to work with microsoft enterprise blocks


MS Word Component Not Getting Created on Windows 2008 64 bit Web Server Edition When I Try Using ASP

Hi All, This might look like a similar question to a lot of you considering there are a lot of web activity happening in terms of blogs/forums/suggestions that I have seen with reference to changes that one needs to do in COM+ Services to enable their ASP.NET Web Application to be able to create Word Objects & I have actually used them personally & they worked for me on Windows 2003 32 bit/64 bit servers. The issue started some 1 month back when I was told that we are upgrading our server to Windows 2008 Web Server edition 64 bit ‘cause of some real benefits it offers if used only as a web server. This was just great as we tested a lot of features /functionality that we were using on our existing server & everything seems to be working just fine on this product by Microsoft. However we also have one web module which is responsible for opening up a MS Word 2007 template file at runtime and fill it with data & is then converted into a PDF document. A lot of ideas on Web suggested that we should move onto Open XML standards to generate documents at runtime, which I have been able to do with no issues. But one activity which still requires me to create a Word document is when I have to convert/SaveAs the Word (docx) document into PDF. I tried all the COM+ & registry related changes that I did on my Windows 2003 64 bit server, but nothing seems

Cannot install SQL 2008 Enterprise edition

Hello , i am trying to install SQL 2008 Enterprise edition (trial) on my computer and i reached a stage of installation progress which showed the failure of the Analysis, Reporting, Integration, and Business intelligence. This is showing all failed, so what do i do?  

sql server 2008 R2 Developer Edition

I am having trouble finding a place to actually purchase the developer edition of Sql Server 2008 R2. I went to CDW and they provide the ability to purchase a developer license but don't provide the actual software. Where can I actually purchase the developer edition without subscribing to MSDN? Thanks Royal

Does SQL 2005 Enterprise Edition come preloaded on Windows Server 2003 Virtual Server.

Does SQL 2005 Enterprise Edition come preloaded on  Windows Server 2003 Virtual Server. I found this link http://www.microsoft.com/downloads/details.aspx?FamilyID=77f24c9d-b4b8-4f73-99e3-c66f80e415b6&displaylang=enMr Shaw
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