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

Before You Begin

SQL Server 2017 Standard (code name: vNext) is a groundbreaking version of Microsoft's database — the first SQL Server available on Linux. Released on 2 October 2017, it is still covered by extended support until 12 October 2027.

Support Cycle

System Requirements

Important: SQL Server 2017 is not officially supported on Windows Server 2022. It supports WS 2012 R2, 2016, and 2019.

Standard vs Enterprise

Step 1: Download SQL Server 2017

1. Microsoft Evaluation Center → SQL Server 2017 → download ISO
2. Alternatively: Volume Licensing Service Center (VLSC)
3. We recommend downloading the version with CU31 (latest cumulative update)

Step 2: Prerequisites

1. Install all Windows Update updates
2. .NET Framework 4.8
3. PowerShell 5.1+
4. Disable antivirus during installation

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 Evaluation
4. Feature Selection: Database Engine Services (required), Replication, Full-Text Search
5. Instance Configuration: Default or Named Instance
6. Database Engine Configuration:
   • Authentication: Mixed Mode (Windows + SQL)
   • sa password (strong!)
   • Data Directories: separate disks for data, logs, TempDB
7. Install — 15-30 minutes

Step 4: Activation with Product Key

Method A: During Installation

Enter the key on the Product Key screen.

Method B: SSMS after Installation

1. SSMS → connect to server → right-click → Properties → General
2. Change next to Edition → enter key → OK
3. Restart SQL Server service

Method C: Edition Upgrade

Setup.exe → Maintenance → Edition Upgrade → enter key

Method D: Command Line

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

Verification

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

Step 5: Post-Installation Configuration

Limit Memory

Enable TCP/IP

SQL Server Configuration Manager → Protocols → TCP/IP → Enable. Port: 1433. Restart the service.

Firewall

Open port 1433 (TCP) and 1434 (UDP for Browser).

Enable Query Store

Enable Automatic Tuning

Key New Features of SQL Server 2017

First SQL Server on Linux

Historic change — full SQL Server version on Ubuntu, RHEL, and SUSE.

Graph Databases

Native support for graphs (NODE, EDGE, MATCH) — ideal for social networks and recommendations.

Adaptive Query Processing

• Adaptive Joins — the engine itself chooses the join type
• Memory Grant Feedback — automatic memory allocation correction
• Interleaved Execution — optimization of table functions

Automatic Tuning

SQL Server automatically detects query plan regressions and reverts to previous, better plans.

Python and R Integration

Machine Learning Services — run Python and R scripts directly in SQL queries.

Resumable Online Index Rebuild

Online index rebuild with pause and resume capability — without losing progress.

Licensing

Comparison of SQL Server Versions

Troubleshooting

Key is Not Accepted

• SQL 2017 key ≠ SQL 2019/2022 key
• Standard ≠ Enterprise
• Format: XXXXX-XXXXX-XXXXX-XXXXX-XXXXX

Cannot Connect Remotely

• Enable TCP/IP in SQL Server Configuration Manager
• Port 1433 in firewall
• Run SQL Server Browser (named instances)

SQL Server Uses All RAM

Normal. Limit: sp_configure max server memory.

How to Check Version?

SELECT @@VERSION

Summary

SQL Server 2017 Standard 24 Core for 1349 zł — a solid database with support until 2027, first on Linux, with Adaptive Query Processing and Automatic Tuning. Key sent immediately via e-mail.

Microsoft Poland Technical Support: 00 800 121 1654 For any questions or concerns, please contact us at [email protected]