- 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.
推薦閱讀
- Learn ECMAScript（Second Edition）
- Raspberry Pi for Python Programmers Cookbook（Second Edition）
- 算法精粹：經典計算機科學問題的Java實現
- C語言實驗指導及習題解析
- PhpStorm Cookbook
- Rust Essentials（Second Edition）
- Mathematica Data Analysis
- Python忍者秘籍
- Learning Unity 2D Game Development by Example
- Learning OpenCV 3 Computer Vision with Python（Second Edition）
- 零基礎入門學習Python（第2版）
- Android應用案例開發大全（第二版）
- Zabbix Performance Tuning
- 區塊鏈國產化實踐指南：基于Fabric 2.0
- Java 9 with JShell