Skip to content

Install SCCM 2012 R2 with SQL Server 2014 and PowerShell

Share this Post
  • 1
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Install .Net 4.7.1
install wmf 5 for new powershell check version with $psversiontable, .net 4.5+ prereq for wmf5
inst wmf with this cmd as admin Win8.1AndW2K12R2-KB3134758-x64.msu /quiet

SCCM Prereqs: remote differential compression

Install Win Server 2012R2 Standard (GUI), HD60GB, RAM 4GB, 1CPU
(All SW is EVAL unless specified)

Notes I am installing this as a lab so a single standalone primary site with sql on the same box. Each site contains its own DB.
Run full win updates
Run the Prereq checker https://technet.microsoft.com/en-gb/library/hh368980.aspx

Prereq for SQL DB: .Net 3.5.1 Feature install required > Mount Server ISO > Add feature in server manager > specify alternate path > E:\sources\sxs

Install SQL Server 2014 SP2

Firewall warning during SQL 2014 install – http://www.sqlcoffee.com/sqlserver2014_0005.htm
configure with below command then ignore the warning as the rule is now set for remote access
PS C:\Windows\system32> netsh advfirewall firewall add rule name = SQLPort dir = in protocol = tcp action = allow localport = 1433 remoteip = localsubnet profile = DOMAIN

.Net security warning during rules check this is due to no internet access so can be ignored

Select Features: SQL Server Replication, Client Tools Connectivity, Integration Services, Management Tools, SQL Client Connectivity SDK
Named Instance: SCCM
Set service SQL Server Agent to Automatic
Add Windows Authentication > Add Current User
Launch Management Studio > Connect to SCCM Instance
Right Click instance > Set mem limit to 8000MB
Add SCCM Admin user account to Vmlab users OU
Make member of: Administrators, Domain Admins, Domain Users, Enterprise Admins, Schema Admins
Add SCCM Computer Account (CM1) to Local Administrators Group of SQL Server (Select Computers Option)
Open SQL MS > Login > Expand Security > Right Click Logins > New Login > Click Search > add sccmadmin domain account > Click OK > Right Click account Properties > Server Roles > tick sysadmin > click OK
Open ADSI Edit > Right Click ADSI Edit > Click OK on box > Expand tree to CN=System > Right click New Object > container > Enter Value System Management > Finish
Open AD Users/Computers > View Advanced > Browse System > Right Click System Management > Delegate Control > Add SCCM Computer (CM1) > Create custom task > This folder, existing objects > select general, property specific and creation/deletion > permissions select full control, click ok > Finish

Mention Preinstall steps to configure before core install
Run SC2012_R2_SP1_Configmgr – Self extract package
Run SC2012_SP2_Configmgr_SCEP – Self extract package
Browse > SC2012_SP2_Configmgr_SCEP\SMSSETUP\BIN\X64\extadsch.exe > Run this as admin cmd to extend schema
Txt file outputted to c:\ExtADSch.txt
Install ADK for Win10 select all features
Install Net FW 3.5, 4.5 and all sub features, BITS, Remote Diff Compression,
IIS: Common HTTP Features (default document, static content), Application Dev(ASP.NET 3.5(.NET Extensibility 3.5, ASP.NET 4.5, NET Extensibility 4.5, ISAPI extensions), Security(Windows authentication),IIS 6 Management Compatibility(IIS Management Console, Metabase Compatibility, WMI Compatibility, Management Scripts and Tools)
Install SCCM 2012 R2 > Run SC2012_SP2_Configmgr_SCEP\splash.hta > Click Install > Download Packages to folder or select path to existing
Enter site code: CM1 > Site name: Primary Site Vmlab
Select > Install primary site as stand-alone
SQL Server name: CM1, Instance: SCCM
(Move this step to before sccm install) SQL Connection error when clicking OK > Open SQL Server Config Manager > SQL Server Network Config > Protocols for SCCM > Right click TCP/IP > Ip addresses tab: clear all TCP Dynamic Ports, set all TCP Port to 1433 and Apply OK
Click SQL Server Services > Right Click SQL Server (SCCM) set to this account: vmlab\sccmadmin > restart service
The above error should now not appear now when you click next in the SCCM Install Window
Click Next > select Configure the Comms method on each site > Click next
Warnings > Install WSUS from Server Manager, Correct Firewall exception, SQL Server Collation and Memory Usage
Set additional firewall rule SQLBrokerService 4022
Run Command below under errors for Collation fix
Install WSUS as a role before this step
Right Click Instance in Management Studio > Properties > Memory > Set Min: 8192, Max: 12288
Continue with install after all prereqs met
Restart after finished could be required

Install SCCM 2012 R2 SP1 > Run SC2012_R2_SP1\splash.hta > Click Upgrade

Errors/Warnings:
In the first install i SQL Server Collation Error. This is due to not setting the SQL Server Collation to the correct name from the default during SQL install. I had to run a command to rebuild the db:
Mount SQL ISO
Setup.exe /QUIET /ACTION=REBUILDDATABASE /SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS /INSTANCENAME=SCCM /SQLSYSADMINACCOUNTS=BUILTIN\Administrators

After this I could not login to the db instance via SQL Management Studio. I got the following error:
Login failed for user Error 18456

I got around this by running the Management Studio App itself as Admin then I could log in ok.

Notes:
SP2 supports 150k devices for standalone primary
setup at least 1 management point for every 25k clients
Need to have 64bit,
Site System server WS2012 Core os not supported as no pxe, multicast support
– exception the core os is supported for distribution point site system role, w/o PXE or multicast support.
After a site system server installed cannot change domain name, domain membership, name of computer
to change these first remove site system role then reinstall roles after change complete. if this affects site server computer uninstall the site and then reinstall site after change complete
Important: cannot change startup type or log on as for sccm services, this will prevent key services from running
Prereqs: .net 4,4.5,4.5.1 expired so use 4.5.2 instead actually test with latest 4.7.1 (inc in fall creators update)

REFS:
http://www.danielclasson.com/install-net-framework-35-server-2012/

System Center 2012 Configuration Manager SP2 and System Center 2012 R2 Configuration Manager SP1: Frequently Asked Questions


.Net framework deployment guide for developers – https://docs.microsoft.com/en-us/dotnet/framework/deployment/deployment-guide-for-developers#command-line-options


Share this Post
  • 1
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  

Leave a Reply

avatar
  Subscribe  
Notify of
Scroll Up