How to Install and Activate Microsoft SQL Server 2019 Standard — A Complete Guide

Before You Begin

Microsoft SQL Server 2019 (codename: Seattle) is the second-to-last version of Microsoft's flagship database, released on 4 November 2019. The Standard edition with a 24-core license is a popular configuration for medium-sized businesses — cheaper than SQL Server 2022, yet still covered by extended support until January 2030.

Support Cycle

Note: Mainstream support (new features, non-security fixes) ended in January 2025. SQL Server 2019 still receives security fixes as part of extended support — until January 2030. This is still over 3.5 years of secure usage.

System Requirements

SQL Server 2019 also runs on Linux (Ubuntu 16.04+, RHEL 7+, SUSE 12+) and in Docker containers.

SQL Server 2019 vs 2022 — What Do You Lose by Choosing the Older Version?

Conclusion: SQL Server 2019 is a solid option for 850 zł less than 2022. You lose Ledger, Synapse Link, and improved IQP — but for a typical company, these features are not critical. Support until 2030 provides over 3.5 years of security.

Step 1: Download SQL Server 2019

1. Microsoft Evaluation Center → SQL Server 2019 → download ISO (~1.5 GB)
2. Alternatively: Volume Licensing Service Center (VLSC) if you have a volume license
3. You can install the Evaluation version (180 days) and activate it with a Standard key later

Step 2: Prerequisites

On Windows Server 2019/2022:

1. Install all Windows Update updates
2. Install .NET Framework 4.8
3. PowerShell 5.1 or later
4. Disable antivirus during installation (or add an exception)

Step 3: Installation

1. Mount the ISO, run setup.exe as Administrator
2. Installation → New SQL Server stand-alone installation
3. Product Key: enter the key from KluczeSoft or select Evaluation
4. Feature Selection:
   • ✓ Database Engine Services
   • ✓ SQL Server Replication
   • ✓ Full-Text Search (optional)
5. Instance Configuration: Default or Named Instance
6. Database Engine Configuration:
   • Authentication: Mixed Mode (Windows + SQL)
   • Set the sa password (strong!)
   • Add yourself as SQL Server Administrator
   • Data Directories: place data files, logs, and TempDB on separate disks
7. Install — 15-30 minutes

Restart the server after installation.

Step 4: Product Key Activation

Method A: During Installation

Enter the key on the Product Key screen — the simplest method.

Method B: After Installation via SSMS

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

Method C: Edition Upgrade

1. Run setup.exe from the ISO
2. Maintenance → Edition Upgrade
3. Enter the Standard key
4. Upgrade without reinstallation — data and databases preserved

Method D: Command Line

Run from the installation directory:

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

Verification

In SSMS:

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

Expected result: Standard Edition (64-bit), Version: 15.0.xxxx.

Step 5: Post-Installation Configuration

Install SSMS

Download the latest version of SQL Server Management Studio 20.x (free) from the Microsoft website.

Limit Memory

-- Leave at least 4 GB for the OS, allocate the rest to SQL Server
EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
EXEC sp_configure 'max server memory', 102400; -- 100 GB example
RECONFIGURE;

Enable Remote Access

1. SQL Server Configuration Manager → Protocols → enable TCP/IP
2. TCP Port: 1433
3. Open port 1433 in Windows Firewall
4. Restart the SQL Server service

Configure Backup

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

Enable Query Store

ALTER DATABASE [MyDatabase] SET QUERY_STORE = ON;

Key Features of SQL Server 2019

Intelligent Query Processing (IQP)

SQL Server 2019 introduced the first generation of IQP — automatic query optimization without changes to application code:

• Batch Mode on Rowstore — acceleration of analytical queries on OLTP tables
• Table Variable Deferred Compilation — better estimation of table variable cardinality
• Adaptive Joins — the engine automatically chooses between Nested Loops and Hash Join

Accelerated Database Recovery (ADR)

Dramatically faster database recovery after a failure — regardless of database size. In SQL 2017, recovering a 1 TB database could take hours. In 2019 — minutes.

Always Encrypted with Secure Enclaves

Encryption of data in the database with the ability to perform operations on encrypted data (comparisons, sorting) within a secure processor enclave.

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

Licensing

Core-Based Model

The licence covers up to 24 physical cores. The core-based model = unlimited number of users.

Server + CAL Model

SQL 2019 vs 2022 — Cost Comparison

If you do not need Ledger or Azure Synapse Link — SQL Server 2019 for 2149 zł with support until 2030 is an excellent budget option.

Troubleshooting

Key is not accepted

• SQL 2019 key ≠ SQL 2022 key — they are not interchangeable
• Standard ≠ Enterprise — edition-specific keys
• Format: XXXXX-XXXXX-XXXXX-XXXXX-XXXXX

Cannot connect remotely

• Enable TCP/IP in SQL Server Configuration Manager
• Open port 1433 in the firewall
• Run the SQL Server Browser service (for named instances)

SQL Server uses all RAM

Normal behaviour. Limit: sp_configure 'max server memory'.

How to check the version?

In SSMS: SELECT @@VERSION — displays full information.

Summary

SQL Server 2019 Standard 24 Core for 2149 zł — that's 850 zł cheaper than SQL Server 2022 with security support until January 2030. It supports up to 128 GB RAM, 24 cores, and an unlimited number of users. You will receive the key immediately via email.

If you need longer support (until 2033) or new features like Ledger — consider SQL Server 2022 Standard for 2999 zł.

Microsoft Poland Technical Support: 00 800 121 1654 (toll-free line)

For any questions or concerns, please contact us at [email protected].