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

Benoit LecoursSCCM, SSRS13 Comments

If you’re like us and love to create and build awesome reports, you may get an error when running report builder on a remote computer. When editing an SCCM report in Report Builder you may 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.) SCCM Report Builder error – 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. This starts the Microsoft Management Console (MMC) In the console, click the File menu and then click Add/Remove Snap-in On the … 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 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

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 statements is true : The remote location is between 500 and 5000 clients Needs to compress traffic going to the site Needs to control the upward flowing traffic Needs a local Management Point Needs a local Software Update Point If you’re still convinced that it’s the right option, follow this … 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 Is_Virtual_Machine is provided? On the server itself, there’s a WMI query in the hardware inventory (InventoryAgent.log) pointing at CCM_DesktopMachine WMI class trying to find a field IsVirtual. As you can see, there’s no issue there. We can see IsVirtual at FALSE in the WMI class. Where is the problem? After few queries in the database, we … Read More