- Deploying Microsoft System Center Configuration Manager
- Jacek Doktor Pawel Jarosz
- 169字
- 2021-07-02 18:32:37
MS SQL Server role in ConfigMgr environment
There have been a lot of changes in SQL Server use cases since ConfigMgr 2007. In all versions prior to 2012, SQL Server was only used for primary site needs. Since version 2012, all server types--central administration site, primary site, and secondary site, use SQL Server to store data.
For central administration site and primary site, we may use MS SQL Standard or Enterprise Edition. Secondary sites support MS SQL in Standard or Express versions:
The configuration of SQL Servers for ConfigMgr servers
When installing the secondary site server, SQL Express installation is conducted automatically by the ConfigMgr server. If we are more likely to use SQL Standard, we need to install SQL Server before starting the installation of the secondary site server.
Because SQL Server is being used by all ConfigMgr server types, to ease work, it is recommended that you use GPO to open appropriate ports on the Windows firewall, allowing communication between SQL and ConfigMgr servers.