- 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.
推薦閱讀
- C++面向對象程序設計（第三版）
- Unreal Engine Physics Essentials
- 碼上行動：零基礎學會Python編程（ChatGPT版）
- R語言編程指南
- Mastering Unity Shaders and Effects
- JAVA程序設計實驗教程
- Learning Unity 2D Game Development by Example
- UVM實戰
- C語言開發基礎教程（Dev-C++）（第2版）
- TMS320LF240x芯片原理、設計及應用
- Julia for Data Science
- 現代C++編程實戰：132個核心技巧示例（原書第2版）
- 嵌入式Linux C語言程序設計基礎教程
- Mastering ASP.NET Core 2.0
- Data Manipulation with R（Second Edition）