Activating Microsoft SQL Server 2022 Standard

Note: this guide only concerns licence activation of Microsoft SQL Server 2022 Standard, not system installation. For SQL Server, activation involves assigning a valid product key to the installed instance or edition, and then checking if the server reports the correct edition. SQL Server does not use the slmgr.vbs /ipk and slmgr.vbs /ato mechanism, which applies to Windows Server activation.

Activating with a Product Key

1. Activation via Graphical Interface

If SQL Server 2022 was installed in Evaluation or Developer edition and you want to switch to Standard, use the built-in edition change mechanism:

1. Open SQL Server Installation Center.
2. Go to Maintenance.
3. Select Edition Upgrade.
4. Indicate the relevant SQL Server instance.
5. Enter the 25-character product key for SQL Server 2022 Standard.
6. Accept the licence terms and complete the wizard.
7. After completion, restart the SQL Server service or the entire server if the wizard requires it.

This is the basic and recommended activation method in administrative environments.

2. Activation via Command Line

Activation can also be performed using CMD run as administrator, using the SQL Server 2022 installation media:

setup.exe /Q /ACTION=EditionUpgrade /INSTANCENAME=MSSQLSERVER /PID=XXXXX-XXXXX-XXXXX-XXXXX-XXXXX /IACCEPTSQLSERVERLICENSETERMS

For a named instance, use the correct name after the INSTANCENAME parameter, for example:

setup.exe /Q /ACTION=EditionUpgrade /INSTANCENAME=SQL2022 /PID=XXXXX-XXXXX-XXXXX-XXXXX-XXXXX /IACCEPTSQLSERVERLICENSETERMS

If you prefer a graphical mode invoked from the console, you can run:

setup.exe /ACTION=EditionUpgrade

Then go through the wizard and enter the key manually.

3. Telephone Activation

In the case of SQL Server, there is no typical telephone scenario with an installation code, known from Windows activation. However, if the key does not pass validation, the licence was purchased through a different channel, or the system reports a problem with using the key, contact Microsoft support at:

00 800 121 1654

During the conversation, have ready:

• the full product key,
• proof of purchase or order number,
• information about the licensing channel,
• product version: Microsoft SQL Server 2022 Standard,
• instance name and error message screenshot.

For any further assistance or questions, please contact KluczeSoft at [email protected].

Activation Verification

The most reliable method is to check the edition reported by the running SQL Server instance.

Verification via sqlcmd

sqlcmd -S localhost -E -Q "SET NOCOUNT ON; SELECT SERVERPROPERTY('Edition') AS Edition, SERVERPROPERTY('ProductVersion') AS ProductVersion, SERVERPROPERTY('ProductLevel') AS ProductLevel;"

For a named instance:

sqlcmd -S localhost\SQL2022 -E -Q "SET NOCOUNT ON; SELECT SERVERPROPERTY('Edition') AS Edition, SERVERPROPERTY('ProductVersion') AS ProductVersion, SERVERPROPERTY('ProductLevel') AS ProductLevel;"

The correct result should contain the edition Standard Edition.

Verification in T-SQL Query

SELECT
    SERVERPROPERTY('Edition') AS Edition,
    SERVERPROPERTY('ProductVersion') AS ProductVersion,
    SERVERPROPERTY('ProductLevel') AS ProductLevel;

Verification of Installer Logs

If you want to confirm that the edition change operation was successful, check the Setup logs:

type "C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\Summary.txt"

If the file is located in a different log folder, also check:

dir "C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log"

Activation Troubleshooting

Below are the most common real errors related to activating or changing the edition of SQL Server 2022 Standard.

Error 0x84B10001

Usually indicates an invalid or unsupported product key.
What to do: check if the key is intended exactly for SQL Server 2022 Standard, and not for another version or licensing channel.

Error 0x84C40013

Often appears when the edition change path is not supported.
What to do: ensure that the current edition can be upgraded to Standard using Edition Upgrade.

Error 0x84BE0BC2

Most often relates to a problem with running installer rules or Setup components.
What to do: run setup.exe as an administrator, temporarily disable policies blocking the installer, and check the Summary.txt log.

Error 0x858C001B

May indicate a problem with the installer service or inconsistency of media components.
What to do: use the original SQL Server 2022 media, copy the installer locally, and run the system again.

Error 0x84B20002

Is associated with failure to validate parameters or incorrect instance specification.
What to do: confirm the correctness of INSTANCENAME and repeat the command with the correct name.

Licensing Channel Incompatibility Message

Appears when the key comes from a different sales model than the deployed media version.
What to do: contact Microsoft at 00 800 121 1654 and confirm licensing channel compatibility.

What to Do When the Key Does Not Work

If the key is not accepted:

• check if you are not entering a key from a different version, for example 2019 instead of 2022,
• confirm that the key is for SQL Server Standard, and not Enterprise, CAL, or a related product,
• ensure you are using the correct media and the correct Edition Upgrade path,
• compare the error message with the Summary.txt log,
• contact the seller to confirm the license origin,
• if necessary, call Microsoft: 00 800 121 1654.

If the purchase concerns SQL Server + CAL, remember that CAL does not activate with a key. CAL is a licensing document confirming user or device access rights, not a separate code to enter into the system. For any further assistance, you can also contact KluczeSoft at [email protected].

Reactivation after hardware change

After migrating a server, replacing the mainboard, or restoring a virtual machine, it may be necessary to reassign the licence to the new instance or new host in accordance with the licence terms.

The safest procedure:

1. Install the same version of SQL Server 2022.
2. Perform the Edition Upgrade again and enter the product key.
3. Verify the edition using the sqlcmd command.
4. If the key is rejected after a significant hardware change, contact Microsoft on 00 800 121 1654.

Summary

Activation of Microsoft SQL Server 2022 Standard is done by entering the correct product key in the Edition Upgrade wizard or via CMD with the /PID parameter. You can confirm the correctness of the activation with the command:

sqlcmd -S localhost -E -Q "SET NOCOUNT ON; SELECT SERVERPROPERTY('Edition') AS Edition, SERVERPROPERTY('ProductVersion') AS ProductVersion, SERVERPROPERTY('ProductLevel') AS ProductLevel;"

If the key does not work, validation errors occur, or reactivation after a hardware change fails, prepare the key and proof of purchase, and then contact Microsoft support: 00 800 121 1654. Alternatively, you can also contact KluczeSoft at [email protected] for assistance.