How to Download and Install SQL Server 2019

By FoxLearn 6/26/2024 8:26:20 AM   3.09K
How to Download and Install Microsoft SQL Server 2019, SQL Server Management Studio (SSMS) on Windows 10.

SQL Server is a relational database management system. It makes it easy to organize and manage data, and moreover it supports multiple users...etc.

SQL Server operates in a client-server, so there will be 2 components: Workstation and Server.

- Workstation is installed on any device. It provides tools to help you interact with the Server, eg SSMS, SSCM, Profiler, BIDS or SQLEM ...

- Server is installed on centralized server. It is services such as SQL Server, SQL Server Agent, SSIS, SSAS, SSRS, SQL Browser, SQL Full Text Search ...

First, You need to download Microsoft SQL Server 2019 to your computer: Link

download sql server 2019

Clicking Download media button to download sql server to your computer. You will receive an iso file once the download is complete.

Next, You need to mount the iso file, then run the setup.exe

install sql server 2019

Clicking on Installation link

install sql 2019

Next, Select New SQL Server stand-alone installation or add features to an existing installation

install server 2019

You can select developer or express edition to install, if you have a product key, you can enter at the textbox, then click Next button.

install server 2019

Ticking "I accept the license terms and privacy statement", then click Next button.

install server 2019

Clicking Next button.

install server 2019

Clicking "Select All", then click Next button.

install server 2019

Entering your SQL Instance name, then click Next button.

install server 2019

Clicking Next button.

install server 2019

Clicking Next button.

install server 2019

Clicking "Add Current User", then click Next button.

install server 2019

Clicking "Add Current User", then click Next button.

install server 2019

Clicking Next button.

install server 2019

Clicking "Add Current User", then click Next button.

install server 2019

Clicking Next button.

install server 2019

Clicking "Accept" button, then click Next button.

install server 2019

Clicking "Accept" button, then click Next button

install server 2019

Clicking Install button.

install server 2019

Clicking Next button.

If you want to download SQL Server Management Studio (SSMS), you can download at: Link

This tool helps you to connect to SQL Server, and you can easily interact with the database.

VIDEO TUTORIAL