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 ...
Get Troubleshooting System Center Configuration Manager now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
