In this article, we shall discuss “How to Download and install MSSQL 2019 Express Edition and SSMS on Windows Server”. SQL Server 2019 Express is a free edition of SQL Server, ideal for the development and production of desktop, web, and small server applications. Please see How to use Microsoft SQL Server Management Studio to Export and Import your MsSQL database from Azure to local computer.
If you wish to try out the 180 days free trial of SQL Server 2019 on-premises which helps build intelligent, mission-critical applications using a scalable, hybrid data platform for demanding workloads. SQL Server 2019 makes data integration, management and intelligence easier and more intuitive than ever before.
You may also want to download the SQL Server 2019 Developer version (Microsoft SQL Server 2019 and Microsoft SQL Server Management Studio which is a full-featured free edition, licensed for use as a development and test database in a non-production environment. See this article for the differences between various Editions of MsSQL Server.
Part 1: Download Microsoft SQL Server 2019 Express Edition
Use this Microsoft SQL Server 2019 Express Edition. Double click on “SQLServer2019-SSEI-Expr.exe” as shown below.
Installation of MSSQL
The window below will appear with three options: Basic, Custom, and Download files. I will select Basic as this variant is straightforward, In this installation type, the SQL server is set up with the default values.
Note: The points are vital to determine your installation type.
If you choose Custom, the program downloads the installation files and then opens the actual setup of SQL Server, where you can select the various options and components with the help of a wizard.
See this guide on how to perform the installation with the custom installation type but for Developer edition. You can compare the installation and tell what to expect at the end if you decide to go for the custom installation method.
Using the Download installation media will be preferred if the database server has no access to the Internet. It can be downloaded to a workstation and then transferred to the target system.
This will prompt the Microsoft SQL Server License Term window with a dialogue box prompting you to confirm the UI language. For me English is okay, so I will click on Yes.
Please see How to install Microsoft SQL Server Management Studio, and how to install and configure Veeam Backup and Replication 11.
Accept the License Terms
Next, click on Accept in order to accept the license terms! Ensure you read before accepting 🙂
The SQL server install location dialog box will appear. Since this is a test lab, I will leave the default location as shown C:\Program Files\Microsoft SQL Server.
Note: You can also change the installation location by clicking on the Browse button as shown below. Once your desired location is selected, click on the Install button.
This will run through and download the install packages and extract the setup files as shown below
Now the download is complete; the installation of SQL Server 2019 Express Edition is initiated as shown below.
The basic installation of SWL Server 2019 Express Edition will take a few minutes, don’t fret!
Note: This is the difference between making a basic and custom installation as you do not have a choice of what is installed.
Once the installation is complete, the following window will be displayed as shown below.
The installation is completed successfully and you can close the window or connect to the Database as shown above.
But if you wish to modify your SQL server express edition, Click on Customise as shown above. This will display the SQL server 2019 Setup as shown below. Walk through the rules and make modifications as you desire.
I will cancel this operation as this is not what I want to do but I just to show you the various configuration options available for the SQL Server Express Edition Edition.
Connect to that SQL Server Express Edition
If you also wish to connect to that SQL Server Express Edition, simply click on “Connect Now”.
You will be prompted with the Command Line Interface for administering the server as shown below.
Here are some interesting contents relating to MSSQL
- Steps to install Microsoft SQL Server 2019 and MsSQL Command line tools on Ubuntu Linux
- Ways to uninstall Microsoft SQL Server on Windows 10 and Windows Server.
- Ways to use a dedicated MsSQL Db for Pleasant Password on Windows Server.
- Steps on how to migrate Veeam MsSQL Database to a new MsSQL Server.
- How to uninstall Microsoft SQL Server Management Studio on Windows 10 and Windows Server
Part 2: Install Microsoft SQL Server Management Studio (SSMS)
SQL Server Management Studio is a software application first launched with Microsoft SQL Server 2005.
It (SSMS) is used for configuring, managing, and administering all components within Microsoft SQL Server.
Click on the install SSMS as shown below. You will be prompted to download the Microsoft SQL Server Management Studio. You can download the SSMS tool from here.
Now that the SSMS-Setup-ENU file has been downloaded, double-click to launch it.
This will open up the Microsoft SQL Server Management Studio (SSMS) install window.
Note: By clicking on install, you agree to the license terms as shown below.
This will continue with the installation, you can sit back and watch as the installation progresses.
When the application completes you will be required to restart your server for setup can continue
Now the Microsoft SQL Server Management Studio setup is completed. Please see WID: How to delete ADFS Windows internal database without access credentials, and How to manually check and update SQL Server Management Studio.
You can launch the SSMS by clicking on the start button and Microsoft SQL Server Studio will be available on your recently added application as shown below.
Please you can pin this to the taskbar or to the start program as shown below.
After pining it to the taskbar, double-click on the Microsoft SQL Server Studio to open it up. Click on Connect.
Upon clicking on connect, you will now be granted access to the database as shown below.
I hope you found this blog post helpful on how to Download and install MSSQL 2019 Express Edition and SSMS on Windows Server. If you have any questions, please let me know in the comment session.
