Learn more about SQL Server tools

mssqltips logo
giveaway
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Quick Guide to Upgrading to SQL Server 2014


By:   |   Read Comments (9)   |   Related Tips: More > Upgrades and Migrations

Problem

What are the steps involved in a simple upgrade to SQL Server 2014?  I am currently running an older version of SQL Server and want to do an in place upgrade.

Solution

In this tip, we will demonstrate an upgrade to SQL Server 2014.

Note: Before starting make sure you are connected to a network and have Internet access.

After you launch the SQL Server setup, the SQL Server Installation Center window will display. Along the left side of the window are the categories showing how the SQL Server Installation Center is organized. On the right side of the window are different actions the installer can take. Notice that some of the items allow the installer to view documentation while other items will make changes to the system. By default the Planning category is displayed.

Quick Guide to Upgrading to SQL Server 2014

Clicking on Installation on the left side will display the different installation options. For this tip, we will click on "Upgrade from SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012". This will launch the Upgrade to SQL Server 2014 application.

Upgrade from SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 or SQL Server 2012

The following pop-up window might appear several times throughout the installation process.

Upgrade to SQL Server 2014

The Upgrade to SQL Server 2014 application lists the steps it will follow on the left side of the window. Enter the product key and click "Next >".

MSSQLTips.com Sample Image

Review the license terms, click on "I accept the license terms", and then click "Next >".

"I accept the license terms"

The upgrade application will download, extract and install files needed to carry out the installation process. Click on "Next >" to continue.

The upgrade application will download, extract and install files needed to carry out the installation process.

Select the SQL Server instance to modify. Click on "Next >" to continue.

Select the SQL Server instance to modify

Sometimes a "Please Wait..." pop-up box might appear.

Sometimes a "Please Wait..." pop-up box might appear.

The next step is the feature selection. In the example shown below, all of the features will be upgraded. Click on "Next >" to continue.

In the example shown below, all of the features will be upgraded

The Instance Configuration screen allows the installer to specify the instance ID. This screen will also display other installed instances. In this example, the MSSQLSERVER instance on SQL Server 2012 will be upgraded to SQL Server 2014.

the MSSQLSERVER instance on SQL Server 2012 will be upgraded to SQL Server 2014.

The Server Configuration screen shows the services to be installed, the service account name and the Startup Type. If you are installing SQL Server 2014 on a device with limited resources then the Startup Type should be set to Automatic (Delayed Start) instead of Automatic. Click on "Next >".

The Server Configuration screen shows the services to be installed

The Full-text Upgrade screen provides three Full-Text upgrade options (import, rebuild and reset).

The Full-text Upgrade screen provides three Full-Text upgrade options (import, rebuild and reset).

The Feature Rules screen will execute a rule check to make sure the upgrade process should successfully.

The Feature Rules screen will execute a rule check to make sure the upgrade process should successfully.

The Ready to Upgrade screen displays all of the features and prerequisites to be installed or upgraded. At this point, the installer can still go back to make changes or quit the process. Click on "Upgrade" to begin the upgrade of the SQL Server 2014 components.

Click on "Upgrade" to begin the upgrade of the SQL Server 2014 components.

The upgrade progress bar tracks the status of the upgrade.

The upgrade progress bar tracks the status of the upgrade.

Upon completion of the installation, click on "Close" to exit the Upgrade to SQL Server 2014 application.

Upon completion of the installation, click on "Close" to exit the Upgrade to SQL Server 2014 application.

The SQL Server Installation Center can now be closed.

Next Steps

It is a good idea to reboot and run Windows Update to allow updates to be installed. Please check our collection of other SQL Server 2014 tips on MSSQLTips.com that are listed below.



Last Update:






About the author
MSSQLTips author Dallas Snider Dr. Dallas Snider is an Assistant Professor in the Computer Science Department at the University of West Florida and has 18+ years of SQL experience.

View all my tips
Related Resources





More SQL Server Solutions











Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


Get free SQL tips:

*Enter Code refresh code     



Thursday, September 08, 2016 - 8:13:54 AM - Christoph Back To Top

It´s required to kill the SQL-Services before starting the upgrade


Thursday, August 25, 2016 - 6:10:58 AM - Himesh Back To Top

 

 Thanks this helped me upgrade my SQL 2012 to SQL 2014 in one go.

 


Sunday, July 17, 2016 - 7:29:53 PM - Matt Back To Top

Hi,

Thanks for the tutorial,very handy!

it looks i successfuly done inplace upgrade from 2008R2 to 2014 on my sccm 2012r2. my question is, should i uninstall the 2008 one afterward or just leave it and keep using the 2014 mgm studio?

Thanks,

Mateo

 


Thursday, February 18, 2016 - 4:36:45 PM - Maruf Rahman Back To Top

 

Hi,

In my environment, my assignment is below:

Question: upgrade database server from sql server 2008 R2 enterprise edition to sql server 2014 standard edition.

My manager wants to know my feedback on it. will here any situation can happen for the enterprise to standard edition. What are those? And please let me know all about the scenario to done that? I will highly appreciate for that. Thanks

 

Respectfully

Maruf

 

 

 


Monday, August 17, 2015 - 10:51:27 AM - swoozie Back To Top

Can you upgrade from 2012 to 2014 and add clustering in one fell swoop with out too much catastrophe?

 

 

 

 

 

 

 

 


Monday, June 01, 2015 - 12:43:09 PM - SP Back To Top

Good instructions!!! Used them often.

 


Wednesday, January 21, 2015 - 11:44:22 AM - Abhishek Dadarya Back To Top

I want to make disaster recovery site of database in sql server 2014.

Please provide us the method through Mirroring technique.


Wednesday, January 21, 2015 - 11:42:25 AM - Abhishek Dadarya Back To Top

I have install sql server 2014 and restore the database from sql server 2005.

 

Is it the correct way to upgrade the database from sql server 2005 to sql server 2014.

 


Friday, June 06, 2014 - 3:45:44 PM - Sri Back To Top

Nice and clean!!


Learn more about SQL Server tools