How to properly install SQL Server?

How to properly install SQL Server?

SQL Server 2019 developer edition in Windows 10

In this tutorial, We will install the SQL Server 2019 developer edition in windows 10. This developer edition is a full-featured free edition, licensed to use in a non-production environment for development and test database. The installation step will be mostly same for the different versions (i.e, 2014, 2017 etc) and editions (i.e., Express, Standard, Enterprise etc).

Sql Server 2019 Developer Edition installation steps

  1. Go to SQL Server downloads page and click “ Download now ” under Developer edition or you can just directly click here . 00-ssms-installation-steps-by-rajanand.png
  2. Installer will be downloaded. Double click the installer to start the installation process.
  3. Click “Custom” as the installation type as shown below. 01-ssms-installation-steps-by-rajanand.png
  4. This will download the SQL Server software with size about 1.5GB 02-ssms-installation-steps-by-rajanand.png
  5. Click “Installation” as this is the first time we are going to install SQL Server. 03-ssms-installation-steps-by-rajanand.png
  6. Click the first option “New SQL Server stand-alone installation” 04-ssms-installation-steps-by-rajanand.png
  7. Leave the default option “Developer” edition. 05-ssms-installation-steps-by-rajanand.png
  8. Accept the license terms and privacy statements. 06-ssms-installation-steps-by-rajanand.png
  9. Check the Install rules. If there are any issue, read the error message and fix that. If there are no error messages, and just a warning message is there like below, then that is fine. 07-ssms-installation-steps-by-rajanand.png
  10. Select only the “Database engine service” in feature selection. 08-ssms-installation-steps-by-rajanand.png
  11. Leave the default SQL Server instance Id/name. (i.e., MSSQLSERVER) and click Next. 09-ssms-installation-steps-by-rajanand.png
  12. Click Next on the service accounts configuration page.
  13. In Database engine configuration select Mixed mode (SQL Server authentication and Windows authentication) as authentication. By using this mixed mode, you will be able to login to the SQL Server instance with your current windows login and with username and password. Enter any strong password that you can remember for SQL Server authentication method.
    User name: sa
    Password: AnyPasswordThatYouDontForget
    Then click “Add current user” to add the currently logged-in user as administrator. 11-ssms-installation-steps-by-rajanand.png
  14. Review it once and then click “Install”. This step will take some time to complete. 12-ssms-installation-steps-by-rajanand.png
  15. Installation process may take from 15 to 30 min to complete. 13-ssms-installation-steps-by-rajanand.png
  16. Once installation completes, you should see the message like below. Then you can close it. 15-ssms-installation-steps-by-rajanand.png

Now, you may open SQL Server Management Studio and login to the server.

Did you find this article valuable?

Support Rajanand Ilangovan by becoming a sponsor. Any amount is appreciated!