Applying service packs to SQL Server 2016 software or SQL Server 2016 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

We support SQL Server 2016 software with SP2 or SQL Server 2016 Express software with SP2. Use these steps to apply the service pack update to an older version of SQL Server 2016 or SQL Server 2016 Express software that is currently installed. If you do not have SQL Server 2016 software installed, go to Installing SQL Server 2016 SP2 software. If you do not have SQL Server 2016 Express software installed, go to Installing SQL Server 2016 SP2 Express software. Verify your version of SQL Server 2016 before running through this update.

This procedure applies to updating SQL Server 2016 software, or SQL Server 2016 Express software. Both SQL Server & SQL Express use the same SP2 file. For SQL Server 2016 SP2 and SQL Server 2016 SP2 Express software, click this link to download the file.

Procedure

  1. 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. If a User Account Control dialog box appears, click Yes.
  2. The SQL Server 2016 Update screen appears. Verify that all update rules pass before continuing. Click Next.
  3. Read the end user license agreement and then select the I accept the license terms check box. Click Next.
  4. The Select Features screen indicates the Instance ID that is ready to be updated. Click the instance name to refresh the Description fields. For an update, you cannot select any additional features. Click Next.
  5. The SQL Server 2016 SP2 update checks to see if any required SQL Server files are in use. If you have SQL Server files in use when you install SP2, restart your computer after the installation is complete. Click Next.
  6. SQL Server 2016 SP2 software is ready to update. Click Update. During the update, a progress screen indicates the status of the update. This part of the procedure can take up to 15 minutes to complete.
  7. The update operation is complete. Click Close.
  8. Start SQL Server Configuration Manager.
  9. Expand SQL Server Network Configuration and select Protocols for MSSQLSERVER.
    Note: If you have a different named instance, that name appears instead of MSSQLSERVER.
  10. 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.
  11. 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.
  12. Close SQL Server Configuration Manager.
  13. 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.