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 versions must be one of the following : SQL Server 2008 SP4 or later SQL Server 2008 R2 SP3 or later SQL Server 2012 SP2 or later SQL Server 2014 or later SQL Server 2016 or later Download SQL reporting services Download SQL Management studio The operating system is still … Read More
Identify Office Products with its architecture using SCCM report
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 on a specific collection which is useful to scope specific group of machines. This can be used as all-in-one SCCM report for Microsoft Office product versions with architecture type. This report comes with a drill-down feature to see the list of all devices with the selected product. You’ll need our … Read More
How to Start Securing ConfigMgr in the Enterprise
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 of computers with access to private data, and engage in all manner of nefarious activity. According to a recent Adaptiva survey of more than 150 IT professionals, 70 percent expressed concern about potential security vulnerabilities in their Microsoft ConfigMgr environments. Securing the perimeter of your company’s network is usually the … Read More
Complete SCCM 1511 Installation Guide
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 order to verify if all components are configured correctly. The SCCM 1511 installation wizard will also run this check but if you’re missing a requirement, you’ll have to go through the whole installation wizard again after fixing it. We prefer to use the standalone tool before running the setup. To start the prerequisite check … Read More
Step-by-Step SCCM Installation and Configuration Guide
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 can visit this Technet article which covers it all. If you’re familiar with SCCM 2012 and plans to migrate, read our blog post about What’s New in SCCM 1511 and stop reading this guide. You do not need to do a complete installation if you’re already running SCCM 2012. See our blog post on how … Read More
Step-by-Step SCCM 2012 R2 SP1 CU2 Installation Guide
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 a cumulative update, you don’t have to install prior CU(1) before installing CU2. CU2 contains all the fixes included in previous CU. Improvements/Fixes There’s no new major functionality in CU2. This update contains fixes for issues in various areas including software distribution and content management; operating system deployment; site systems and mobile device management. … Read More
Configure SCCM 2012 to Inventory RAID Controller Drivers
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. RAID Controller Drivers Information You can find RAID controller drivers information in System Information. Launch System Information from msinfo32.exe directly from Run in Start Menu Expand Components / Storage / SCSI In the WMI, the information of RAID controller is in WIN32_SCSIController but it doesn’t include driver version. In this case, you … Read More
How to perform a SCCM 2012 R2 Installation
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 to go through the whole installation wizard again after fixing it. We prefer to use the standalone tool. To start the tool : Open an Administrator command prompt Browse to .\SMSSETUP\BIN\X64 Run the following command : prereqchk.exe /AdminUI If you follow the guide correctly you’ll have this wonderful result : Refer to this … Read More
Complete SCCM 2012 SQL Install Guide
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 Select SQL Server Feature Installation Select the Database Engine, Reporting Services and Management Tools features and specify the SQL installation directory. This is the directory for the program files and shared features Select Default instance and ensure that your instance is created on the SQL Volume Review and click Next Set all … Read More
Requirements and Recommendations before installing SCCM 2012 R2
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 is important for your organisation ? Will you manage Internet Client ?) The number of clients planned to be installed The load on each of installed SCCM components In general, medium environments (couple thousand clients) should consider the following recommendations when planning hardware: SCCM and SQL Server communicate constantly. We … Read More
- Page 1 of 2
- 1
- 2