We can install SQL express server 2019 on windows 2016 /2019 r2. You can download it from the Microsoft website. Lets’ see, how to install SQL server 2019 on windows server.
You can install it using the below method or you can simply download the ISO image then start the installation directly.
How To Install SQL Express Server On Windows 2012 / 2016 R2:
You can download any version you want to install it on the windows server in 2016 r2. I have downloaded the Express version.
Once you have downloaded SQL Server 2019 the package file. Now “double click” on it and select “run“.
You can select the “Installation type” here and I have selected the “Basic“. you can also download the media file and use the ISO image to install later.
We need to accept the terms and conditions.
You can change the installation path here and I have kept it as default.
It will start downloading the package from the official site of Microsoft.
Once the installation completed.
Install SQL Server Management Studio(SSMS:
Now you have to click on “SSMS” and it will take you to the Microsoft download page where you have to download and install it.
Double Click on the setup and click on “Run“. you will see the below screen and start the installation.
The installation has been begun. it will take to install it.
Once the installation finished. This will ask you to restart the machine.
Now you have to open the SQL Server Management Studio and you will see the window like below.
I have not set any password while installing because I have chosen the default configuration. you can simply “Connect” it with the “Windows Authentication“.