SystemCenter

All about System Center Articles and Tutorials

Install SQL Server 2016 for System Center Operations Manager 2016

Posted by on Sep 22, 2017 in SCOM, SCOM 2016, SQL

Install SQL Server 2016 for System Center Operations Manager 2016

If you are planning to perform System Center Operations Manager installation, the first thing which needs to be done before running the SCOM setup will be the SQL Server installation. Make sure you have installed the .NET Framework 3.5 before starting the SQL Server installation otherwise you will get the installation error. You can install .NET Framework 3.5 from Add Roles and...

Read More

Check if Specific Hotfix installed on a Collection – SCCM

Posted by on Aug 11, 2017 in SCCM, SQL

Check if Specific Hotfix installed on a Collection – SCCM

Recently we got a request from our Platform Team whether we can fetch any report from System Center Configuration Manager to check if specific Hotfixes installed on all the servers managed by them. After further discussion, we got to know that they wanted to check all the systems that miss the WannaCry related hotfixes. Let’s create the report using Microsoft SQL Server Report Builder. Before...

Read More

Build SCCM Report to check Installed Hotfixes on a System

Posted by on Jul 11, 2017 in SCCM, SQL

Build SCCM Report to check Installed Hotfixes on a System

Recently after couple of Ransomware attacks, we have got a requirement from our Server Operations team whether they can get a report wherein they can get a list of installed Hotfixes on a system. There are sites which provides the PowerShell scripts to check this information, however they wanted us to author a report in SCCM through which they can get list of installed Hotfixes on a system. So,...

Read More

Configure Reporting Services & Install Reporting Services Point Role – Configuration Manager

Posted by on Jul 5, 2017 in SCCM, SQL

Configure Reporting Services & Install Reporting Services Point Role – Configuration Manager

System Center Configuration Manager provides Reporting feature using advanced reporting capabilities of SQL Server Reporting Services (SSRS). It uses SQL Server Report Builder as the exclusive authoring and editing tool for model-based and SQL-based reports through which we can author desired reports to gather, organize and present the information about users, hardware, software inventory,...

Read More

Fix – The SQL server name specified during setup must match the Name in sys.servers of the SQL server

Posted by on Jun 30, 2017 in SCCM, SQL

Fix – The SQL server name specified during setup must match the Name in sys.servers of the SQL server

Recently we got into a situation wherein we were trying to install a stand-alone Primary Site by running system Center Configuration Manager setup in our staging environment. The setup passed all the prerequisite checks however the installation got stuck while setting up the SQL Server database. Below is the error message: The SQL server name specified during setup must match the Name in...

Read More

Install SQL Server 2016 for System Center Configuration Manager

Posted by on Jun 7, 2017 in SCCM, SQL

Install SQL Server 2016 for System Center Configuration Manager

If you are planning to perform System Center Configuration Manager installation, the first thing which needs to be done before running the SCCM setup will be the SQL Server installation. Make sure you have installed the .NET Framework 3.5 before starting the SQL Server installation otherwise you will get the installation error. You can install .NET Framework 3.5 from Add Roles and...

Read More