Install and Configure SQL

We need to create an SQL Servers and I would recommend using 8GB so let’s begin by installing Windows Server 2016 and we will name it SQL1

Also disable the Windows Firewall

Restart the SQL1 Server and now we will need to set a static IP of 192.168.2.4/24 with it pointing to our DNS server on DC1 which is 192.168.2.3

Verify you can ping DC1 at 192.168.2.3

Now we can join the RED domain

Use your Domain Administrator account to join the domain

Restart the SQL1 Server and it has now joined the RED domain, logon as RED\Administrator and NOT the local Administrator account

 IMPORTANT – We had disabled of the firewall for Private/Public but we need to disable the Domain Firewall

Now we need to install SQL Server 2012 along with SP2

SQL Server 2012 x64
SQL Server 2012 SP2 x64

Create a folder called SQL on the c:\ drive and copy the files you downloaded.

Run the SQLFULL_ENU setup.exe as an administrator

Select New SQL Server stand-alone installation under the Installation category on the left.

On the Feature Selection window, select Database Engine Services, Reporting Services-Native

Also scroll down and select Management Tools – Complete

Under Instance Configuration click on Default Instance, the instance ID MSSQLSERVER will be created.

Ensure sccmadmin is assigned as the account name for SQL Server Agent, Database Engine and Reporting Services, leave SQL Server Browser as it is.
Ensure startup type is set to Automatic for all

IMPORTANT – During the SQL install, the collation should be SQL_Latin1_General_CP1_CI_AS

Set to Windows authentication mode, add sccmadmin and the domain administrator as SQL server administrators.

Launch SQL Server Management Studio and Connect.

Right Click SQL1 under Object Explorer and go to properties, select Memory and change minimum/maximum to 8192mb

Finally Install SQLServer2012SP2-KB2958429-x64-ENU