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

SCCM 2012 Secondary Site Installation

Benoit LecoursSCCM2 Comments

Determining if you need a Primary Site, Secondary Site or only a Site System Role (MP,SUP) in your SCCM hierarchy can lead to confusion. This post will focus on the Secondary Site installation. What is exactly his role ? A Secondary Site controls content distribution for clients in remote locations across links that have limited network bandwidth. It’s always child site of the Primary Site and it’s managed though the SCCM console. To determine if you should install one, read the Technet documentation or follow Kent Agerlund (Enterprise Client Management MVP) rules of thumb : Install a Secondary Site only if one of the following … Read More

Report Builder Error – The Certificate Chain was issued by an Authority that is not Trusted

Benoit LecoursSCCM, SSRS13 Comments

When editing a SCCM 2012 report in Report Builder you receive the following error : A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 – The certificate chain was issued by an authority that is not trusted.) Cause This error occurs because you don’t have the required SCCM SQL certificate on the computer running Report Builder. Follow the following steps in order to resolve the issue. Export the certificate from your SQL server On the SQL Server Click the Start menu, click Run, and then type mmc. Click Enter. … Read More

Is_Virtual_Machine in v_R_System is not showing Properly with a Virtual Machine under VMWare ESXI 5.1

Nicolas PilonSCCM, SQL4 Comments

There’s a new field in v_R_system view on SCCM 2012 SQL database named Is_Virtual_Machine. It is really easier when it’s time to target virtual machines with this field instead using manufacturer, model or v_GS_Virtual_Machine under SCCM 2007. Today, we were making a spot check in our data integrity when we found two manufacturers and models VMWare flagged as non-virtual machine. In the SCCM SQL database, the source for v_R_system view is System_DISC. The associate WMI class is SMS_R_System Server. From the MSDN website, the description of Is_Virtual_Machine in the WMI class is. 1 is a virtual machine and 0 is a physical machine. How … Read More