Kiến Thức Linux

How to Install SQL Server on Windows 10

How to install Microsoft SQL Server

Introduction

SQL server is a relational database management solution offered by Microsoft. It can be installed on-premise or in the cloud and is primarily used to store and retrieve data it receives from other applications.

This tutorial outlines the step-by-step process of installing Microsoft SQL Server on Windows 10. We will also show you how to install the Microsoft SQL Server Management Studio.

How to install Microsoft SQL Server

Prerequisites

  • A system running Windows 10
  • Access to an account with administrator-level privileges

Install and Configure SQL Server on Windows

Follow the steps below to install Microsoft SQL Server 2019:

Note: If you’re looking for a more lightweight version of SQL Server, check out our guide to installing SQL Express Server.

1. Download the setup file from the SQL Server downloads page. Scroll down until you find the Developer edition and click the Download now button.

Download the SQL Server install file from the Microsoft website

Once the download is complete, open the setup file to start the installation process.

2. Click the middle tile to select the Custom installation type.

Select the custom installation type

3. Choose where to store the downloaded installation media files and click Install to continue.

Choose a location for the downloaded media files.

Once the download is complete, the setup window automatically closes and is replaced by the SQL Server Installation Center window. Here, start the wizard to install SQL Server 2019.

4. Select the Installation category on the left-hand side of the SQL Server Installation Center window and click the New SQL Server link to start the installation wizard.

Launch the install wizard to start the SQL Server setup

5. The wizard automatically checks for available updates. If there are no updates ready to install, click Next to proceed.

Apply any available updates before proceeding

6. The install wizard checks for any errors that might cause problems during the setup process. If it detects any failures, fix them before clicking Next to continue.

Fix any errors that might interfere with the installation

7. Choose an installation type. If you are installing SQL Server for the first time, select the Perform a new installation of SQL Server 2019 option and click Next to continue.

Select the installation type

8. Choose the version of SQL Server you want to install and enter a product key if you have one, then click Next to proceed. For this example, we are installing the free Developer version.

Select the version of SQL Server you want to install

9. Check the I accept the license terms and Privacy Statement box and click Next to continue.

Accept the license terms before proceeding

10. Select the features you want to install. For this example, we are using the Database Engine Services option. Click Next to proceed.

Select the software features you want to install

11. Enter a name and instance ID for the new SQL server and click Next to continue.

Enter a name for the new SQL server

Note: Once you enter the server name using the Named instance option, the wizard automatically fills in the instance ID field.

12. Set up the service accounts and collation configuration, then click Next to continue. For this example, we are using the default settings.

Set up the service accounts and collation configuration

13. In the Server Configuration tab, select the Mixed Mode method of authentication. Select a user for the role of SQL server administrator and set up a password for their account. Click Next to proceed.

Set up the server admin username and password

14. The final step offers a summary of the installation. Click Back to return to any of the previous steps and change the installation settings or click Install to start the setup process.

Review the setup summary before proceeding

15. Once the setup is complete, the status of setup operations should read Succeeded. Click Close to exit the install wizard.

Close the wizard once the setup is complete

Install Microsoft SQL Server Management Studio

Microsoft SQL Management Studio (SSMS) allows you to design, query, and manage databases using SQL Server. Follow the steps outline below to install it on your system:

1. Download the install file from the SQL Server Management Studio download page. Scroll down and click the link to download SSMS 18.9.1. Open the install file to start the setup.

Download the SQL Server Management Studio installation file

2. Choose an install location and click Install to continue.

Choose an install location for SQL Server Management Studio and start the setup process

3. Once the installation process is complete, click Close to exit the setup.

Microsoft SQL Server Management Studio installed successfully message

Conclusion

After reading this tutorial, you should have Microsoft SQL Server and SQL Server Management Studio installed and ready to use. Next, work on creating a database!

If you want to find out more about SQL installation on other operating systems, make sure to read our articles how to install SQL server on Linux andhow to install SQL server on MacOS.

Đăng ký liền tay Nhận Ngay Bài Mới

Subscribe ngay

Cám ơn bạn đã đăng ký !

Lỗi đăng ký !

Add Comment

Click here to post a comment

Đăng ký liền tay
Nhận Ngay Bài Mới

Subscribe ngay

Cám ơn bạn đã đăng ký !

Lỗi đăng ký !