SQL Server installation


SQL Server installation guide

This article will explain how to install the SQL Server 2019 Developer Edition and SQL Server Management Studio (SSMS) step by step.

Install SQL Server 2019 Developer Edition in windows

Before starting installation process we need to Download SQL Server 2019.

You can download SQL Server 2019 from this link -> Download the SQL Server here:

While downloading Download the SQL Server the Microsoft will provide you with some SQL Server editions options. You can select as per your requirements, like for learning purposes, you can use the Developer edition of SQL Server.

When download is complete, then we are ready to start process for SQL Server installation. Now double-click the downloaded installer ( .exe ) file,  this will start installation process and will launch the downloader.

1. Choose Download Media option, when downloader ask you to select the installation type. Download Media option will first download the setup files and then start SQL Server installation.

SQL server installation step-1

SQL Server installation – Choose Download Media option

2. Now specify the location of the folder for storing installation files, and then click Download button

SQL Server installation - Specify the location and download

SQL Server installation – Specify the location and download

3. Now downloader will start downloading installation files. It may take a while to complete the download depending upon your internet connection speed.

SQL Server installation - Downloading installation files

SQL Server installation – Downloading installation files

4. After completion of download, open this downloaded folder and right-click the iso file found inside this folder and mount the iso file

SQL Server installation - download complete

SQL Server installation – download complete

SQL Server installation – Right click and mount ISO

SQL Server installation – Right click and mount ISO

6. Now browse to this mounted ISO file and open the installation folder and locate setup.exe file , double click this setup.exe file to launch the installer

SQL Server installation - Double click setup.exe file to launch installer

SQL Server installation – Double click setup.exe file to launch installer

Installation of SQL Server 2019 developer edition

1. After launch of installer, you’ll see a window as shown below –

Then select installation option from left pane

SQL Server installation - Select the installation option

SQL Server installation – Select the installation option

2. Now select ‘New SQL Server standalone installation or add features to existing installation’, and it will launch SQL Server installation wizard to install SQL Server 2019

SQL Server installation - Select new SQL Server standalone installation or add features to existing installation

SQL Server installation – Select new SQL Server standalone installation or add features to existing installation

3. Now specify the edition which you want to install, if you are using it for learning purposes, Select Developer edition, and then click on the Next button.

SQL Server installation - Select Developer edition

SQL Server installation – Select Developer edition

4. Accept the license terms and click on the Next button

SQL Server installation - Accept the license terms

SQL Server installation – Accept the license terms

5. Now check if you want to get updates for SQL Server and if you don’t want to get these updated then uncheck the boc which says “Use Microsoft Update to check for updates (recommended)” and then click on the Next button

SQL Server installation- check if you want to get updates for SQL Server

SQL Server installation- check if you want to get updates for SQL Server

6. Now the installation process will check for the prerequisites and if all is good then, click on the Next button

SQL Server installation - check for the prerequisites

SQL Server installation – check for the prerequisites

7. Now select features that you want to include in installation, like if you are doing this SQL installation for learning purposes, then you may need the Database Engine Services, so select it and click on the Next button to continue installation process.

SQL Server installation - Select features that you want to include in installation

SQL Server installation – Select features that you want to include in installation

8. Now type the instance ID of SQL Server and click on the Next button

SQL Server installation - Type the instance ID of SQL Server

SQL Server installation – Type the instance ID of SQL Server

9. Now in Database Engine Configuration select the Mixed Mode, Type the password which you want for system administration account, You will need this password to connect to the SQL Server later on. Now click on the Add Current User to specify the SQL Server Administrators, and then click on the Next button.

SQL Server installation - System administration account setup

SQL Server installation – System administration account setup

10. Now finally verify the features of SQL Server 2019 to be installed and once verified and found okay then click on Install button. Now installation of SQL Server with selected features will start.

SQL Server installation - Verify the features of SQL Server 2019 to be installed

SQL Server installation – Verify the features of SQL Server 2019 to be installed

11. You will be able to see the success message when installation completes. Now click on the Close button and with this the installation of SQL Server is complete.

SQL Server installation - Success message when installation completes

SQL Server installation – Success message when installation completes

Install Microsoft SQL Server Management Studio in windows

We need a SQL Server client tool to interact with SQL Server. For this Microsoft provides SQL Server Management Studio (SSMS). SQL Server Management Studio is software used to interact with SQL Server and querying, designing, and managing SQL Server in the cloud or on your local computer.

SQL Server Management Studio provides you tools to monitor, configure, and administer SQL Server.

For installation of SQL Server Management Studio (SSMS), we need to download it from Microsoft website using below link:

After downloading the installation file, double-click this installation file named as SSMS-Setup-ENU.exe , this will launch the installer of SQL Server Management Studio.

The installation process of SMSS is not that much complicated and it is easy to follow.

1. After double-clicking the installation file ( SSMS-Setup-ENU.exe ) installation window will open. Check the installation location, if you are not sure about it then leave it as it is and click the Install button

installation process of SMSS

installation process of SMSS

2. Now the installation process will start, wait for some time while the installer sets up the software.

Installation process of SMSS started

Installation process of SMSS started

3. Now when installation is completed you will see a success message, then click on the Close button and with this the installation of SQL Server Management Studio is complete.

Installation of SMSS is completed

Installation of SMSS is completed

Finally you have both SQL Server 2019 and SQL Server Management Studio installed on your computer.

Blog Author Yogiraj Avatar

Author: Yogiraj

Raj is a Top Rated full stack web developer and is a very good technical writer. He is a veteran of Digital Marketing and Web development and having expertise in WordPress, Codeigniter, Core PHP Applications, Mysql and excellent in debugging the codes. Being a veteran in web development Raj has extensive knowledge of various technical aspects of web development, which he always shares in his blogs so that others can be benefited from his experience.

Share on: Share YogiRaj B.Ed Study Notes on twitter Share YogiRaj B.Ed Study Notes on facebook Share YogiRaj B.Ed Study Notes on WhatsApp
Hosts file windows 10
Hosts file windows 10

What is Hosts file ?
Hosts file is an systems file of a operating system that maps hostnames to IP addresses. It is a plain text file.
Purpose of Hosts file – The hosts file assists in addressing network nodes in a computer network.

Read full article
How to change localhost to domain name in xampp
How to change localhost to domain name in xampp

Change localhost to domain name in xampp
Let us change localhost to custom domain name in XAMPP server step by step – 
Step 1. Amend hosts file in windows
Open the hosts file located in folder at C:\Windows\System32\drivers\etc and right click hosts file and select edit “as Administrator”

Read full article
Supervised study and home assignment
Supervised study and home assignment

A Method of Teaching is a process of planning, guiding, sharing and evaluating learning with a group of students. It is a procedure the teacher follows to make learning easy and effective.

Read full article
Regional method of teaching geography
Regional method of teaching geography

A Method of Teaching is a process of planning, guiding, sharing and evaluating learning with a group of students. It is a procedure the teacher follows to make learning easy and effective. It concentrates on the various regions of the world.

Read full article

Some important study notes