Hey There, I am Dane!

 

Today I am going to show you exactly how to install SQL Server on your Windows 10 operating system.

 

In this step-by-step plan, I’ll cover the following:

 

1) Download the Original SQL Server Setup On Your System safely
2) Installation and Configuration Of SQL Server On Windows

Part 1 : Download the Original SQL Server Setup On Your System

STEP 1: In order to download a genuine Microsoft SQL Server setup, you need to visit Microsoft’s official SQL Server download page for this setup. Below is the link to the official webpage. 

Visit : https://www.microsoft.com/en-us/sql-server/sql-server-downloads

STEP 2: Now scroll down a bit and you will find the Developer Edition option somewhere in the middle of the page. ( See below screenshot for reference )

Download the developer edition from Microsoft Official Website

STEP 3 : Click on the download now button and let your SQL Server setup file download. You can find the downloaded setup file in the download sections of your computer.

STEP 4 : Now, you need to right click on the downloaded setup file and select “Run as administrator” from the given options.

Step 4 :
Step 4 : Right-Click and Run as Administrator

Part 2: Installation and Configuration Of SQL Server On Windows

Step 5 : In the next popup where windows asks for permissions to install the SQL Server Express. Click on the “Yes” button to proceed. ( See below screenshot for reference)

Step 5

Step 6 : After giving the permission to proceed, A window with 3 different installation types will appear. You need to select the “Custom” option out of these 3 installation types. ( This type allows us to choose custom settings based on our requirements )

Step 6

STEP 7 : Now select the folder where you want to install all the media files related to SSMS. ( See the below screenshot for reference )

Step 7

Step 8 :  Once you click on the install button, a new windows will open up. This window is the installation center for the SSMS. You need to click on the “Installation” present in the left side bar.
Then you need to move your cursor to the right side and click on the “New SQL Server stand-alone installation or add features to an existing installation”

Step 8 : Click on the “New SQL Server stand-alone installation or add features to an existing installation”

Step 9 :  The next window will appear after you click the new installation section. This window is the “Microsoft Update” window. If you want to continue the installation of SSMS, you need to tick the checkbox to check for any new updates.

Step 9 : Microsoft Updates Check

Step 10 : Now, the “Installation Center” will look for updates and will install accordingly. Meanwhile, you can get your coffee or tea..

Step 10 : Installation center looking for updates

Step 11 : Once the updates are completed, the next window with “Install rules” will appear. In this window, you need to make sure all the rules are “passed”.
You can’t have a successful installation if there is any type of error or failure in this step.
If any error occurs, you must figure out the root cause of the issue and fix it.
The errors that might appear in this are completely dependent on your system settings.

 

For Example:

On my system, I was facing a port-related issue that I fixed before proceeding to the next step.

If you’re not able to solve these issues on your own, You can reach out to me or create a post in our Facebook community for guidance from other helpful developers.

Once all errors are resolved, click next.

 

Step 12 : In this step, A dialog box will appear that will contain the installation type. As it’s a new installation, You must select option 1 here—”Perform a new installation of SQL Server.” 

And proceed to the next step by clicking the “next” button!

Step 12 : Perform a New Type Of Installation

Step 13 : In this step, A dialog box that contains product key section will appear. You should select the FREE option— “specify a free edition.” And click the “next” button.

In case If you have a licensed key, you need to select the second option and enter the licensed key.

Step 13 : Select The FREE option in SQL Server 2019 Setup

Step 14 :  This step is all about accepting the license, terms of the agreement, and privacy statement setup by Microsoft. You can go through it and tick the checkbox only if you agree with these terms and conditions.

In case, If you disagree with the Microsoft terms, you have a choice not to select the checkbox and cancel the installation.

To keep the installation going, I agreed to the terms and clicked next, and proceeded with the installation.

Step 14

Step 15 : The next window will appear with “feature selection” options.

Basically, here you will have various options and features that you can install in your SQL Server Management studio. Some of these features are — database engine services, Machine learning services, Python, R, etc.

You can choose the feature based on your choice and requirements. I went ahead to use SSMS because I mostly to work on databases. That’s why the option— “Database engine services” is the correct choice for me.

After making the choice, click on the “Next” button to continue.

Step 15 : Selecting the features of your choice

Step 16 : In this step of the process, you need to set up the instance configuration.

You will see 2 options in this window— default instance and Instance ID.

I entered the value SQL_SERVER “Manually” for the instance name and instance ID field. 

After completing that, just click on the “Next” button to proceed to the next step

Step 16 : Insert the Instance Name Manually

Step 17 : The next window is about setting up the server configuration. I chose the default setting for this, and I recommend you choose the “default settings” only.

Then click the “next” button to proceed to the next step.

Step 17 : Setting Up Server Configuration

Step 18 : At this point, Installation will reach the database engine configuration section of this process. 

At this stage, the authentication mode that you have to select is “mixed mode.”

Then you need to enter the password you want to use for the authentication.

Then you need to click on the “Add current user” button. This action will make you the administrator of the SSMS.

Then click the “Next” button to proceed further.

Step 19 : At this stage of the process, most things are configured, and the installation center will present you with a quick summary in the “ready to install” section.
Click on the “install” button to proceed!

Step 19 : SQL server is ready to install

Step 20 : Wait until the installation is successfully completed.

Step 21 : For the 2nd part of the installation process, you need to install the Microsoft SQL Server Management Studio.

This management studio allows us to view, design, and manage databases.

To do that, you need to visit the Microsoft official website and download a genuine setup for the management studio.

https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

Scroll down a bit and find the “Download SSMS”. (See the below screenshot for reference )

Then click on the “Download SQL Server Management Studio” link to download the setup.

Step 22 : Locate the SSMS setup file in the downloaded section in your windows and then “Right-click” and install it with “administrator” rights.

Step 23 : After Allowing access to the installation setup. You need to locate the folder location where you want to install the files and click on the “install” button.

Step 24 : Once Setup is successfully completed, You should start the SQL Server to test if everything is executing perfectly or not.

 In my case, I faced an issue. My SQL server was not able to open a connection.

But the steps mentioned on this stack overflow thread helped me out with this.

Below is the link to the fix:

https://stackoverflow.com/questions/9945409/how-do-i-fix-the-error-named-pipes-provider-error-40-could-not-open-a-connec

© All Rights Reserved | DATACEPS 2024