SCCM 2012 R2 Installation Script (Part 2)

Here are the SQL scripts and the VBS.

EnableMicrosoftUpdate.vbs

Set ServiceManager = CreateObject("Microsoft.Update.ServiceManager") 
ServiceManager.ClientApplicationID = "My App" 
'add the Microsoft Update Service by GUID 
Set NewUpdateService = ServiceManager.AddService2("7971f918-a847-4430-9279-4a52d1efe18d",7,"")

This is the SQL Configuration File

SQL2012-ConfigurationFile.ini

[OPTIONS]

IACCEPTSQLSERVERLICENSETERMS="True"

SAPWD="Welcome!"

ACTION="Install"
ENU="True"
QUIET="False"
QUIETSIMPLE="True"
UpdateEnabled="True"
FEATURES=SQLENGINE,SSMS,ADV_SSMS
UpdateSource="MU"
HELP="False"
INDICATEPROGRESS="False"
X86="False"
INSTALLSHAREDDIR="D:\Program Files\Microsoft SQL Server"
INSTALLSHAREDWOWDIR="D:\Program Files (x86)\Microsoft SQL Server"
INSTANCENAME="MSSQLSERVER"
INSTANCEID="MSSQLSERVER"
SQMREPORTING="False"
ERRORREPORTING="False"
INSTANCEDIR="E:\SQLInst"
AGTSVCACCOUNT="NT AUTHORITY\SYSTEM"
AGTSVCSTARTUPTYPE="Automatic"
COMMFABRICPORT="0"
COMMFABRICNETWORKLEVEL="0"
COMMFABRICENCRYPTION="0"
MATRIXCMBRICKCOMMPORT="0"
SQLSVCSTARTUPTYPE="Automatic"
FILESTREAMLEVEL="0"
ENABLERANU="False"
SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS"
SQLSVCACCOUNT="NT AUTHORITY\SYSTEM"
SQLSYSADMINACCOUNTS="BUILTIN\Administrators"
SECURITYMODE="SQL"
SQLBACKUPDIR="F:\SQLBack"
SQLUSERDBDIR="E:\SQLData"
SQLTEMPDBDIR="E:\SQLTemp"
ADDCURRENTUSERASSQLADMIN="False"
TCPENABLED="1"
NPENABLED="0"
BROWSERSVCSTARTUPTYPE="Disabled"

And last, the SQL script to set the memory sizes (didn’t find this info in the unattended script above. Would have been nice but it works with this 🙂 )

SetSQLMemory.sql

USE master

EXEC sp_configure 'show advanced options',1
RECONFIGURE WITH OVERRIDE
GO

USE master
EXEC sp_configure 'min server memory (MB)',8192
EXEC sp_configure 'max server memory (MB)',8192
EXEC sp_configure 'show advanced options',0
RECONFIGURE WITH OVERRIDE
GO