In-place Upgrade from SQL Server 2008R2 to SQL Server 2014

Currently I am running an older version of SQL Server 2008R2 and want to perform an in place upgrade to SQL Server 2014.

Upgrades from Earlier Versions to SQL Server 2014 :

SQL Server 2014 supports upgrade from the following versions of SQL Server:

  • SQL Server 2005 SP4 or later
  • SQL Server 2008 SP3 or later
  • SQL Server 2008 R2 SP2 or later
  • SQL Server 2012 SP1 or later

Now the first thing to do is to download SQL Server 2014 media directly from Microsoft. Once the downloading is finished, double click the file to begin the installation. 

After launching the SQL Server setup, the SQL Server Installation Center window will display. Clicking on Installation TAB 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.

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

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

The Global Rules TAB will check if there any Rules failed to stop this Installation or not

Here I have SLIP STREAMED SQL 2014 Media with SP3 and HotFix So, that we can eliminate Multiple Reboots of Server and also SAVING TIME. From below ScreenShot we can observe the difference of Include SQL Server Product Updates checkbox ENABLED  ( Service Pack 3 and HotFix which was added to Installation Media )

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

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

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

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 2008R2 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 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 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.

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.

As you will be instructed that you will eventually need to restart your computer for the changes to take place

Verify that all Features show as Succeeded in the Status column, then click Close.

Finally, restart your computer. Once your computer is restarted, Connect to your Instance and see the Upgraded SQL Server 2014.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.