Upgrading SQL Server software to SQL Server 2014 SP4 Express software - Metasys - LIT-12012240 - Server - SQL Server - 11.0

SQL Server Installation and Upgrade Guide
Brand
Metasys
Product name
SQL Server
Document type
Installation Guide
Document number
LIT-12012240
Version
11.0
Revision date
2021-02-05
Product status
Active
Language
English

About this task

The steps in this section apply to upgrading any of the following versions of SQL Server software:

  • SQL Server 2012 Express
  • SQL Server 2008 R2 Express
  • SQL Server 2008 Express
  • SQL Server 2005 Express
Note: If SQL Server Management Studio is installed on your computer, uninstall it before you upgrade, then install an updated version of the tool after you install SQL Server 2014 Express software.

Procedure

  1. To upgrade a previous version of SQL Server Express to SQL Server 2014 SP3 Express, click this link, download and run SQLEXPRWT_x64_ENU.exe.
  2. To extract the files to a temporary location on your hard disk and begin the update, double-click the SQL Server installation files that you downloaded.
  3. If a User Access Control dialog box prompts you for permission to make changes to the computer related to installing SQL Server 2014 software, click Yes. The message Please Wait While SQL Server 2014 Setup processes the current operation appears as the installation begins.
  4. The Planning menu is the first screen to appear. In the right pane, several options are available for you to explore. To continue, click Installation in the left pane. The selections in the right pane change.
  5. To begin installation, click Upgrade from SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, or SQL Server 2012 in the right pane of the screen. The License Terms screen appears.
  6. In the License Terms screen, read the License Terms agreement and then click I accept the license terms. Click Next. The Setup Support Files screen appears.
  7. In the Setup Support Files screen, click Install to install the necessary support files.
  8. A report appears that lists the results of this setup support files test. If any prerequisite fails, you need to exit the installation and fix that issue. For more information, click the Failed cell. (Warning reports can be ignored at this point.) Click Next.
  9. The Select Instance screen appears, indicating the names of the SQL Server instances currently installed. The example is of a SQL Server 2012 SP2 Express software instance. Select the instance used by Metasys software, which is most likely MSSQLSERVER. You cannot rename the database instance during an upgrade. Click Next. The Select Features screen appears.
  10. The Select Features screen may appear to indicate the Instance ID that is ready to be upgraded. During an upgrade, you cannot select any additional features. Click Next. The Feature Rules screen appears.
  11. A Feature Rules test is run. Verify that no tests fail. If a test failed, you need to exit the installation and correct the issue before continuing. Click the Failed cell for more information. Click Next. The Installation Progress screen appears.
  12. The Installation Progress screen appears as the SQL Server 2014 Express software installs. This part of the procedure can take over 15 minutes to complete. When Setup process complete appears above the progress bar, click Next. The Complete screen appears.
  13. From the Start menu, select Programs or All Programs > Microsoft SQL Server 2014 > Configuration Tools > SQL Server Configuration Manager.
  14. Expand SQL Server Network Configuration and select Protocols for MSSQLSERVER.
    Note: If you have a different named instance, that name appears instead of MSSQLSERVER.
  15. In the right pane of the window, do the following:
    1. Verify that Named Pipes is set to Enabled. If it is Disabled, right-click Named Pipes and select Enable.
    2. Click OK to the SQL Server software restart warning message that appears.
    3. Verify that TCP/IP is set to Enabled. If it is Disabled, right-click TCP/IP and select Enable.
    4. Click OK to the warning message.
    5. Close the SQL Server Configuration Manager.