Steps to install Microsoft SQL Server on Windows 10

Instructions on how to install Microsoft SQL Server on Windows 10, a database management system from Microsoft. Install SQL Server and SSMS is a GUI tool to support SQL Server manipulation

In this article, I will go with you to install SQL Server but it is a developer version, so that you can experience this database management system.

#first. Install SQL Server 2019

+ Step 1: First you download the installation file here.

+ Step 2: There will be two versions here:

  1. Developer for development environments.
  2. Test or Express is the version for the Production environment.

=> You can download the Developer version to install as shown below.

Steps to install Microsoft SQL Server on Windows 10 Picture 1Steps to install Microsoft SQL Server on Windows 10 Picture 1

+ Step 3: After the download is complete, run the installation file (double click on the file) to start the installation. There will be 3 options for you to choose from => here I will choose Custom (custom).

Steps to install Microsoft SQL Server on Windows 10 Picture 3Steps to install Microsoft SQL Server on Windows 10 Picture 3

Minimum hard drive space requirement is 8G (8994MB to be more precise)

By default, the application will be installed at C: SQL2019. You can change it by clicking Browse. as shown below.

=> Then you click Install to start the installation.

Steps to install Microsoft SQL Server on Windows 10 Picture 5Steps to install Microsoft SQL Server on Windows 10 Picture 5

+ Step 4: Now the installation packages will be downloaded to your computer via the Internet. The download process may take 3-5 minutes depending on the network speed.

Please note to keep an Internet connection during the installation process.

Steps to install Microsoft SQL Server on Windows 10 Picture 7Steps to install Microsoft SQL Server on Windows 10 Picture 7

+ Step 5: At the beginning of the installation, select the Installation tab as shown below.

Steps to install Microsoft SQL Server on Windows 10 Picture 9Steps to install Microsoft SQL Server on Windows 10 Picture 9

+ Step 6: Then select the first option as shown below: New SQL Server stand-alone installation.

Steps to install Microsoft SQL Server on Windows 10 Picture 11Steps to install Microsoft SQL Server on Windows 10 Picture 11

+ Step 7: Next will come to enter the Product Key, you can choose Specify a free edition => select Developer to not have to enter the key.

=> Then click Next to continue.

Steps to install Microsoft SQL Server on Windows 10 Picture 13Steps to install Microsoft SQL Server on Windows 10 Picture 13

+ Step 8: Continue to the step to confirm the installation terms, then check the button I accept the license… => then click Next to go to the next step.

Steps to install Microsoft SQL Server on Windows 10 Picture 15Steps to install Microsoft SQL Server on Windows 10 Picture 15

Continue to tick Use Microsoft Update to check for updates to update future updates.

Steps to install Microsoft SQL Server on Windows 10 Picture 17Steps to install Microsoft SQL Server on Windows 10 Picture 17

In this step, you click Next to go to the next step.

Steps to install Microsoft SQL Server on Windows 10 Picture 19Steps to install Microsoft SQL Server on Windows 10 Picture 19

+ Step 9: In this step you will choose the features, if you are new to learning how to use SQL server, you can check the Database Engine Service => then click Next.

Steps to install Microsoft SQL Server on Windows 10 Picture 21Steps to install Microsoft SQL Server on Windows 10 Picture 21

+ Step 10: Go to the first configuration step, then choose as shown below => then click Next for yourself.

Steps to install Microsoft SQL Server on Windows 10 Picture 23Steps to install Microsoft SQL Server on Windows 10 Picture 23

Configure the server, you leave the default and then click Next.

Steps to install Microsoft SQL Server on Windows 10 Picture 25Steps to install Microsoft SQL Server on Windows 10 Picture 25

With the Database configuration step, you should note the options like the image below. Enter a password (please note that you must remember this password).

=> Then add admin rights => and click Next to continue.

Steps to install Microsoft SQL Server on Windows 10 Picture 27Steps to install Microsoft SQL Server on Windows 10 Picture 27

Next, click Install to start the installation.

Steps to install Microsoft SQL Server on Windows 10 Picture 29Steps to install Microsoft SQL Server on Windows 10 Picture 29

+ Step 11: The installation process is not too long, after successful installation, there will be a Complete message as shown below. Ok, that's the end of the SQL Server installation step.

Steps to install Microsoft SQL Server on Windows 10 Picture 31Steps to install Microsoft SQL Server on Windows 10 Picture 31

#2. How to install SQL Server Management Studio

For those of you who don't know, SQL Server Management Studio (SSMS) is an interface tool that makes working with SQL Server easier.

+ Step 1: First you download the installation file here.

Steps to install Microsoft SQL Server on Windows 10 Picture 33Steps to install Microsoft SQL Server on Windows 10 Picture 33

+ Step 2: After the download is complete, double-click on the downloaded file to install it. By default the tool will be installed at:

C:Program Files (x86)Microsoft SQL Server Management Studio 18.

=> You can change or keep the default like me => then click Install to install.

Steps to install Microsoft SQL Server on Windows 10 Picture 35Steps to install Microsoft SQL Server on Windows 10 Picture 35

The installation process takes about 1-2 minutes, so you should keep an Internet connection.

Steps to install Microsoft SQL Server on Windows 10 Picture 37Steps to install Microsoft SQL Server on Windows 10 Picture 37

+ Step 3: Ok, and this is the result after successful installation. So now you can use SQL Server through SSMS.

Steps to install Microsoft SQL Server on Windows 10 Picture 39Steps to install Microsoft SQL Server on Windows 10 Picture 39

#3. Epilogue

Yes, so in this article, I have successfully installed SQL Server with you and SSMS is a GUI tool that supports manipulating SQL Server. SQL Server is considered one of the most stable database management systems because it is backed by Microsoft.

Hope this article will be useful to you. See you in the next posts!

4.2 ★ | 11 Vote