Install SQL Server 2019 Express Edition and SSMS Step-by-Step

Photo by Caspar Camille Rubin on Unsplash

Install SQL Server 2019 Express Edition

• SQL Server Downloads | Microsoft

Step1:

Choose Custom type when entering the installation wizard.

choose where your SQL Location on

Step2:

After the installation wizard download the SQL Server 2019, you will enter SQL Server Installation Center. Click the first one “New SQL Server stand-alone installation…”

choose the first one

Step3:

In this step, you need to choose the features to install in your SQL Server.

• Database Engine Services
• SQL Server Replication [Optional]
• Full-Text and Semantic Extractions for Search [Optional]
• Client Tools Connectivity [Optional, if you need client-server architecture in your organization]
• Client Tools Backwards Compatibility [Optional]
• Client Tools SDK [Optional]
• SQL Client Connectivity SDK [Optional]

after set some information up, you will see the “Feature Selection”

choose your instance and name its id

Step4:

In Server Configuration, choose “Startup Type” of all services to Automatic if you can.

There are 3 types in Startup Type:

• Disabled: The service is installed but not currently running.
• Manual: The service is installed, but starts only when another service or application needs its functionality.
• Automatic: The service is automatically started by the operating system.

Step5:

Set your SQL Server admins with Windows Authentication mode. Configure your setting in TempDB, Memory, etc. in this page if needed.

Step6:

After few minutes, the installation of SQL Server instance will be completed.

Install SQL Server Management Studio (SSMS)

Step1:

Click “Install SQL Server Management Tools” in SQL Server Installation Center (You might find it in Start)

It will link to the page, which can download SSMS tools from website.

the page that link from SSMS button in SQL Server Installation Center

*If your environment can’t connect to the Internet, you may download SSMS in advanced and install in your isolated environment.

Step2:

Get SSMS-Setup-ENU.exe file and click it to install SSMS with Azure Data Studio.

Click install and waiting few minutes for installing the packages

Step3:

SSMS Setup Completed! Pretty easy right? 🤓

Try Azure Data Studio to connect to your SQL instance right now!

Reference

• SQL Server installation guide — SQL Server | Microsoft Learn
• Download SQL Server Management Studio (SSMS) — SQL Server Management Studio (SSMS) | Microsoft Learn
• SSMS components and configuration” — SQL Server Management Studio (SSMS) | Microsoft Learn
• Connect and query a SQL Server instance using SQL Server Management Studio (SSMS) — SQL Server Management Studio (SSMS) | Microsoft Learn

Follow me, Clap and Comment for this post if you like it or have any questions for the post.