SQL Server Configuration Manager is a tool that allows you to manage the security settings of your SQL Server instances, services, and network protocols. In this article, ...

Configuring SQL Server hardware for optimal performance is critical for database administrators. This involves understanding both the demands of your workload and the capabilities of your hardware ...

Disable SQL Server firewall during SCCM installation; Open ports with the script bellow, install SCCM and disable rules after. Configure rights for SCCM Server on SQL Server. This Step must be done if ...

Much of the Configuration Manager SQL Server view schema maps to the SMS Provider WMI schema, which is used when building WQL-based queries and collections in the Configuration Manager console.

If the value is the change for the configuration option you made but the value_in_use isn't the same, either the RECONFIGURE command wasn't run or has failed, or the [!INCLUDE ssde-md] must be ...

However, when you’re running SQL Server on-premises and configuring a hybrid architecture for DR, there are additional operational elements you should take into consideration.

Click "SQL Server Configuration Manager." Select "SQL Server Services" from the left pane and then right-click the server. Choose "Properties" from the context menu.

A step-by-step guide to deploying, configuring, and testing a multi-AZ, multi-region SQL Server FCI in the Azure cloud, complete with a PowerShell script that handles the networking configuration.

For more information about strong password requirements, see “Database Engine Configuration – Account Provisioning” in Setup Help or in SQL Server 2019 Books Online.