Installing SQL Server 2012 + Service Pack 1 + SP1 Cumulative update in one installation using SQL Server 2012 Product Update

Installing SQL Server 2012 + Service Pack 1 + SP1 Cumulative update in one installation using SQL Server 2012 Product Update

  • Comments 1

 

1-Let us have below folder structure where media for RTM, Service pack 1 and cumulative update exist.

 

 

 

image

2-Create below configuration file that will determine all setup parameters required during installation process,The file will be saved as ConfigurationFile.ini under  c:\SQL2012\

Configure the parameters highlighted in green needs to be tuned, also PID needs to be provided incase of non evaluation installations.

those are

  1. Features to be installed.
  2. AS SYS Admin account.
  3. SQL SYS Admin account.
  4. Instance name.

 

;SQL SERVER 2012 Configuration File
[OPTIONS]

; Specifies a Setup work flow, like INSTALL, UNINSTALL, or UPGRADE. This is a required parameter.

ACTION="Install"

; Detailed help for command line argument ROLE has not been defined yet.

ROLE="AllFeatures_WithDefaults"

; Detailed help for command line argument ENU has not been defined yet.

ENU="True"

; Setup will not display any user interface.

QUIET="True"

; Specify whether SQL Server Setup should discover and include product updates. The valid values are True and
False or 1 and 0. By default SQL Server Setup will include updates that are found.

UpdateEnabled="True"

; Specifies features to install, uninstall, or upgrade. The list of top-level features include SQL, AS, RS, IS,
MDS, and Tools. The SQL feature will install the Database Engine, Replication, Full-Text, and Data Quality
Services (DQS) server. The Tools feature will install Management Tools, Books online components, SQL Server
Data Tools, and other shared components.

   FEATURES=SQLENGINE,REPLICATION,FULLTEXT,DQ,AS,RS,DQC,BIDS,CONN,IS,BC,SDK,BOL,SSMS,ADV_SSMS,SNAC_SDK,MDS


; Specifies the list of administrator accounts that need to be provisioned.

ASSYSADMINACCOUNTS="<ASSYSADMINACCOUNT>"

; Windows account(s) to provision as SQL Server system administrators.

SQLSYSADMINACCOUNTS="<SYSADMINACCOUNT>"

; Specify that SQL Server feature usage data can be collected and sent to Microsoft. Specify 1 or True to
enable and 0 or False to disable this feature.

SQMREPORTING="False"

; Specify if errors can be reported to Microsoft to improve future SQL Server releases. Specify 1 or True to
enable and 0 or False to disable this feature.

ERRORREPORTING="FALSE"

; Specify a default or named instance. MSSQLSERVER is the default instance for non-Express editions and
SQLExpress for Express editions. This parameter is required when installing the SQL Server Database Engine
(SQL), Analysis Services (AS), or Reporting Services (RS).

INSTANCENAME="MSSQLSERVER"

; RSInputSettings_RSInstallMode_Description

RSINSTALLMODE="FilesOnlyMode"

; Don't provision current user as a Database Engine system administrator.

ADDCURRENTUSERASSQLADMIN="False"

UPDATESOURCE=".\Updates"

 

The parameters highlighted in red specify that product update feature will be enabled in this installation process and the folder where all applicable SQL Server updates reside is “C:\SQLServer2012\Updates”

 

3-Run below command from command prompt in elevated mode”:

setup.exe    /ConfigurationFile=SQLServer2012Config.ini    /IACCEPTSQLSERVERLICENSETERMS

 

4- Here are the results of installation process, highlighted parts of installation summary and discovery  report will ensure that installation of SQL Server 2012 plus Service Pack 1 plus Service Pack Cumulative Update completed successfully.

 

 

image

 

 

 

image

Leave a Comment
  • Please add 8 and 3 and type the answer here:
  • Post
  • Hi, I have already installed SQL Server 2012 SP1 and now planning to upgrade it to SP2 + CU1. When i used Updatesouce command I am getting error 'UpdateSource is not supported'. Is there a way to run this upgrade at the same time instead of running .exe individually

Page 1 of 1 (1 items)