Second part of my silent installation of an SMS Primary site is set with installing SMS using an *.ini file. Please read the remarks well and test first in an test environment!

 

Rem *****************************************************
Rem * Setup ini File to install an SMS Primary Site *
Rem *****************************************************

[Identification]
Action=InstallPrimarySite

[Options]
Rem * enable all client agents and options              *
AllClientOptionsOn

Rem * Organizational information and Productkey         *
FullName=USER NAME
OrgName=ORGANISATION NAME
ProductID=PRODUCTKEY

Rem * Sitecode, name and domain, as in design choice    *
SiteCode=
SiteName=
SiteDomain=

Rem * Advanced or standard security as in design choice *
SecurityMode=Advanced 

Rem * Estimated number of clients                       *
NumOfClients=500

Rem * Remote control is neccesary for pre Win XP/2003   *
Rem * or when to log on to locked or idle systems       *
Rem * Check your organization's privacy policy on latter *
OptionalUnits=Remote Control

Rem * SMS installation directory                        *
SMSInstallDir=D:\SMS

Rem * If SQL installation is controlled by this ini,    *
Rem * set InstallSQLServer=1. Not preferred method.     *
InstallSQLServer=0

Rem * Number of SMS console sessions                    *
NumberOfAdminUI=5

Rem * Location of SMS provider (Server Name), as in     *
Rem * design choice                                     *
SDKServer=

[SQLConfigOptions]

Rem * Set SQL servername (SMS server)  and SQL version   *
SQLServerName=ServerName
SQLServerVersion=2005

Rem * 1 to have SMS use Windows authentication mode when *
Rem * accessing the SMS site database with Local_System  *
Rem * account (SMS server account added to Local Admins  *
Rem * group on remote SQL server or use 0 to not use it. *
UseSQLIntegratedSecurity=1

Rem * If Windows Authentification mode is not used, the  *
Rem * SMS server needs to access the SMS site database   *
Rem * with the configured SA account in SQL              *

SQLLoginID=sa
SQLLoginPassword=SA_PWD

Rem * Create database for SMS. set to 0 if existing is   *
Rem * used or created using SQL server                   *
CreateSQLDevice=1

Rem * Set the database name                              *
DatabaseName=SMS_DataBaseName

Rem * legacy entries for SQL 6.5 funny enough are entries *
Rem * kept within Microsoft example. Just in case...      *
DatabaseDevice=SMSdata_DataBaseName                      
LogDevice=SMSlog_DataBaseName

Rem * A directory path where the SQL Server devices and   *
Rem * files used by the site database will be installed   *
SQLDevicePath=D:\MSSQL\SMSDATA

Rem * Recommended number of simultaneous connections that *
Rem * the SMS site database can have...                   *
NumberOfSqlConnections=75

Rem * Set 1 to automatically configure SQL Server connections, *
Rem * Set 0 to not automatically configure                     *
AutoConfigSqlConnections=1

 

@echo off
Rem *****************************************************
Rem * Setup CMD File to install an SMS Primary Site *
Rem *****************************************************

Rem *********************************************************************
Rem * This section installs the Windows 2003 Support Tools. This is     *
Rem * only neccesary when SQL Service is not running under local System *
Rem * account to configure Server Principal Name (SPN) with setSPN.exe  *
Rem *********************************************************************

Echo Installing the Windows 2003 Support Tools

msiexec /i "\\SERVERNAME\SHARE\W2k3SupportTools\SUPTOOLS.msi" /quiet

Echo Installed Successfully

Rem *************************************************************
Rem * This section installs the SQL Server 2005 Database Engine *
Rem * Check if all accounts are configured and active in AD     *
Rem * When Local System account is used, delete all             *
Rem * account instances except SAPWD entry and replace it by    *
Rem * SQLACCOUNT="NT AUTHORITY\SYSTEM"                          *
Rem *************************************************************

Echo Installing SQL Server 2005 Database Engine

\\SERVERNAME\SHARE\SMSSQL2k5\Disc1\Setup.exe /qb INSTANCENAME=MSSQLSERVER ADDLOCAL=SQL_Engine,Connectivity,SQLXML,SQL_Documentation,SQL_Tools90 SAPWD=SA-P@ssw0rd0! SQLACCOUNT=DOMAINNAME\SQLSERVICEACCOUNT SQLPASSWORD=PW_SQLSERVICEACCOUNT AGTACCOUNT=DOMAINNAME\SQLAGENTACCNT AGTPASSWORD=PW_SQLAGENTACCNT SQLBROWSERACCOUNT=DOMAINNAME\SQLBROWSERACCNT SQLBROWSERPASSWORD=PW_SQLBROWSERACCNT

Echo Installed Successfully

Rem ****************************************************************
Rem * This section installs the SQL Server 2005 Client Componenets *
Rem ****************************************************************

Echo Installing the SQL Server 2005 Client Components

\\SERVERNAME\SHARE\SMSSQL2k5\Disc2\Setup.exe /qb ADDLOCAL=Client_Components

Echo Installed Successfully

Rem ********************************************************
Rem * This section installs the SMS Primary Site           *
Rem ********************************************************

Echo Installing the SMS Primary Site

\\SERVERNAME\SHARE\SMS2003\smssetup\BIN\I386\setup.exe /script SMS2003Setup.ini /quiet

Echo Installed Successully

Rem ********************************************************
Rem * This section installs the SMS 2003 Support Tools     *
Rem ********************************************************

Echo Installing the SMS 2003 Toolkit 2

msiexec /i "\\SERVERNAME\SHARE\SMS2003Toolkit2\SMS2003Toolkit2.msi" /quiet

Echo Installed Successfully

Rem *****************************************************************************
Rem * This section creates the SQL Service Principal Names for the SMS Database *
Rem * but can be removed if the server local System Account is used             *
Rem *****************************************************************************

Echo Creating the SQL Service Principal Names for the SMS Site Database

C:
cd %programfiles%\"support tools"
setspn -A MSSQLSvc/SERVERNAME.FULLYQUALIFIED.DOMAINNAME:1433 SQLSERVICEACCOUNT
setspn -A MSSQLSvc/SERVERNAME:1433 SQLSERVICEACCOUNT

Echo Created Successfully

Pause