Install SQL Server 2012 Service Pack 4

In this post I will show install SQL Server 2012 Service Pack 4.

1.Check the current version of SQL Server 2012, the below query returned the value RTM (release to manufacturing ) means that is the first release of SQL 2012 without applying any Service Pack.

SELECT
  CASE 
     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '8%' THEN 'SQL2000'
     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '9%' THEN 'SQL2005'
     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '10.0%' THEN 'SQL2008'
     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '10.5%' THEN 'SQL2008 R2'
     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '11%' THEN 'SQL2012'
     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '12%' THEN 'SQL2014'
     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '13%' THEN 'SQL2016'     
     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '14%' THEN 'SQL2017' 
     WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '15%' THEN 'SQL2019' 
     ELSE 'unknown'
  END AS MajorVersion,
  SERVERPROPERTY('ProductLevel') AS ProductLevel,
  SERVERPROPERTY('Edition') AS Edition,
  SERVERPROPERTY('ProductVersion') AS ProductVersion

  MajorVersion ProductLevel Edition                      ProductVersion
  ------------ ------------ ---------------------------  --------------
  SQL2012      RTM          Enterprise Edition (64-bit)  11.0.2100.60

2. Download the Service Pack 4 SQLServer2012SP4-KB4018073-x64-ENU.exe from Microsoft Download Center

3. Run the installer of SP 4 SQLServer2012SP4-KB4018073-x64-ENU.exe (Run as Administrator)

a. Check the Installer pass all validations.

1. Click on “Show details” button to show the status of all rules.

b. Verify all rules are passed.

1. Click the “Next” button.

c. Accept the license term

1. Check the “I accept the license terms” check box.
2. Click the “Next” button.

d. Make sure that “MSSQLSERVER” and “Shared Features” are selected

1. Click on “Next” button.

e. Verify that are not files in use, in this case the process fdhost.exe was in use and need to be stopped to continue.

1. Open “SQL Server Configuration Manager” and stop the service “SQL Full-text Filter Daemon Launcher (MSSQLSERVERR)”
2. Click on “Next” button.

f. After verify there is no Files in Use

1. Click on “Next” button.

g. Verify that all Features were updated with the Status of Succeeded.

1. Click on “Close” button

4. Open “SQL Server Management Studio” and run the below query to verify if the SP4 was installed sucessfully.

use master

SELECT
CASE
WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '8%' THEN 'SQL2000'
WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '9%' THEN 'SQL2005'
WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '10.0%' THEN 'SQL2008'
WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '10.5%' THEN 'SQL2008 R2'
WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '11%' THEN 'SQL2012'
WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '12%' THEN 'SQL2014'
WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '13%' THEN 'SQL2016'
WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '14%' THEN 'SQL2017'
WHEN CONVERT(VARCHAR(128), SERVERPROPERTY ('productversion')) like '15%' THEN 'SQL2019'
ELSE 'unknown'
END AS MajorVersion,
SERVERPROPERTY('ProductLevel') AS ProductLevel,
SERVERPROPERTY('Edition') AS Edition,
SERVERPROPERTY('ProductVersion') AS ProductVersion

  MajorVersion ProductLevel Edition                      ProductVersion
  ------------ ------------ ---------------------------  --------------
  SQL2012      SP4          Enterprise Edition (64-bit)  11.0.7001.0