SQL Server

Microsoft SQL Server is at the core of Configuration Manager, even more so now than in previous versions of the product. Therefore, it goes without saying that we need to ensure that the database server and services remain healthy at all times in order to keep our Configuration Manager environment running smoothly. We will cover some best practices in a later chapter; however, as usual, it is worthwhile knowing your way around Microsoft SQL Server if you are a Configuration Manager administrator. It should be noted right away that Configuration Manager has a very strict policy on database and instance collation, which should always be set to SQL_Latin1_General_CP1_CI_AS. Any other collation is not supported and can create unpredictable results in our Configuration Manager installation. To change this, generally would require a reinstallation of SQL Server; there are exceptions but this is usually the easier option. Let us take a look at some of the other common factors that can...