MS SQL Server Installation | Intellipaat

Process Advisors

ey-logo
*Subject to Terms and Condition

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

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-

  • Installation of 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.

Installation of Microsoft SQL Server

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.

Step 4: 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 4

Step 5: 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 5

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

Step 6

Get 100% Hike!

Master Most in Demand Skills Now !

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

Step 7

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

Step 8

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.

  • Installation of SSMS

After the installation of the SQL Server gets successfully completed, on the same screen you will get an option for the installation of 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.

Installation of SSMS Step 2

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

You can take a reference from the below screenshot.

Installation of SSMS Step 3

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

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

Click on the file that is shown below.

Installation of SSMS Step 4

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.

Installation of SSMS Step 5

Step 6: Now click on Developer_ENU

Installation of SSMS Step 6

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

Installation of SSMS Step 7

Step 8: Now, let the operation get completed. Don’t worry about the warning.

Then click on Next.

Installation of SSMS Step 8

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

Installation of SSMS Step 9

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

Installation of SSMS Step 10

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

Installation of SSMS Step 11

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

Installation of SSMS Step 12

Step 13: 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.

Installation of SSMS Step 13

Step 14: Now, don’t do any changes on the next page, you can take reference from the below image.

Click on Next.

Installation of SSMS Step 14

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

your screen

Step 15: Click on the Mixed mode option.

Installation step 15

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

Let, 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.

Installation step 16

Step 17: Then click on Install.

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

Installation step 17

Step 18: Wait until the installation process gets completed.

Installation step 18

Step 19: As now, you will see the process got completed, now click on the Close option.

Installation step 19

  • Now we will install the SSMS Setup file:

Step 1: Click on Install.

SSMS Setup file Step 1

Step 2: Please wait until the screen loads.

SSMS Setup file Step 2

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.

SSMS Setup file Step 3

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.

SSMS Setup file Step 4

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

SSMS Setup file Step 5

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

SSMS Setup file Step 6

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

SSMS Setup file Step 7

Step 8: Default login: sa password: 1234

SSMS Setup file Step 8

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

Course Schedule

Name Date Details
SQL Training 07 Oct 2023(Sat-Sun) Weekend Batch
View Details
SQL Training 14 Oct 2023(Sat-Sun) Weekend Batch
View Details
SQL Training 21 Oct 2023(Sat-Sun) Weekend Batch
View Details

Leave a Reply

Your email address will not be published. Required fields are marked *