How to install and activate Microsoft SQL Server 2022 Standard — a complete guide

Before You Begin

Microsoft SQL Server 2022 is the latest version of Microsoft's flagship database, released on 16 November 2022. The Standard edition with a 24-core license is the most commonly chosen configuration for medium-sized companies — sufficient to support thousands of users and databases up to 524 PB in size.

Support Cycle

SQL Server 2022 will be supported with security patches until 2033 — the longest support horizon of all current SQL Server editions.

System Requirements

Important: SQL Server 2022 also runs on Linux (Ubuntu, RHEL, SUSE) and in Docker containers. This guide applies to installation on Windows.

Standard vs Enterprise — When to Choose Which Edition?

For most companies: Standard with 24 cores supports thousands of users, databases up to 128 GB RAM, and basic availability groups. Enterprise is needed for: partitioning large tables, full columnstore compression, advanced AG with multiple replicas.

Step 1: Download the SQL Server 2022 Installer

1. Go to the Microsoft Evaluation Center → SQL Server 2022
2. Choose ISO (offline file, ~1.5 GB) or Media download
3. Alternatively: download from Volume Licensing Service Center (VLSC) if you have a volume license

Note: You can install the Evaluation version (180-day trial) and later activate it with a Standard key. No reinstallation is required.

Step 2: Install Prerequisites

On Windows Server 2022/2019:

1. Install all Windows Update updates
2. Install .NET Framework 4.8 (usually already included in Windows Server 2022)
3. Ensure you have Windows PowerShell 5.1 or later
4. Disable antivirus during installation (or add an exception for the SQL Server directory)

For SQL Server with full-text search (Full-Text Search):

• Install Oracle Java SE or OpenJDK (required for PolyBase)

Step 3: Run the Installer

1. Mount the downloaded ISO file
2. Run setup.exe as Administrator
3. Select Installation → New SQL Server stand-alone installation
4. On the Product Key screen:
   • Enter the 25-character key from KluczeSoft
   • Or select Evaluation (activate later)
5. Accept the licence terms
6. On the Feature Selection screen, select:
   • ✓ Database Engine Services (required)
   • ✓ SQL Server Replication (recommended)
   • ✓ Full-Text and Semantic Extractions for Search (optional)
   • ✓ Management Tools — SSMS is installed separately (see Step 5)
7. Instance Configuration: Named Instance or Default Instance
8. Server Configuration: set service accounts (Service Accounts)
   • Recommended: dedicated domain accounts or NT Service\MSSQLSERVER
9. Database Engine Configuration:
   • Authentication Mode: Mixed Mode (Windows + SQL Authentication)
   • Set the sa password (strong password!)
   • Add the current user as SQL Server Administrator
   • Data Directories tab: set data, log, and TempDB file locations on separate disks (performance!)
10. Click Install — installation takes 15-30 minutes

Step 4: Activate with Product Key

If you entered the key during installation

Done — SQL Server is already activated. Verify in SSMS (see below).

If you installed Evaluation and want to activate now

Method A: SQL Server Management Studio (SSMS)

1. Open SQL Server Management Studio (SSMS)
2. Connect to the SQL Server instance
3. Right-click on the server → Properties → General
4. Click Change next to "Product" → enter the key
5. Restart the SQL Server service

Method B: Setup.exe (Edition Upgrade)

1. Run setup.exe again from the ISO
2. Select Maintenance → Edition Upgrade
3. Enter the Standard product key
4. Go through the wizard — upgrade takes a few minutes
5. Restart the SQL Server service

Method C: Command Line

Run from the SQL Server installation directory:

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

Activation Verification

In SSMS, run the query:

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

The result should contain: Edition = Standard Edition (64-bit).

Alternatively, in PowerShell:

Get-Service MSSQLSERVER | Select-Object Name, Status

Step 5: Install SQL Server Management Studio (SSMS)

SSMS is no longer included with the SQL Server installer — you must download it separately:

1. Go to learn.microsoft.com → search for "Download SSMS"
2. Download the latest SSMS 20.x (free)
3. Install — SSMS works on Windows 10/11 and Windows Server
4. After installation: Connect → Server name: localhost or .\INSTANCE → Authentication: Windows

If you need help, please contact us at [email protected] or call 00 800 121 1654.

Step 6: Post-Installation Configuration

Set Memory Limits

SQL Server defaults to consuming all available RAM. Restrict this:

EXEC sp_configure 'max server memory', 102400; -- 100 GB (leaving 28 GB for OS)
RECONFIGURE;

Rule of thumb: leave at least 4 GB for the operating system, allocate the rest to SQL Server.

Enable Remote Access (if required)

1. SQL Server Configuration Manager → SQL Server Network Configuration → Protocols
2. Enable TCP/IP (disabled by default!)
3. Properties → IP Addresses → IPAll → TCP Port: 1433
4. Restart the SQL Server service
5. Open port 1433 in Windows Firewall

Configure Backup

-- Full database backup
BACKUP DATABASE [MyDatabase] TO DISK = 'D:\Backups\MyDatabase_full.bak'
WITH COMPRESSION, CHECKSUM;

Set SQL Server Agent for automated backups (Maintenance Plan or T-SQL script in Agent Job).

Enable Query Store (recommended)

ALTER DATABASE [MyDatabase] SET QUERY_STORE = ON;
ALTER DATABASE [MyDatabase] SET QUERY_STORE (OPERATION_MODE = READ_WRITE);

Query Store collects query statistics — essential for performance optimisation.

What's New in SQL Server 2022

SQL Server 2022 Licensing

Core-Based Model (recommended)

Licensing per core — you buy licenses for physical processor cores:

• Minimum: 4 cores per processor
• Minimum processors: required coverage of all cores on the server
• 24 Core license covers a server with 1-2 processors with 12 cores each

Server + CAL Model (alternative)

For smaller environments with a limited number of users:

Example: company with a database server (2x Xeon 12-core)

• 1× SQL Server 2022 Standard 24 Core: 2999 zł (covers 24 cores)
• No additional per-user costs (core-based = unlimited users)
• One-time cost, perpetual license

Comparison with Azure SQL: Azure SQL Database in a comparable configuration (8 vCores, Business Critical) costs ~5000 zł/month. Your own SQL Server pays for itself after 3 weeks.

If you have any questions or need help with SQL Server, please contact us at [email protected] or call 00 800 121 1654.

Troubleshooting

Installer does not start

• Check if you have Administrator privileges
• Disable antivirus during installation
• Check logs: C:\Program Files\Microsoft SQL Server\160\Setup Bootstrap\Log\Summary.txt

Product key is not accepted

• Standard key will not work on Enterprise and vice versa
• SQL Server 2019 key will not work on 2022
• Format: XXXXX-XXXXX-XXXXX-XXXXX-XXXXX (25 characters)

I cannot connect remotely

• Check if TCP/IP is enabled in SQL Server Configuration Manager
• Check if port 1433 is open in the firewall
• Check if SQL Server Browser service is running (for named instances)

SQL Server uses all RAM

• This is normal behaviour — SQL Server intentionally uses maximum available memory
• Limit: sp_configure 'max server memory' (see Step 6)

How to check SQL Server version?

In SSMS: SELECT @@VERSION — displays full version information, CU and build number.

SQL Server version comparison

If you're looking for a cheaper option: SQL Server 2019 Standard (2149 zł) with support until 2030 — a solid alternative. All SQL Server versions available at KluczeSoft.

Summary

SQL Server 2022 Standard 24 Core for 2999 zł is a one-time investment with support until 2033. It supports an unlimited number of users (core-based model), databases up to 524 PB and up to 128 GB RAM. You will receive the product key immediately by email — you can activate it during installation or later through SSMS.

Microsoft Poland technical support: 00 800 121 1654 (free Polish-language line) For any other questions, please contact us at [email protected]