SQL Server Installation

This guide is to walk you through the process of installing SQL Server, covering system requirements, setup configurations, and key installation steps. This tutorial, whether you’re a beginner or setting up a production environment, will ensure that you have a smooth and efficient installation experience.

Table of Contents

• MS SQL Server Installation Introduction
• Download Microsoft SQL Server
• Installing SQL Server
• Download SSMS
• Installing the SSMS Setup file

MS SQL Server Installation Introduction

This blog is intended to help you with MS SQL Server Installation on your operating system in simpler steps.

Pre-requisites:

Recommended Hardware Requirements:
Processor: 2.0 GHz or faster 64-bit processor.
Memory (RAM): At least 4 GB.
Hard Disk Space: 6 GB of free space.

Additional Considerations:

• Solid State Drive (SSD): Use SSDs for better I/O performance, especially for high-transaction databases.
• TempDB Configuration: Optimize TempDB configuration for performance. Consider placing TempDB on a separate drive.
• Network: A fast and reliable network connection is important, especially in distributed environments.

Watch this video on how to install SQL Server

We will be downloading the following software and will guide you step-by-step through the process:

• SQL Server
• SSMS(SQL Server Management Studio)

Let’s get started!

Download Microsoft SQL Server

Step 1: At first you need to go to the official site of Microsoft SQL Server and scroll down.

After you scroll down, you will see the Developer option which is a full-featured free edition, licensed for use as a development and test database.

Step 2: Now click on the ‘Download now’ option under Developer.

After downloading you will see this setup file in your downloads folder.

Step 3: After that click on setup and then install the software in your system.

Installing SQL Server

Step 1: Now the installation process of SQL Server gets started.

Now you have to select the installation type. There will be three types of installation types and you will have to select the Basic installation type for the installation of the SQL Server database engine which has the default configuration feature.

You can take reference from the below image:

Step 2: After that, you will be prompted to choose a location after this. Do not change the default download file location simply confirm and click ‘Install’. Make sure there is enough space in the default location.

Step 3: Now, you will see the installation package for SQL Server is getting loaded.

Step 4: The SQL Server Installation Center window will open automatically upon completion of installation and select Installation. (For reference you can see the below image)

Step 5:After that click on the Installation option, and you will see the below-given page on your screen. Next, click on the New SQL Server Stand-alone installation or add features to an existing installation option.

Step 6: Select Developer under  “Specify a free edition” and proceed to Select “Next”

Step 7: After that, you will get the Microsoft SQL Server license terms, where you have to click on the Accept option to proceed further with the installation process.

Step 8: On the next page, you will see a dialogue box. Accept that dialogue box and click on the Next option.

Step 9: Now, let the operation be completed. Don’t worry about the warning. Then click on Next.

Step 10: Uncheck “Azure Extension for SǪL  Server” and Click on “Next”.

Step 11: Select “Database Engine Services”, “SQL Server Replication” and “Machine Learning” feature under instance features. Select “Next” and Do not select any other features which may  require additional packages.

Step 12: Now you will have to fill in the Named Instance and InstanceID options and it should be the same name. After that click on Next.

Step 13: Now, don’t make any changes on the next page, you can take reference from the below image. Click on Next.

Now you will see the below-given page on your screen.

Step 14: Click on the Windows Authentication mode option.

Step 15: Then click on Install.

After that, it will load the screen and wait until it gets installed.

Step 16: As now, you will see the process has been completed, now click on the Close option.

Now, we will begin with the installation of SQL Server Management Studio(SSMS).

Download SSMS

After the installation of the SQL Server is successfully completed, on the same screen you will get an option for the downloading SSMS.

Step 1: Click on the install SSMS button, and then it will redirect you to the SSMS download link.

Step 2: After that scroll down and click on the first link available to download SSMS.

Take reference from the below image.

Step 3: Now click on the download folder to open the downloaded file.

You can take a reference from the below screenshot.

Installing the SSMS Setup file:

Step 1: Click on Install.

Step 2: Please wait until the screen loads.

Step 3: Now you will see the Setup Completed for Microsoft SQL Server Management Studio with Azure Data Studio.

Then click on the Close option.

After that, close all the applications which you have opened.

Step 4: Now you have to click in the search box of your windows.

Next, type SSMS in the search box.

After that, click on the first option: MSQL Server Studio 20.

Step 5: Now, let the Microsoft SQL Server Management Studio screen load.

Step 6: Now you will see the below-given screen, and you have to click on the Connect option.

Step 7: After connecting you can see the below screen.

Step 8: After that click on the NewQuery option, where you can write your Query.

Done with the SQL Installation and SSMS installation.