Difference between revisions of "Microsoft SQL Server License"
Jump to navigation
Jump to search
↑ https://www.sqlshack.com/sql-server-edition-upgrade/
Tags: Mobile web edit, Mobile edit |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
[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. | [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;<ref>https://www.sqlshack.com/sql-server-edition-upgrade/</ref> | ||
| − | |||
| − | + | [[ECLARE]] @Version NVARCHAR(128) | |
| − | ECLARE @Version NVARCHAR(128) | + | SET @Version = |
| − | SET @Version = | + | CONVERT(NVARCHAR(128),SERVERPROPERTY ('ProductVersion')) |
| − | + | SELECT | |
| − | 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 | |
| − | |||
| − | |||
Latest revision as of 14:12, 28 April 2025
[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[edit]
- 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: