要实现ZTI(Zero Touch Installation 零接触部署),必须与Configuration Manager结合 。
1. 安装ADK和SQL Server 2019: (略)
.\setup.exe /action=install /features=SQLEngine /SQLCOLLATION="SQL_Latin1_General_CP1_CI_AS" /skiprules=servercoreblockunsupportedfeaturescheck /iacceptsqlserverlicenseterms
安装SQL server 补丁:
.\SQLServer2019-KB5005679-x64-CU13.exe /qs /IAcceptSQLServerLicenseTerms /Action=Patch /INSTANCENAME="MSSQLSERVER"
通过Powershell 查询安装的SQL Server 版本号:
Install-Module -Name SqlServer
Get-Module SqlServer -ListAvailable
Import-Module sqlserver
Invoke-SqlCmd -query "select @@version" -ServerInstance "localhost" |fl
New-NetFirewallRule -DisplayName "SQLServer default instance" -Direction Inbound -LocalPort 1433 -Protocol TCP -Action Allow
New-NetFirewallRule -DisplayName "SQLServer Browser service" -Direction Inbound -LocalPort 1434 -Protocol UDP -Action Allow
下载并安装SQL Server Management Studio:https://aka.ms/ssmsfullsetup
.\SSMS-Setup-CHS.exe /install /quiet /norestart
2.在AD中创建并分配System Management容器权限
3.扩展AD架构:
以具有Schema Admins安全组成员的用户运行MECM安装iso 文件中 的
SMSSETUP\BIN\X64\extadsch.exe
4.安装MECM所需的Windows 组件:
Add-WindowsFeature Web-Windows-Auth,Web-ISAPI-Ext,Web-Metabase,Web-WMI,BITS,RDC,NET-Framework-Features,Web-Asp-Net,Web-Asp-Net45,NET-HTTP-Activation,NET-Non-HTTP-Activ,Web-Static-Content,Web-Default-Doc,Web-Dir-Browsing,Web-Http-Errors,Web-Http-Redirect,Web-App-Dev,Web-Net-Ext,Web-Net-Ext45,Web-ISAPI-Filter,Web-Health,Web-Http-Logging,Web-Log-Libraries,Web-Request-Monitor,Web-HTTP-Tracing,Web-Security,Web-Filtering,Web-Performance,Web-Stat-Compression,Web-Mgmt-Console,Web-Scripting-Tools,Web-Mgmt-Compat -Restart
4.开始MECM:Microsoft Endpoint Configuration Manager 2107
服务器的计算机账号已经添加并已经对“System Management”容器配置“完全控制”权限,可忽略这条警告,点“开始安装”
开始安装:
安装完成,接下来就安装后的配置: