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.
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.
Click Yes to allow this app to make changes to your device.
Then this window will open. You can choose what installation you want. In this case, we’re choosing Basic
The custom version will look like this:
You can read the Microsoft SQL Server License Terms. Then click Accept.
Locate where you want MSSQL to be installed. Then click Install.
The installation will now begin.
When the installation is done, click Install SSMS.
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).
SQL Server Management Studio will start to download. When it’s done click on it to run it.
Click Yes to allow this app to make changes to your device.
You can change the location here. Then click Install.
Now SQL Server Management Studio will start to download.
When it’s done downloading, click Restart to restart your computer. This is required to complete the setup.
After restarting your computer, Microsoft SQL Server Management Studio is successfully installed. You can open it by searching for SSMS at the magnifier.
Conclusion
Congratulations, you now know how to install MSSQL Express on Windows Server 2019
Leave a Reply