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
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