How to install MSSQL Express on Windows Server 2019

Estimated reading time: 1 min

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

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 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 folder

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

MSSQL Download permission

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

MSSQL basic download

The custom version will look like this:

MSSQL custom version

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

MSSQL download terms

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

MSSQL install location

The installation will now begin.

MSSQL installation

When the installation is done, click Install SSMS.

MSSQL 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 ssms

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

SSMS Installation

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

SSMS installation permission

You can change the location here. Then click Install.

SSMS installation

Now SQL Server Management Studio will start to download.

SSMS installing

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

SSMS 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 download

MSSQL

Conclusion

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

Was this article helpful?
Dislike 1
Views: 12678

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *