Steps to install Microsoft SQL Server on Windows 10

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 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 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 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 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 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 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 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 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 17

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

Steps 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 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 23

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

Steps 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 27

Next, click Install to start the installation.

Steps 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 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 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 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 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 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

May be interested

  • How to install Active Directory on Windows Server 2019How to install Active Directory on Windows Server 2019
    one of the best features that makes windows server shine in the enterprise arena is the active directory. this single sign-on tool integrates seamlessly and easily with most microsoft products making managing users pretty easy and enjoyable.
  • Install Windows Server Backup on Windows Server 2008 R2Install Windows Server Backup on Windows Server 2008 R2
    windows server backup is a component built into windows server 2008 r2, including snap-in microsoft management console (mmc), a command line tool and windows powershell cmdlets.
  • Install Windows Server 2003 and create a backup serverInstall Windows Server 2003 and create a backup server
    network management documentation server 2003 as details of how to install, create a companion server in case the main server is malfunctioning, create a domain, join the client to the domain, the conection {remote desktop from the client data to server}, set adsl router parameters to server, turn off 1 working machine immediately.
  • 10 reasons to install Windows Server 200810 reasons to install Windows Server 2008
    the new server operating system recently released by microsoft: windows server 2008 (windows longhorn) is it really the best, most effective and secure server operating system? the answer depends on the specific user but even though
  • How to install and configure WampServerHow to install and configure WampServer
    wampserver is a local server package for windows that allows you to install and host web applications using apache, php and mysql. this article will guide you the steps to install wampserver on your computer.
  • How to install the Print Server in Windows Server 2012How to install the Print Server in Windows Server 2012
    in today's article, we will see how to install the print server, which is very important for administrators and system management.
  • How to install Nextcloud server on Windows 10How to install Nextcloud server on Windows 10
    nextcloud is a perfect replacement for owncloud cloud storage software. it has both an open source community version and a paid business version.
  • Instructions for installing SQL Server 2019Instructions for installing SQL Server 2019
    on september 24, microsoft announced the release of sql server 2019 community technical preview (ctp) 2.0. it is very suitable for database professionals to keep up with modern technology.
  • Microsoft: Windows Server does not support ARMMicrosoft: Windows Server does not support ARM
    microsoft currently has no plans to develop a dedicated operating system version for the server running the arm architecture processor.
  • Install Role, configure role on Windows Server 2012Install Role, configure role on Windows Server 2012
    like previous versions, windows server 2012 has many associated roles. roles and features are tools you need to install or enable to complete your it administration tasks, if you don't install them, you can't do anything. in this article, we will learn how to install and configure the most important roles.