如何通过操作系统获取SQL Server的各类配置变量参数

DevOps 小满

2026-10-4

可行实现方法（Powershell）

你之前查的注册表路径和环境变量没有命中SQL实例的专属配置项，用以下脚本可以直接批量获取所有本地SQL实例的所需参数：

# 自动适配SQL版本的WMI命名空间
$sqlCMNamespace = Get-ChildItem "HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server" | 
    Where-Object {$_.PSChildName -match '^ComputerManagement\d+$'} | 
    Select-Object -First 1 -ExpandProperty PSChildName
$wmiNamespace = "root\Microsoft\SqlServer\$sqlCMNamespace"

# 筛选数据库引擎实例（排除代理、分析服务等其他SQL服务）
$engineInstances = Get-CimInstance -Namespace $wmiNamespace -ClassName SqlService | 
    Where-Object {$_.SqlServiceType -eq 1}

foreach ($ins in $engineInstances) {
    Write-Host "`n=== 实例 $($ins.InstanceName) 配置信息 ==="
    # 1. 实例名
    Write-Host "INSTANCE NAME = `"$($ins.InstanceName)`""

    # 从注册表读取实例专属配置
    $instanceId = (Get-ItemProperty "HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL").$($ins.InstanceName)
    $instanceRegSetupPath = "HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\$instanceId\Setup"

    # 2. DB版本
    $version = (Get-ItemProperty $instanceRegSetupPath).Version
    Write-Host "DB VERSION = `"$version`""

    # 3. DB HOME路径
    $dbHome = (Get-ItemProperty $instanceRegSetupPath).SQLPath
    Write-Host "DB HOME = `"$dbHome`""

    # 4. 错误日志路径
    $logPath = Get-CimInstance -Namespace $wmiNamespace -ClassName SqlServiceAdvancedProperty | 
        Where-Object {$_.ServiceName -eq $ins.ServiceName -and $_.PropertyName -eq "ErrorLogPath"} | 
        Select-Object -ExpandProperty PropertyStrValue
    Write-Host "ERROR LOG = `"$(Join-Path $logPath "ERRORLOG")`""
}