Introduction

Microsoft produces SQL Server Developer edition is a full-featured free edition, licensed for use as a development and test database in a non-production environment. We are going to install SQL Server 2019 Developer Edition on Windows Server 2019. It is provided for macOS, Ubuntu, SLES, RHEL and Windows operating systems.

Before we begin, head over to the Microsoft SQL Server Downloads page and download SQL Server 2019 Developer Edition.

Step 1: Run Installed Application

Navigate to the directory/folder where you downloaded the application then double-click it to start the installation process.

sql2019 1 donloaded file

Step 2: Select Custom Installation

After you have chosen the custom installation, click on “Install“. Allow the application to download and install packages.

You have the “Basic“, “Custom” and “Download Medium” installation types. I recommend you choose “Custom” to tweak your installation of SQL Server 2019 Developer Edition on Windows Server 2019.

sql2019 2 selectcustom

Specify a directory where SQL Server will store files downloaded for installation.

sql2019 3 chooseinstalltionplace 1

Be patient as the download begins, it may take some time.

sql2019 3 1 sqlinstalling

Step 3: Choose Installation

After all of the packages have downloaded, a new page as illustrated below will follow. Click on “Installation

sql2019 4 choose installation

Step 4: Choose New SQL Server standalone

After Step 3, choose the first option in the list and proceed to the next step. This is illustrated below.

sql2019 5 new sql standalone
sql2019 5 1 new sql standalone please wait

Step 5: Specify Edition

This step depends on whether you need “Developer“, “Evaluation” or “Express“. Their differences are described in the window. Since we are installing the “Developer” edition, let us proceed with that option. Click “Next

sql2019 5 2 chooseedition

Step 6: Accept License Terms

Select the “I accept the license terms and Privacy Statement” Radio and click on “Next“.

sql2019 6 Accept license terms

Step 7: Microsoft Update

You can either select the “Microsoft update” radio or not in this step then click “Next

sql2019 7 microsoft update

Step 8: Install Rules

Windows will check the system to find out any potential problems that can occur while the setup is running. If your firewall is running, you might see a warning sign for “Windows Firewall” which reminds you to open appropriate ports after installation is complete. Click “Next” after you are satisfied with the results of that page.

sql2019 8 install rules

Step 9: Feature Selection

In this step, you are presented with many features that SQL Server comes with. In case you would wish a certain feature to be included in your SQL instance, then this is the part that you choose their radio buttons. Go ahead and choose what you prefer to have. Click “Next” after you are done.

sql2019 9 feature selection

Step 10: Instance Configuration

Name your instance, in this step and click on “Next“.

sql2019 10 instance config

Step 11: Server Configuration

Specify the service accounts and collation configuration here. Click “Next” after that.

sql2019 11 server config

Step 12: Configure Database Engine Parameters

This step gives you the opportunity to choose authentication mechanisms you will use, setting a password for the administrator account and choosing other admin accounts.

I prefer mixed-mode authentication where a user can either be from a domain or added manually in the SQL instance. Choose the one that suits you best, enter the password and any other setting that you would wish to configure.

If you are keen, you will notice that there are other Tabs on this page. They are “Data Directories” where you can specify where you would wish your logs to reside, where your root directory will be, where you would wish to place your backup directory and database directory.

If you have different partitions in your server, you can place these directories in a smart way. Other tabs include “Memory“, “TempDB“, “MaxDOP“, and “FILESTREAM“. Look into them and set your customized settings therein.
Click on “Next” when you are done. Do not forget to add an admin user.

sql2019 12 configure database engine

Step 13: Analysis Services Configuration

Since I enabled analysis functionality, this is the step where I configure them. Choose an administrator and set the server mode that you prefer. Click on “Next“.

sql2019 13 analysis services config

Step 14: Accept Installation of Services

In case you had chosen specific packages to suit your needs in Step 9, you will be presented with installation guide and settings tailored for that specific service. For example, I had chosen Python and now I am being asked to consent its installation. After you are done with all of the prompts, click “Next” to proceed.

sql2019 14 accpet python installation

Step 15: Ready to Install

This step gives a summary of what we have been doing so far. The packages we have chosen to install, the settings we have configured and many more. Look at the list carefully. After you are satisfied with the summary, then gladly click on “Install

Wait as the server gets installed.

Step 16: Finish up

After everything has installed. Click on “Close“. Your SQL instance is installed and ready to be used.

Conclusion

Our SQL Server 2019 instance has been finally installed. What remains is to connect to it, create databases and take advantage of its resources. Next, we are going to look at how to connect to our SQL instance using SQL Server Management Studio. We shall install it and kick-off using our SQL resources. Thank you for hanging with us and for your continued support.

You might also be interested in:

How to install Microsoft SQL Server on RHEL / CentOS 8

How to install Microsoft SQL Server 2019 on CentOS 7 / Fedora

Install and Configure Hyper-V on Windows Server 2019

Install and Configure Windows Admin Center on Windows Server 2019/Windows 10

Linux vs Windows – Introduction for Newbies

How To Install MS SQL Server on Ubuntu 18.04/ Ubuntu 16.04 LTS

Linux vs Windows – Introduction for Newbies

How To Configure MS SQL Server to Listen on a given port

Your support is our everlasting motivation,
that cup of coffee is what keeps us going!


As we continue to grow, we would wish to reach and impact more people who visit and take advantage of the guides we have on our blog. This is a big task for us and we are so far extremely grateful for the kind people who have shown amazing support for our work over the time we have been online.

Thank You for your support as we work to give you the best of guides and articles. Click below to buy us a coffee.

2 COMMENTS

  1. Thank you Kibet. I went ahead with the custom installation using the minimum features and did not end up getting an instance of SQL server on my standalone system. I went ahead like a I Know It All (IKIA). There…I’ve introduced a new terminology starting with my goof up.

    Hope I could bring a smile to you after letting you know that your write-up has been very useful to me. Thanks a ton!

LEAVE A REPLY

Please enter your comment!
Please enter your name here