Difference between revisions of "Microsoft SQL Server License"
Jump to navigation
Jump to search
↑ https://www.sqlshack.com/sql-server-edition-upgrade/
(Created page with "{{Draft}} [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...") Tags: Mobile web edit, Mobile edit |
|||
(3 intermediate revisions by the same user not shown) | |||
Line 8: | Line 8: | ||
[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> | ||
+ | |||
+ | |||
+ | <pre> | ||
+ | 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 | ||
+ | </pre> | ||
== See also == | == See also == | ||
* {{SQL Server}} | * {{SQL Server}} | ||
+ | * {{Windows}} | ||
+ | |||
+ | [[Category:Licenses]] | ||
+ | [[Category:Databases]] |
Latest revision as of 06:21, 30 November 2020
This article is a Draft. Help us to complete it.
[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: