How To Install SQL Server On Windows

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications – Wikipedia.

Objective

• Learn how to install SQL by wizard in Windows Server

Download SQL Server

Step 1 : Download SQL Server installer

You may find SQL Server installer files via Microsoft in this link.

Step 2 : Choose SQL Edition

You may choose Developer edition to get full-featured, however, you cannot publish it for production purposes. For this lab, we are going to use Express Edition.

SQL Server Installation using GUI

Step 1 : Run SQL Server Installer

Open the downloaded .exe file.

Step 2 : Select Installation type

For this lab tutorial, we will proceed with Basic.

Step 3 : Accept license term

Open the downloaded .exe file.

Step 4 : Verify Install Location

You may proceed to click to Install on the default directory. Otherwise, change the install location by clicking to Browse button.

Step 5 : Verify Installation Progress

You may see it will download all the packages first. After the download is finished, it will automatically proceed to installation. Wait until it finishes.

Step 6 : Installation Complete

SQL Server installation is now complete. Please note that SQL Administrator is listed on the screen. You may need it to access the SQL server in the future.
• Customize: Configure advanced SQL setup
• Install SSMS: Proceed to install GUI tool to manage SQL Server and DB
• Connect Now: Connect to SQL Server via command line windows

Other SQL Installation method

There are also few other methods to install SQL Server aside from using GUI which are:
• Installation from Command Line
• Installation using Configuration File
• Installation by using SysPrep
• Installation by using PowerShell Desired State Configuration

Resources

• https://www.datacamp.com/community/tutorials/how-to-install-sql-server
• https://www.guru99.com/download-install-sql-server.html
• https://www.sqlshack.com/step-by-step-installation-of-sql-server-2017/
• https://www.sqlservertutorial.net/install-sql-server/
• https://www.dnnsoftware.com/docs/developers/setup/set-up-sql.html
• https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server?view=sql-server-ver15
• https://docs.microsoft.com/en-us/sql/database-engine/install-windows/install-sql-server-on-server-core?view=sql-server-ver15

Muadz
Muadz

Hey guys. I'm a Private Cloud Analyst mainly focused on hosting solution which involves hybrid multi-cloud supporting enterprise system.

Cheers, have a good day!

Articles: 4