Upgrading SQL Server software to SQL Server 2016 SP2 software or SQL Server 2016 SP2 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 2014
  • SQL Server 2012
  • SQL Server 2008 R2
  • SQL Server 2008

For more information on upgrading to SQL Server 2016 SP2, refer to the Microsoft documentation. The steps in this section also apply to upgrading any of the following versions of SQL Server Express software:

  • SQL Server 2012 SP2 Express
  • SQL Server 2014 Express
  • SQL Server 2008 R2 Express
  • SQL Server 2008 Express

Procedure

  1. To upgrade SQL complete the following steps.
    1. For upgrading SQL Server, run the SQL Server 2016 SP2 software installation file from provided media.
    2. For upgrading SQL Express, click this link, download and run SQLEXPR_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 2016 software, click Yes. The message Please Wait While SQL Server 2016 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 the Upgrade from [SQL versions listed] option 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 Install Setup Files screen appears, showing the download and installation progress of any necessary setup files.
  7. 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.
  8. The Select Instance screen appears, indicating the names of the SQL Server instances currently installed. Select the instance used by Metasys software, which is typically 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 installation 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 2016 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. Start 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. Verify that Named Pipes is set to Enabled. If it is Disabled, right-click Named Pipes and select Enable. Click OK to the SQL Server software restart warning message that appears.
  16. Verify that TCP/IP is set to Enabled. If it is Disabled, right-click TCP/IP and select Enable. Click OK to the warning message.
  17. Close SQL Server Configuration Manager.
  18. Restart the computer only if the SQL Installer prompts you to do so.

    For a split ADX only, repeat the steps in this section to install the required SQL Server software components on the second server of the split system. Then, go to Specific system requirements for the Metasys Advanced Reporting System to configure Reporting Services on the web/application server of the split ADX.

    If you plan to install the Metasys Advanced Reporting System, go to Installing Microsoft Report Viewer 2012 Redistributable Package.