SCCM 2012 R2 Installation Script (Part 2)
December 30, 2013 – 2:41 pmHere 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