Browsing Category
SQL
Microsoft SQL Server is a relational database management system, or RDBMS, that supports a wide variety of transaction processing, business intelligence and analytics applications in corporate IT environments. SQL itself stands for Structured Query Language. This is the language used to manage and administer the database server.
SCCM SQL Query for Microsoft Office 32 Bit and 64 Bit
This post contains the SCCM SQL query for Microsoft office 32 bit and 64 bit. Many organizations today use Microsoft office to simply the work. Listing out office versions installed on all machines is…
SCCM 1606 Upgrade SQL Server 2014 to SQL Server 2016
SCCM 1606 Upgrade SQL Server 2014 SQL Server 2016 - In this post we will see the steps to upgrade SQL server 2014 to SQL Server 2016. This post is related to SCCM as we will be performing an inplace…
Supported SQL Server versions for SCCM Current Branch
In this post we will look at the supported SQL server versions for SCCM current branch. When you install SCCM, you require SQL server to host the site database. This SQL server version should be…
Fix SCCM SQL Server Report Builder Access Error
Fix SCCM SQL Server Report Builder Access Error - While editing SCCM SQL server reports one of my colleague got an error. The error was "The certificate chain was issued by an authority that is not…
Create ConfigMgr SQL Server Identification Certificate
Few days back while working on implementing PKI for SCCM, I encountered an issue related to SQL server certificate. To identify the root cause of this issue, it took some time but at the end it was…
How to Re-install SQL Reporting Services for SCCM
In this post we will look at the steps on how to re-install SQL Reporting Services for SCCM. When you are reading this post, just understand that this post is not about reinstalling the reporting…
SCCM Prerequisite Required SQL Server Collation
SCCM Prerequisite Required SQL Server Collation The SQL server collation acts as the default collation for all system databases that are installed with the instance of SQL Server and also any newly…
Installing SQL Server 2012 for Configuration Manager 2012 R2
In this post we will be looking at the steps for Installing SQL Server 2012 for Configuration Manager 2012 R2. In this deployment series of Configuration Manager 2012 R2 we started with system center…