.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

Upgrading SQL Server 2008 Enterprise Evaluation to SQL 2008 Enterprise

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

Dear users,

I ran Upgrade successfully. After upgrading when I checked the version of SQL Server it is still evaluation version having 20 days to expire. I am expecting to see something different. I don't expect to see remaining days of expiration. After applying upgrade I logged off and logged back on. Was I supposed to shut down my desktop?

What went wrong? While upgrading I didn't encounter any error.


Thank you for your support.



View Complete Post

More Related Resource Links

Upgrade SQL server 2008 R2 from Evaluation Edition to Enterprise Edition

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  

How to extend sql server 2008 enterprise evaluation


I have a client that someone installed the enterprise 2008 sql server evaluation edition on a production server. We just found out about this issue a couple of days ago. Yesterday we ordered SQL server 2008 standard edition from dell through volume licensing. Today dell told us that they were not sure how soon the fulfillment on this would happen. I have in the last few hours talked with Microsoft Volume Licensing and Pro Support.  Volume licensing worked hard to find a way to expedite the order or find a work around for us on the server to keep the evaluation edition running for a bit longer to make sure it doesn't turn itself off before we can install the full version we have purchased. They refereed us to Pro Support when they were unable to find a fix. Pro support sent us to a few weblinks that didn't address the issue and then told us to post our question here as they were unable to help us.

Is there anyway to extend the trial version by a few days to give us a bit of a grace period to allow the fullfulment on our Full Version SQL Server 2008 standard to show up?

I very much would appreciate any help that anyone can give me on this issue. If the evaluation license expires before we install the upgrade it will shut my client down cold as in out of business.

Thank you,

Scott Carle
Carle Enterprises, Inc.

Using SQL Server 2008 R2 client with Enterprise Library



I am modifying an existing application that uses SQL Server 2008 as the database and Enterprise Library 4.1 for Data Access .

What I need to do is to make it use the SQL Server 2008 R2 client to take advantage of out of the box failover capabilities.

Any idea how I can accomplish this?


Can't install SQL Server 2008 Enterprise on Windows 2008 Enterprise

A new fresh Windows 2008 installed and install all avaliable updates. Then install SQL server 2008, it firstly install some update too. Then reboot and run setup.exe again, it always give me the following message:Managed SQL Server Installer has stopped workingWhat's wrong with it? how to solve this issue?

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

Problem with upgrade from SQL 2008 Express to SQL Server 2008 Enterprise

I use the wizard "Maintenance > Edition Upgrade". When I choose the instance of SQL Express 2008 and click Next I get the error "Rule SQL 2008 edition upgrade failed. The selected SQL Server instance does not meet upgrade matrix requirements."What can I do to ugrade ?

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

Network error when installing SQL Server 2008 Enterprise

Hi guys, I'm trying to install an SQL Server 2008 Enterprise on Windows Server 2008 R2 Standard and I've got an network error:   TITLE: Microsoft SQL Server 2008 Setup ------------------------------ The following error has occurred: A network error occurred while attempting to read from the file: C:\Publico\en_sql_server_2008_enterprise_x86_x64_ia64_dvd_x14-89207\x64\setup\x64\SQL93C3.tmp.msi For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.0.1600.22&EvtType=0xDF039760%25401201%25401 ------------------------------ BUTTONS: OK ------------------------------   I don't know why a network error, because I'm intalling from an local .ISO file. Thanks, Luciano

SQL 2008 R2 problems on a Windows 2008 R2 Enterprise server

We are receiving the following error message when installing SQL 2008 R2 on a Windows 2008 R2 Enterprise server. "Unhandled exception has occurred in your application. if you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately. It specialist

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?

Installing SQL Server 2008 R2 Enterprise on Windows 7 - Setup Suport Files

The problem is when i try to install a new instance of SQL Server 2008 R2 Enterprise the wizard stops working when is trying to install Setup Support Files, and nothing happens. I cannot add the entire log file of the instalation, so i leave only the last lines. : ---------------------------------------------------------------------- 2010-09-10 11:46:24 Slp: Skipping Action: FinishPage 2010-09-10 11:46:24 Slp: Action is being skipped due to the following restrictions: 2010-09-10 11:46:24 Slp: Condition "Is the user's scenario set to EditionUpgrade" did not pass as it returned false and true was expected. 2010-09-10 11:46:24 Slp: ---------------------------------------------------------------------- 2010-09-10 11:46:24 Slp: Skipping property RequireMode of class: StopAction 2010-09-10 11:46:24 Slp: Input of property will not be set due to the following failed restriction(s): 2010-09-10 11:46:24 Slp: Condition "Is the user's scenario set to ComponentUpdate" did not pass as it returned true and false was expected. Can you help me?    

Can't remove SQL Server Enterprise 2008 R2

I accidentally installed the enterprise version of SQL. I'm trying to remove it but it keeps erroring out with 1618 errors and I'm not sure. Here are the parts of the log with the failures.   Detailed results:   Feature:                       Database Engine Services   Status:                        Failed: see logs for details   MSI status:                    Failed: see details below   MSI error code:                0x1618   MSI log file location:         C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20100914_160715\sql_fulltext_Cpu64_1.log   MSI error description:           MSI status:                    Failed: see details below   MSI error code:                0x1618   MSI

SQL Server Enterprise Manager for SQL Server 2008



I need to install SQL Server Enterprise Manager to run with SQL Server 2008 to define the email settings which will help me to send email through transact sql. Can anyone any link from Microsoft to download ?

Also, Is there any other way to define settings for SQL Email which should not include any further installation with the current SQL Server 2008 ?


Sohaib Khan | http://muhskhac.spaces.live.com

Slow sql-server after upgrade from SQL-Server 2005 x64 standard to SQL-Server 2008 R2 x64 enterprise


We moved our databases to new hardware today (using copy database wizard)


The new hardware should be better than the old one.

We went from 28 GB ram to 128 GB.

We went from 16 cores to 32 cores (with even more cache etc.). We also moved from external SAN with 40 disks to intern disks (8 Samsung SS805 100gb ssd slc)

                             According to our own metrics we could get twice the IO using IO m

Microsoft SQL Server 2008 Enterprise Installation Problem


Good evening!

I downloaded Microsoft SQL Server 2008 Enterprise Edition (x86 and x64) from MSDNAA (i study computer science) and also  Windows 7 Professional (x86). I installed Windows 7 and i tried to install SQL Server but i receive the "Microsoft .NET Framework 3.5 installation has failed. SQL Server 2008 Setup requires .NET Framework 3.5 to be installed." error. I tried installing .NET Framework but it doesn't work because it's installed by default with Windows 7 (i checked the "Turn Windows features on or off" page and the "Microsoft .NET framework 3.5.1" checkbox is checked). I understand that this means .NET framework 3.5 SP1 is also installed so i shouldn't have any errors.

Can anyone help me with this installation problem?

Thank you!

Upgraded SQLServer 2008 Enterprise Evaluation after 180 day period expired...Services start but stil



I have a SQLServer 2008 Enterprise (180 day eval) installation that had expired.

I downloaded and intalled SQLServer 2008 Enterprise (Full version) from Technet

and ran the "Version Upgrade" tool.

The Upgrade tool correctly identified the expired instance and reported that it

had successfully upgraded the expired instance.

The OS processes will start but when I attempt a connect, I get a "Evaluation Period Expired"

error message.

Is it possible to do an "upgrade in place" after the 180 day evaluation has expired or do

you have to uninstall then re-install ?

Many Thanks in Advance,

Hobson Black

Can I install SQL 2008 on a server running SQL 2005 to install Sharepoint 2010 Enterprise (Productio



Sharepoint 2010 Upgrade Question - A customer is currently running sharepoint 2007 on a 64bit windows 2003 OS with SQL 2005 sp2, they are looking to install/upgrade to Sharepoint 2010 and want to use the current SQL server,for the upgrade a new SharePoint 2010 environment will be built and for a short while they will have two instances of SharePoint running SP2007 and SP2010. The plan is to then manually migrate the data from SP2007 to SP2010 (ENT), the web and application servers will be newly built. From research I think they have three options

1) Upgrade the current SQL 2005(SP2) instance to SQL 2008 R2 standard.

2) Install a new instance of SQL 2008 R2 on the same server and have both SQL 2005 & SQL 2008 running on the same server (Is this an option? Will sharepoint happily run from a SQL server running two SQL instances, do I have to be careful regarding the installation and configuration, could I break the existing sharepoint farm doing this?)

3) Upgrade the current SQL server to SP3 and install a new instance of SQL 2005 SP3 and install SharePoint 2010 Enterprise here, again I have all the questions from point 2 above.

We are thinking of trying option 1, then 2, then 3, and obviously only moving to the next option if we come across a show stopper. H

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