SQL Express 2019 Manual Install

SQL Express 2019 Manual Install

Manually Install SQL Express 2019

1.0 Introduction

There may be a scenario where SQL Express 2019 must be manually installed on the host PC. The installation file can be downloaded from the Microsoft website. At the time of writing, the correct URL is as follows:




2.0 Download the SQL Express 2019 installation file

  1. Click the file which has downloaded to the host PC.
  2. Typically the file will be found in the 'Downloads' folder.



  3. Wait for the installer to initialize.
  4. Select CUSTOM as the installation type.



  5. Accept the default download location for the SQL Express installation media (the default location is:  C:\SQL2019 ).
  6. Click the INSTALL button and the installation package will be downloaded.



  7. The installation center window will appear.
  8. Select the first option 'New SQL Server stand-alone installation or add features to an existing installation'.



  9. Place a check mark to accept the license terms and conditions.
  10. Click the NEXT button.
  11. Place a check mark to use Microsoft Update to check for updates.
  12. Click the NEXT button.
  13. The installer will now check for updates.
  14. Next, ensure the ECLIPSE instance is detected and displayed. The current version will most likely be 13.x.xxxx.x.



  15. The installer then gives you the option to check for updates to the Windows operating system. Keri systems recommends that you do check for updates before proceeding. So place a check in the check-box and click the NEXT button.
  16. The installer will check for updates, it will download setup files and then extract the setup files.



  17. Select to perform a new installation of SQL Server 2019. Click NEXT.



  18. Accept the Microsoft license terms. Click NEXT.
  19. The Features Select page displays a summary of all the features that will be installed (to support the SQL Server). The default selections would be fine for a new standard installation. Click NEXT again.



  20. In the Named Instance field, enter the instance name as 'ECLIPSE'.
  21. The INSTANCE ID will also change to match the instance name.



  22. On the next page, select the default option of installing OPEN JRE java file. Click NEXT.
  23. The server configuration screen is next, all options can be left at the default selections. Click NEXT.



  24. Set the authentication mode to MIXED MODE.
  25. Enter the 'sa administrator' password as 'dhs$e700'.
  26. Enter dhs$e700 a second time to confirm the password. All lowercase characters. Click NEXT.



  27. Click the ACCEPT button to consent to install the Microsoft R Open component.
  28. Click NEXT.
  29. Click the ACCEPT button to consent to install Python.
  30. Click NEXT.
  31. SQL Server Express 2019 will now install on the host PC.



  32. It should take no longer than 2-3 minutes for the installation to complete.



  33. Click the CLOSE button.
  34. SQL Server Express 2019 is now installed and ready to use.