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

Advertisements

2 thoughts on “Installing SQL Service Pack 1 on a SQL Core installation

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

    /allinstance should be /allinstances

  2. 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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s