To help you to write SQL statements for Configuration Manager reports, you can use the query design tool found in SQL Server Management Studio. For some administrators, it is much easier to use Query ...

This article describes how to upgrade the SQL Server supporting System Center Operations Manager databases to SQL Server 2019. Operations Manager 2019 and later supports SQL 2019 with CU8 or later; ...

The Developer Edition of SQL Server is not set up for Remote connections by default so I had to enable TCP/IP in the SQL Configuration Manager for the Database Servers.

1. Change registry key SqlCluster in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.x\Setup\ from 1 to 0 2. Disable TCP/IP in Server Network Protocols and enabled Named Pipes from ...