SQL Server Installation

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 get the Microsoft SQL Server license terms, where you have to click on the Accept option to proceed further with the installation process.

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

Step 4: After that, you will see another download successful screen. (For reference you can see the below image)

Step 5: Now, you will see the successful message for the SQL Server installation, that the Installation has been completed successfully.

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

Wish to get certified in SQL? Learn SQL from top SQL experts and excel in your career with Intellipaat’s SQL certification.

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.

Preparing for the SQL interviews? Check out these SQL Server Interview Questions.

Installation of SSMS

Step 1: After that click on the below software as mentioned:

Type in the Search box of your windows→  SQL Server 2019 Installation.

Click on the file that is shown below.

Step 2: 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 3: Now click on Developer_ENU

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

Step 5: Now, let the operation be completed. Don’t worry about the warning.

Then click on Next.

Step 6: Next, take reference from the below image and then click on Next.

Step 7: Next, you can refer to the below image and then click on Next.

Step 8: Then click on the ‘I accept Agreement’ dialog box and then click on the Next Button.

Step 9: Next, take reference from the below image and then click on Next.

Step 10: 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 11: 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 12: Click on the Mixed mode option.

Step 13: Now, you need to enter a password.

Let’s give the Password: 1234

Confirm Password: 1234

Then click on Add Current User

Now, you will able to see Specify SQL Server administrators.

Click on Next.

Step 14: Then click on Install.

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

Step 15: Wait until the installation process is completed.

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

Now we will install 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 18.

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 Connect option.

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

Step 8: Default login: sa password: 1234

Drop any of your queries in our SQL Server Community and start a discussion.