SCCM 2012 Installation for lazy part 1 – SQL

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.

Prerequisites

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%

temp directory will open place there file Configuraton.ini that is in SQL directory in attachment. PLEASE Edit and change following line:

SQLSYSADMINACCOUNTS="test\Administrator" "Administrator"

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

Next Step -> SCCM 2012 Installation  part 2

Attachment: SCCM for lazy

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

seven × one =