How to upgrade SCCM SQL version

Jonathan LefebvreSCCM, SQL5 Comments

SQL Server is obviously a key component to take care of, for a healthy SCCM infrastructure. While SCCM supports a wide variety of SQL Server versions, keeping it up to date may be a good idea to avoid getting out of support. In this post, we will detail how to upgrade SCCM SQL 2014 to SQL 2017. SQL 2019 is available for a couple of weeks, but it’s still not listed as supported in the SCCM documentation. If you’re looking to install SQL 2017 from scratch, jump to our post on this topic. Upgrade SCCM SQL version Requirements Current SQL … Read More

Identify Office Products with its architecture using SCCM report

Benoit LecoursConfiguration Manager, OFFICE, REPORT, Reports, SCCM, SSRS13 Comments

I did blog post year ago on Microsoft office product versions with its architecture type and count. But lately, my blog readers have requested to add Office 365 ProPlus product into the report. The Original Office Product report was created to include all Microsoft Office products from Office 2007 to Office 2016 but it doesn’t have any click-to-run (C2R) products which are Office 365. So we started looking around and developed the report for you. This free report will have all Microsoft Office products information with its architecture type (x86 or x64) and the count. The report can be run … Read More

How to Start Securing ConfigMgr in the Enterprise

Nicolas PilonAdaptiva, SCCMLeave a Comment

  As an IT professional, you already know that a security breach can be devastating. It can also be expensive, $4 million on average according to a 2015 survey sponsored by IBM. Microsoft System Center Configuration Manager (ConfigMgr) can play a huge part in preventing attacks and implementing an enterprise-wide security solution. ConfigMgr helps companies make sure all endpoints are current with the latest security fixes, configured correctly, behaving normally, and only running authorized applications. However, like almost everything else in IT these days, ConfigMgr itself is a target for hackers who can use it to distribute malware, take control … Read More

Complete SCCM 1511 Installation Guide

Benoit LecoursSCCM23 Comments

In the first post of this SCCM 1511 Installation Guide blog series, we planned our hierarchy, prepared our server and Active Directory. In part 2, we installed and configured SQL in order to perform SCCM 1511 installation. In part 3, we will run the prerequisite checker and proceed to the complete SCCM 1511 installation. We will install a stand-alone Primary site. If you’re already running SCCM 2012 and want an upgrade to SCCM 1511, do not follow this guide. This guide is for a new SCCM 1511 installation only. See our upgrade guide instead. Prerequisite Check Before launching the SCCM 1511 installation, we recommend to launch the Prereqchk tool in … Read More

Step-by-Step SCCM Installation and Configuration Guide

Benoit LecoursSCCM44 Comments

The new version of SCCM is out ! You may know this version as SCCM Vnext, SCCM 2016 or SCCM 1511. The product group explained on their blog that the new version will be simply called SCCM Current Branch. This blog post is a complete Step-by-step SCCM Installation Guide. SCCM installation has never been an easy process and the product itself can be complex for inexperienced administrators. With these blog posts, our goal is to bring it a bit further, explaining concepts and best practice rather than just guide the user through the installation process. If you’re not familiar with SCCM 1511 Features, you … Read More

Step-by-Step SCCM 2012 R2 SP1 CU2 Installation Guide

Benoit LecoursSCCM59 Comments

Cumulative Update 2 (CU2) for SCCM 2012 R2 SP1 and SCCM 2012 SP2 is now available. This post is a complete step-by-step SCCM 2012 R2 SP1 CU2 Installation guide. If you’re looking for a complete SCCM 2012 installation guide, see our blog series which covers it all. Installing SCCM cumulative updates is very important to your infrastructure. It fix lots of issues, which some of them are important. Microsoft recommends installing Cumulative Updates if you are affected by a resolved issues. If you are not on SCCM 2012 R2 SP1 or SCCM 2012 SP2, the latest CU is Cumulative Update 5. As this is … Read More

Configure SCCM 2012 to Inventory RAID Controller Drivers

Nicolas PilonHardware Inventory, SCCM, SQL1 Comment

A RAID controller is a device used to manage hard disk drives (HDDs) or solid-state drives (SSDs) in a computer or storage array. It has the ability to access multiple copies of data on multiple physical devices and improve performance with data protection in case of a system failure. We suggest to keep your RAID controller drivers updated to have the latest fixes from the manufacturer. In this post, we will show you how to configure SCCM 2012 to inventory RAID controller drivers to prepare a deployment targeting the affected systems. We will show how to modify SCCM 2012 hardware inventory classes to get this information. … Read More

How to perform a SCCM 2012 R2 Installation

Benoit LecoursSCCM6 Comments

In the first part of this SCCM 2012 and SCCM 1511 blog series, we planned our hierarchy, prepared our server and Active Directory. In part 2, we installed and configured SQL in order to perform SCCM 2012 R2 installation. In part 3, we will run the prerequisite checker and proceed to the SCCM 2012 R2 installation. We will install a stand-alone Primary site.   Prerequisite Check Before launching the SCCM 2012 R2 installation, we recommend to launch the Prereqchk tool in order to verify if all components are configured correctly. The SCCM 2012 R2 installation wizard will also run this check but if you’re missing a requirement, you’ll have … Read More

Complete SCCM 2012 SQL Install Guide

Benoit LecoursSCCM47 Comments

In the first part of this SCCM 2012 and SCCM 1511 blog series, we planned our hierarchy, prepared our Server and Active Directory. In part 2, we will install and configure SQL before installing SCCM 2012 R2 or SCCM 1511. Click the following link to see all supported SQL versions. For our post, we will install SQL 2012 SP2 locally on the same server where the Primary Site will be installed. SCCM 2012 SQL Install Guide Execute Setup.exe from the SQL installation media, select New Installation Review and Click Next Select Enter Product Key and skip the proposed updates. We will install CU4, later … Read More

Requirements and Recommendations before installing SCCM 2012 R2

Benoit LecoursSCCM33 Comments

In the first part of SCCM 2012 and SCCM 1511 blog series, we will cover SCCM installation prerequisites most specifically hardware requirements, design recommendations and server prerequisites. Hardware Requirements The hardware requirements for a Primary Site server largely depends on the features that are enabled, and how each of the components is utilized. When the number of clients grows and changes, the server hardware requirements change accordingly. For the initial deployment, hardware requirements can be estimated for each server by determining: The overall need for each component (Will you do Operating System Deployment ? How many daily software deployments ? Is Inventory and reporting … Read More