How to install MSSQL Express on Windows Server 2019

Introduction

In this tutorial, we’re going to explain how to how to install MSSQL Express on Windows Server 2019. Microsoft SQL Server Express is the free version. MSSQL is a database management system developed by Microsoft. It supports T-SQL which is a dialect of SQL. In general, it’s mostly used by organizations with small to medium databases.

Prerequisites

  • VPS, Pure performance VPS, or Dedicated Server.
  • You must be logged in via Remote Desktop Protocol as an administrative user.

Step 1: Log in with RDP into Windows Server 2019

Connect to your server with the login credentials which you can find in your client area.

Step 2: MSSQL Express Installation

Go to https://www.microsoft.com/nl-nl/sql-server/sql-server-downloads. Scroll down to the Express version. Click Download nu to start the download.

MSSQL websiteMSSQL website

When the download is done, click on it to run it. You can do that by going to your File Explorer and click on Downloads.

Windows Server Download folderWindows Server Download folder

Click Yes to allow this app to make changes to your device.

MSSQL Download permissionMSSQL Download permission

Then this window will open. You can choose what installation you want. In this case, we’re choosing Basic

MSSQL basic downloadMSSQL basic download

The custom version will look like this:

MSSQL custom versionMSSQL custom version

You can read the Microsoft SQL Server License Terms. Then click Accept.

MSSQL download termsMSSQL download terms

Locate where you want MSSQL to be installed. Then click Install.

MSSQL install locationMSSQL install location

The installation will now begin.

MSSQL installationMSSQL installation

When the installation is done, click Install SSMS.

MSSQL download doneMSSQL download done

Step 3: Install SQL Server Management Studio

A new website will open. Scroll down to Download SSMS. Then click on Download SQL Server Management Studio (SSMS).

MSSQL download ssmsMSSQL download ssms

SQL Server Management Studio will start to download. When it’s done click on it to run it.

SSMS InstallationSSMS Installation

Click Yes to allow this app to make changes to your device.

SSMS installation permissionSSMS installation permission

You can change the location here. Then click Install.

SSMS installationSSMS installation

Now SQL Server Management Studio will start to download.

SSMS installingSSMS installing

When it’s done downloading, click Restart to restart your computer. This is required to complete the setup.

SSMS restart pcSSMS restart pc

After restarting your computer, Microsoft SQL Server Management Studio is successfully installed. You can open it by searching for SSMS at the magnifier.

MSSQL Successful downloadMSSQL Successful download

MSSQLMSSQL

Conclusion

Congratulations, you now know how to install MSSQL Express on Windows Server 2019