Upgrading SQL Server software to SQL Server 2014 SP3 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
  • SQL Server 2008 R2
  • SQL Server 2008
  • SQL Server 2005

Procedure

  1. Run the SQL Server 2014 SP3 software installation file.
  2. Click Yes if a User Access Control dialog box prompts you for permission to make changes to the computer related to installing SQL Server 2014 software. The message Please Wait While SQL Server 2014 Setup processes the current operation appears as the installation begins.
  3. 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.
  4. 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.
  5. In the License Terms screen, read the License Terms agreement and then click I accept the license terms. Click Next. The Install Setup Files screen appears, showing the download and installation progress of any necessary setup files.
  6. A report may appear that lists the results of a 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.
  7. The Select Instance screen appears, indicating the names of the SQL Server instances currently installed. This figure below is an example.
  8. 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 is skipped because during an upgrade, you cannot select any additional features.
  9. If the Feature Rules screen appears, the results of a Feature Rules test are given. Verify that no tests fail. If a test failed, you need to exit the install and correct the issue before continuing. Click the Failed cell for more information. Click Next.
  10. The Ready to Upgrade screen appears. Click Upgrade.
  11. The Installation Progress screen appears as the SQL Server 2014 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.
  12. In the Complete screen, click Close.
  13. Open the SQL Server Configuration Manager.
    Figure 1. 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.
    Note: If you need to upgrade another SQL Server instance, go to Step 4 and rerun the upgrade process. If you do not need to upgrade another instance, installation is complete.