SQL Server 2019 installation and basic configuration (the simplest in history!!!)

Time:2022-5-3
  1. downloadSQL Server 2019 Developer

    SQL Server 2019 installation and basic configuration (the simplest in history!!!)

    Click download now.

  2. Double click Start

    SQL Server 2019 installation and basic configuration (the simplest in history!!!)

  3. choicebasicInstallation type
    SQL Server 2019 installation and basic configuration (the simplest in history!!!)

  4. Select the appropriate installation path and click InstallSQL Server 2019 installation and basic configuration (the simplest in history!!!)

  5. Long wait to enter

    SQL Server 2019 installation and basic configuration (the simplest in history!!!)

  6. Save the screenshot of the information in the figure below (do not close this interface first), and click Install SSMS to start installing SSMS.

    SQL Server 2019 installation and basic configuration (the simplest in history!!!)

  7. Click to download SSMS
    SQL Server 2019 installation and basic configuration (the simplest in history!!!)

  8. Select the appropriate path to start the installation
    SQL Server 2019 installation and basic configuration (the simplest in history!!!)
    Then there is a long wait (don’t tell me you’re fast, maybe your computer performance is too good)

  9. Click restart to restart the computer (some computers do not need to be restarted, but my computer does anyway)
    SQL Server 2019 installation and basic configuration (the simplest in history!!!)

  10. After restarting, you can see these things in the windows start menu and the installation is over.
    SQL Server 2019 installation and basic configuration (the simplest in history!!!)

  11. Now start testing and using SQL server

  12. Select SQL Server 2019 configuration manager from the start menu
    SQL Server 2019 installation and basic configuration (the simplest in history!!!)

  13. Click SQL server network configuration → MSSqlServer protocol → enable TCP / IP protocol.
    SQL Server 2019 installation and basic configuration (the simplest in history!!!)

  14. Start Microsoft SQL Server Management Studio 18

    SQL Server 2019 installation and basic configuration (the simplest in history!!!)

  15. Click direct connection
    SQL Server 2019 installation and basic configuration (the simplest in history!!!)

  16. The following figure shows that the connection is successful.

    SQL Server 2019 installation and basic configuration (the simplest in history!!!)

  17. Let’s start with some basic configurations

  18. Select Properties

    SQL Server 2019 installation and basic configuration (the simplest in history!!!)

  19. Click Security → check SQL server and windows authentication mode → click OK

    SQL Server 2019 installation and basic configuration (the simplest in history!!!)

  20. The information in the figure below appears. Click OK to restart SQL server

    SQL Server 2019 installation and basic configuration (the simplest in history!!!)

  21. Open our SQL Server 2019 configuration manager again, select SQL Server service → click SQL Server → right-click restart

    SQL Server 2019 installation and basic configuration (the simplest in history!!!)

  22. Go back to Microsoft SQL Server Management Studio 18 and click Security → login → SA (SA is the system default)

    SQL Server 2019 installation and basic configuration (the simplest in history!!!)

  23. Click status → login name → enable check → OK
    SQL Server 2019 installation and basic configuration (the simplest in history!!!)

  24. Close Microsoft SQL Server Management Studio 18 and reopen it. Select SQL server authentication. The login name is SA and the password is the one just modified.
    SQL Server 2019 installation and basic configuration (the simplest in history!!!)

  25. As shown in the figure below, this installation and basic configuration is over
    SQL Server 2019 installation and basic configuration (the simplest in history!!!)