In this post I will show you method of installation SCCM for lazy people (like I am). This can be useful for testing purposes as well it might be used in production. Main reason to develop those “scripts” was many dependencies that have to be meet before we install SCCM, like windows features, port configurations, optional product installation. In this article I will be base on Windows 2012 / Windows 2012 R2 with all commands, so let’s start.
All machines have installed windows 2012/2012 R2 and are joined into domain.
Installation of SQL server
1. Installation of features for SQL installer
first We have to meet dependencies of .NET:
Add-WindowsFeature NET-Framework-Core -Source D:\sources\sxs
Make sure that DVD with windows installed/or iso is in CDROM drive D (or change letter above).
2. Place SQL Server config file
In mean time, press Win+R (run as window should open) and type:
temp directory will open place there file Configuraton.ini that is in SQL directory in attachment. PLEASE Edit and change following line:
into your domain accoutn that should have Administrative privileges in SQL. in my case this is test\Administrator account where test is domain. After place this file in %TEMP% directory you can proceed to next step
3. Installation of SQL Server
When installation finish place DVD with Installation source of SQL Server 2012 in CDROM/or make it available for you in windows. Open cmd line by pressing shift+left mouse button and choose run command line here. Then type(one line):
setup.exe /CONFIGURATIONFILE=%TEMP%\ConfigurationFile.ini /IACCEPTSQLSERVERLICENSETERMS
This will install SQL Server 2012 as it should be installed.
SQL will be installed on named instance SCCM, reporting services, proper code page.
4. Post install configuration
When installation finish double click sqlcfg.reg (in attachment SQL\sqlcfg.reg) This will configure port 1433 for you in SQL.
Last step: configure firewall, start powershell and type:
New-NetFirewallRule -DisplayName “SQL Ports” -Description “SQL ports used by ConfigMgr” -LocalPort 1433,4022 -Protocol TCP -Profile any -Enabled True
New-NetFirewallRule -DisplayName “SQL Ports” -Description “SQL ports used by ConfigMgr” -LocalPort 4022 -Protocol TCP -Profile any -Direction Outbound -Enabled True