Installing SQL Service Pack 1 on a SQL Core installation

So how do we install SQL Server 2012 Service Pack 1 on a core server?

  1. Download SQL Server Service Pack 1 from the Microsoft download site. (http://download.microsoft.com/download/3/B/D/3BD9DD65-D3E3-43C3-BB50-0ED850A82AD5/SQLServer2012SP1-KB2674319-x64-ENU.exe)
  2. Type: \\<servername>\SQLServer2012SP1-KB2674319-x64-ENU.exe /x:”c:\SQLSERVER2012SP1″ (when your Service Pack resides on a different server).

    Type: X:\<folder>\SQLServer2012SP1-KB2674319-x64-ENU.exe /x:”c:\SQLSERVER2012SP1″ (when your Service Pack resides on your local server).

  3. When the extraction is complete type: c:\SQLSERVER2012SP1\setup.exe /q /action=patch /allinstances /IAcceptSQLServerLicenseTerms

[07-12-2012] Update: corrected the setup string.

[14-03-2012] Update typo allinstance to allinstances

Comments

2 responses to “Installing SQL Service Pack 1 on a SQL Core installation”

  1. Noral Avatar
    Noral

    Your setup string is wrong – it should be setup.exe /q /action=patch /allinstances /IAcceptSQLServerLicenseTerms

    /allinstance should be /allinstances

  2. MysticRyuujin Avatar

    The extraction isn’t required, I just tested this with SQL 2016 SP1 on Server Core 2016, I was able to just run the downloaded KB exe with the required parameters and it worked fine. It silently extracted to c:\{guid}\, installed, cleaned up, and exited. Thanks for this by the way!

Leave a Reply

Discover more from Something Technical

Subscribe now to keep reading and get access to the full archive.

Continue reading