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

Note: We support SQL Server 2014 SP3 Express software. You must apply SP3 if you installed the initial release of SQL Server 2014 Express software.

Procedure

  1. To apply SP3 to SQL Server 2014 Express 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 SQL Server 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 SQL Server 2014 Update screen appears. Verify that all update rules passed before continuing. If any rule fails, click the Failed cell for more information. Exit the update and fix the issue before continuing. Click Next.
  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. During an upgrade, 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, you must 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.
  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. Delete the service pack file you saved to your computer.