Step-by-Step Guide: Installing SQL Server 2022 Developer Edition and Connecting with SSMS


Introduction

If you're starting your SQL Server journey, one of the first challenges is installing SQL Server correctly and connecting to it using SQL Server Management Studio (SSMS).

In this guide, I'll walk through the complete installation process of:

  • SQL Server 2022 Developer Edition
  • SQL Server Integration Services (SSIS)
  • SQL Server Management Studio (SSMS)

By the end of this tutorial, you'll have a fully functional SQL Server environment ready for database development, ETL, migrations, and learning.

Prerequisites

Before you begin, ensure:

  • Windows 10/11
  • Administrator access
  • Internet connection
  • At least 10 GB free disk space

Step 1: Launch SQL Server Installation Center

After mounting the SQL Server ISO or launching the installer, open:

SQL Server Installation Center

Navigate to:

Installation → New SQL Server stand-alone installation


Step 2: Select Developer Edition

Choose:

Developer Edition

Why Developer Edition?

  • Free for learning and development
  • Includes Enterprise-level features
  • No database size limitations
  • Best choice for students and professionals

Step 3: Accept License Terms

Accept the license agreement and continue.


(Insert License Terms screenshot)


Step 4: Global Rules Validation

SQL Server verifies:

  • Operating system compatibility
  • .NET Framework
  • Existing SQL Server installations
  • Firewall checks

A firewall warning is normal for local installations.


Step 5: Azure Extension Screen

For local installations:

Do not configure Azure Extension

Simply continue.

Step 6: Feature Selection

Select the following features:`

Required

✅ Database Engine Services

Recommended

✅ SQL Server Replication

✅ Integration Services (SSIS)

These features are useful for:

  • Database administration
  • Data migration
  • ETL development
  • XML and Oracle migrations

Step 7: Instance Configuration

Choose:

Default Instance

Instance Name:

MSSQLSERVER

This is ideal for a first SQL Server installation.

Step 8: Server Configuration

Keep the default settings:

ServiceStartup Type
SQL Server Database EngineAutomatic
SQL Server Integration ServicesAutomatic
SQL Server AgentManual
SQL Server BrowserDisabled

Enable:

✅ Grant Perform Volume Maintenance Tasks

This improves database performance.


(Insert Server Configuration screenshot)

Step 9: Database Engine Configuration

Select:

Mixed Mode Authentication

This enables:

  • Windows Authentication
  • SQL Server Authentication

Create a strong password for:

sa

Click:

Add Current User

This ensures your Windows account becomes a SQL Administrator.

Step 10: Ready to Install

Review the configuration summary.

Click:

Install




Step 11: Installation Progress

The installation may take several minutes.

Do not cancel or close the installer.



Step 12: Verify SQL Server Services

Open:

services.msc

Verify:

✅ SQL Server (MSSQLSERVER)

✅ SQL Server Integration Services 16.0

Status should be:

Running

Step 13: Install SQL Server Management Studio (SSMS)

Open:

Install SQL Server Management Studio

Download and install SSMS.

(Insert SSMS download screenshot)

Step 14: Launch SSMS

Open:

SQL Server Management Studio

First launch may take a few moments.

Step 15: Connect to SQL Server

Use:

Server Type

Database Engine

Server Name

localhost

Authentication

Windows Authentication

Click:

Connect

Step 16: Create a Sample Database

Right-click:

Databases

Choose:

New Database

Database Name:

sourcetestdb

Step 17: Create a Sample Table

Open:

New Query

Execute:

USE sourcetestdb;
GO

CREATE TABLE Employee
(
    ID INT PRIMARY KEY,
    Name VARCHAR(100),
    Department VARCHAR(50)
);

INSERT INTO Employee VALUES (1,'Raja','IT');
INSERT INTO Employee VALUES (2,'John','HR');

SELECT * FROM Employee;

Expected Output:

IDNameDepartment
1RajaIT
2JohnHR



Installation Complete

Congratulations! 🎉

You now have:

✅ SQL Server 2022 Developer Edition

✅ SQL Server Agent

✅ SQL Server Integration Services (SSIS)

✅ SQL Server Management Studio (SSMS)

✅ Sample Database

✅ Sample Table

What's Next?

Now that SQL Server is installed, you can explore:

  • SQL Query Development
  • Stored Procedures
  • Views
  • Indexes
  • XML Import
  • SSIS Packages
  • Oracle to SQL Server Migration
  • Data Warehousing
  • ETL Development

Key Takeaway

The most important configuration during installation is choosing Mixed Mode Authentication and adding yourself as a SQL Server Administrator. Missing these steps is one of the most common causes of login issues later.

If you're learning SQL Server, start with the Developer Edition—it provides the full feature set without licensing costs for development and learning purposes.



Comments

Post a Comment