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.
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 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 6: Now, you will see the installation package for SQL Server is getting loaded.
Step 7: After that, you will see another download successful screen. (For reference you can see the below image)
Step 8: 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 Server certification.
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.
Step 3: Now click on the download folder to open the downloaded file.
You can take a reference from the below screenshot.
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.
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: Now click on Developer_ENU
Step 7: On the next page, you will see a dialogue box. Accept that dialogue box and click on the Next option.
Step 8: Now, let the operation get completed. Don’t worry about the warning.
Then click on Next.
Step 9: Next, take reference from the below image and then click on Next.
Step 10: Next, you can refer to the below image and then click on Next.
Step 11: Then click on the ‘I accept Agreement’ dialog box and then click on the Next Button.
Step 12: Next, take reference from the below image and then click on Next.
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.
Step 14: Now, don’t do 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 15: Click on the Mixed mode option.
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.
Step 17: Then click on Install.
After that, it will load the screen and wait until it gets installed.
Step 18: Wait until the installation process gets completed.
Step 19: As now, you will see the process got 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 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.