Applying SP3 to SQL Server 2014 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

Note: We support SQL Server 2014 software with SP3. Use these steps to apply the SP3 update to an older version of SQL Server 2014 software that is currently installed. If you do not have SQL Server 2014 software installed, go to Installing or upgrading SQL Server software using the SQL Install Helper.

Procedure

  1. To apply SP3 to SQL Server 2014 software, click this link and download the file.
  2. To extract the files to a temporary location on your hard disk and begin the update, double-click the installation files that you downloaded.
  3. Click Yes if a User Account Control dialog box prompts you for permission to make changes to the computer related to installing SQL Server 2014 SP3 software. The message Please Wait While SQL Server 2014 Setup processes the current operation may appear as the installation begins.
  4. The SQL Server 2014 Update screen may appear. Verify that all update rules passed before continuing. Click Next.
    Note: If any rule fails, click the Failed cell for more information. Exit the update and fix the issue before continuing.
  5. Read the end user license agreement and then select the I accept the license terms check box. Click Next.
  6. 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.
  7. The SQL Server 2014 SP3 update checks to see if any required SQL Server files are in use. If you have SQL Server files in use when you install SP3, restart your computer after the installation is complete. Click Next.
  8. SQL Server 2014 SP3 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.
  9. The update operation is complete. Click Close.
  10. Start the SQL Server Configuration Manager.
    Figure 1. Starting SQL Server Configuration Manager

  11. Expand SQL Server Network Configuration and select Protocols for MSSQLSERVER.
    Note: If you have a different named instance, that name appears instead of MSSQLSERVER.
  12. 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.
  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.

  14. Close this window and return to the wizard overview steps.