Install SQL Server 2022 Developer Edition on Windows (Step-by-Step)

Before you write T-SQL or configure high availability, you need a local SQL Server instance. SQL Server 2022 Developer Edition is free for non-production development and includes the same feature set as Enterprise — ideal for learning and labs.

Prerequisites: Windows 10/11 (64-bit) or Windows Server 2019+. Estimated time: 30–45 minutes including SSMS.

1. What is Developer Edition?

Microsoft ships several SQL Server editions. Developer Edition is licensed for development and test only — not production workloads — but supports advanced features like Always On, partitioning, and columnstore indexes that Standard omits.

If you outgrow a laptop lab, the same T-SQL and tools work on Azure SQL Database with minimal changes.

2. System requirements

Microsoft's minimums are conservative; for a comfortable dev machine aim higher:

• OS: Windows 10/11 64-bit or Windows Server 2019+
• CPU: x64 processor, 2+ cores
• RAM: 8 GB minimum; 16 GB recommended if you run SSMS, Docker, and IDEs together
• Disk: 6 GB for engine; 20+ GB free for sample databases and backups
• .NET: Installer bundles required runtimes

Disable sleep during installation and close memory-heavy apps to avoid setup timeouts.

3. Download SQL Server 2022

1. Visit the official Microsoft SQL Server downloads page.
2. Choose Developer (free) under the on-premises section.
3. Download the bootstrap SQL2022-SSEI-Dev.exe (or current naming).
4. Run the bootstrap and select Download Media if you want an offline ISO, or Basic for a minimal express-style path — for full control pick Custom.

Custom install gives you every feature checkbox and is what this tutorial follows.

4. Run the installation wizard

Launch setup.exe from the extracted media folder.

4.1 Installation type

1. On the left, click Installation.
2. Choose New SQL Server stand-alone installation (or add features to an existing instance later).

4.2 Edition and license

• Select Developer when prompted.
• Accept the license terms.

4.3 Feature selection

For a typical learning setup enable at minimum:

• Database Engine Services — core relational database
• Client Tools Connectivity — ODBC/OLE DB drivers

Optional (add later if needed):

• Machine Learning Services — R/Python in-database
• Full-Text and Semantic Extractions — advanced search

SSIS, SSAS, and SSRS are separate installs in modern releases — see our SSRS tutorial when you need reporting.

4.4 Instance configuration

• Default instance (MSSQLSERVER): connect as localhost — simplest for solo dev.
• Named instance: e.g. SQL2022DEV — connect as localhost\SQL2022DEV; useful when multiple versions coexist.

4.5 Data directories

Accept defaults or point data/log/backup folders to a fast SSD. Keep paths short without spaces when possible.

5. Authentication and admin accounts

On the Database Engine Configuration screen:

• Windows authentication mode — uses your Windows login; simplest on a personal PC.
• Mixed mode — allows SQL logins too; set a strong sa password and add your Windows user as a SQL Server administrator.

Click Add Current User so your Windows account is sysadmin. Mixed mode is helpful when tutorials use SQL authentication or when connecting from Linux containers.

6. Install SQL Server Management Studio (SSMS)

SSMS is the primary GUI for running queries, designing tables, and managing jobs. It is a separate download from the engine.

1. Download SSMS from Microsoft (SSMS 21+ pairs with SQL Server 2022).
2. Run the installer — defaults are fine.
3. Launch SSMS and connect:
   • Server name: localhost or localhost\INSTANCENAME
   • Authentication: Windows Authentication (or SQL if mixed mode)

You should see system databases (master, model, msdb, tempdb) in Object Explorer.

7. Verify the installation

Open a New Query window and run:

SELECT @@VERSION AS SqlVersion;

SELECT name, state_desc, recovery_model_desc
FROM sys.databases
ORDER BY name;

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

Expected: Edition shows Developer Edition (64-bit) and ProductVersion starts with 16. (SQL Server 2022).

Create a test database to confirm write access:

CREATE DATABASE DevTest;
GO
USE DevTest;
CREATE TABLE dbo.Hello (Id INT PRIMARY KEY, Message NVARCHAR(100));
INSERT INTO dbo.Hello VALUES (1, N'SQL Server 2022 is ready');
SELECT * FROM dbo.Hello;

8. Named instances vs default instance

Named instances use dynamic ports by default. For remote connections, enable TCP/IP in SQL Server Configuration Manager and open the port in Windows Firewall.

9. Troubleshooting

• Cannot connect to localhost — open Services (services.msc) and confirm SQL Server (INSTANCENAME) is Running. Restart the service after setup.
• Login failed for user — verify mixed mode is enabled if using SQL auth; reset sa via SSMS security settings.
• Setup failed / pending reboot — reboot Windows and re-run setup; check C:\Program Files\Microsoft SQL Server\*\Setup Bootstrap\Log.
• Port conflicts — use a named instance or change the port in Configuration Manager.
• Low disk during install — free space on the drive holding Program Files and the data directory.

10. Next steps

Your environment is ready. Continue the SQL Server tutorial series:

1. SQL Server Introduction — components and editions overview
2. SQL Server Architecture — engine, storage, and memory
3. T-SQL Tutorial for Beginners — first queries in SSMS

Bookmark this page when rebuilding lab VMs or onboarding teammates to SQL Server development.