Microsoft SQL Server License
Jump to navigation
Jump to search
↑ https://www.sqlshack.com/sql-server-edition-upgrade/
[Error Message] The SQL Server product key is not valid. To proceed, re-enter the product key values from the Certificate of Authenticity (COA) or SQL Server packaging. [Details] Microsoft.SqlServer.Configuration.SetupExtension.InvalidPidException: The SQL Server product key is not valid. To proceed, re-enter the product key values from the Certificate of Authenticity (COA) or SQL Server packaging.
SELECT * FROM sys.dm_db_persisted_sku_features;[1]
ECLARE @Version NVARCHAR(128)
SET @Version =
CONVERT(NVARCHAR(128),SERVERPROPERTY ('ProductVersion'))
SELECT
CASE
WHEN @Version like '11%' THEN 'SQL SERVER 2012'
WHEN @Version like '12%' THEN 'SQL SERVER 2014'
WHEN @Version like '13%' THEN 'SQL SERVER 2016'
ELSE 'Unknown'
END AS 'Sql Server Version Name',
SERVERPROPERTY('ProductVersion') AS ProductVersion,
SERVERPROPERTY('Edition') AS Edition,
SERVERPROPERTY('ProductLevel') AS ProductLevel
See also
- SQL Server, SQL Server Management Studio, Microsoft SQL Server License, MDS
- Microsoft Windows: Windows 10, Windows 11, Windows Server, Windows IoT, Windows Server containers, RDP, Windows Update, Windows Defender, Windows Unified Write Filter (UWF), ReFS,
Start-Service, Stop-Service, Set-Service, DISM, SFC, systeminfo, Microsoft Hyper-V, WSL, Windows Terminal, Windows Subsystem for Linux (WLS), Windows Server 2022, PowerShell,logoff,query user, WLMS, File explorer, Copy-Item, BitLocker, Cmdlet,choco, scoop, Windows VSS
Advertising: