SQL Server 安裝後將 DigitalProductID(Base24 編碼)寫入登錄檔,路徑依版本不同:
| 版本 | 登錄檔路徑 |
|---|---|
| SQL Server 2008 / 2008 R2 | HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\100\Tools\Setup |
| SQL Server 2012 | HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\110\Tools\Setup |
| SQL Server 2014 | HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\120\Tools\Setup |
| SQL Server 2016 | HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\130\Tools\Setup |
| SQL Server 2017/2019 | HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\140/150\Tools\Setup |
值名稱:DigitalProductID(非 ProductCode,後者僅為產品代碼)。
USE master;
GO
EXEC xp_regread 'HKEY_LOCAL_MACHINE',
'SOFTWARE\Microsoft\Microsoft SQL Server\130\Tools\Setup',
'DigitalProductID'; -- 依版本調整路徑
function Get-SqlProductKey {
param(
[string]$Instance = "MSSQLSERVER",
[ValidateSet('2008','2012','2014','2016','2017','2019')][string]$Version = '2019'
)
$versionMap = @{ '2008'='100'; '2012'='110'; '2014'='120'; '2016'='130'; '2017'='140'; '2019'='150' }
$regPath = "SOFTWARE\Microsoft\Microsoft SQL Server\$($versionMap[$Version])\Tools\Setup"
$hklm = 2147483650 # HKEY_LOCAL_MACHINE
$wmi = [WmiClass]"\\.\root\default:stdRegProv"
$bin = ($wmi.GetBinaryValue($hklm, $regPath, 'DigitalProductID').uValue)[0..16] # 2012+ 取 0..16;2008 取 52..66
$map = 'B','C','D','F','G','H','J','K','M','P','Q','R','T','V','W','X','Y','2','3','4','6','7','8','9'
$key = ''
for ($i = 24; $i -ge 0; $i--) {
$k = 0
for ($j = 14; $j -ge 0; $j--) {
$k = ($k * 256) -bxor $bin[$j]
$bin[$j] = [math]::Floor($k / 24)
$k = $k % 24
}
$key = $map[$k] + $key
if ($i % 5 -eq 0 -and $i -ne 0) { $key = '-' + $key }
}
return $key
}
# 使用範例
Get-SqlProductKey -Version 2019
Get-SqlProductKey -Version 2012
Computer : .
OSCaption : Microsoft Windows Server 2019 Datacenter
OSArch : 64-bit
SQLVersion : 15.0.4073.23
SQLEdition : Enterprise Edition
ProductKey : XXXXX-XXXXX-XXXXX-XXXXX-XXXXX
DigitalProductID。