Installing SQL Server 2019 Express

  1. Download the SQL Server 2019 Express installer by clicking this link. The installer will automatically begin to download. (The installer file is approximately 280 megabytes and may take a few moments to download).

  2. Follow the steps in your web browser to open the installation file.  If prompted, allow the application to run:

  1. Click Custom from the installation type scree.
  2. Specify the SQL Server media download target location (C:\SQL2019 is the default and fine to proceed with) and let the process run through downloading the media:

SQL Installation type screen

  1. Click New SQL Server stand-alone installation or add features to an existing installation:

 

  1. Proceed through, accepting the license terms and selecting to perform a new installation of SQL Server 2019 if prompted...

 

 

  1. Click Next once the SQL installer has completed the Install Riles and checks. The SQL installer will check for product updates and automatically download any additional files needed.

  1. Verify the Instance Features and Shared Features options are selected (Database Engine Services, SQL Server Replication & Client Connectivity SDL) as per the screenshot below as a minimum and click Next.

 

  1. Select Named Instance and enter a name. We recommend the Instance ID is set to IRISPRACTICE for clarity when referring to our other guidance and then click Next.

  1. Leave the default settings on the Server Configuration screen and click Next.

 

  1. Select the option for Mixed Mode (SQL Server authentication and Windows authentication). Enter a password for your database instance and Confirm password. Please, write down your password and keep it somewhere important. Then, click Next.


SQL Server 2019 will now be installed.

  1. If you are notified that a computer restart is required, click OK.

  1. SQL Server 2019 is now installed. Click Close on the Completion screen.
  2. Go back to the SQL Server Installation Center and select the options to Install SQL Server Management Tools or go to:

    https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15


  1. Download the file   and click to run it on your PC.
  2. When prompted, click Install.


Once finished it displayed a Setup Completed message. SQL and SSMS are now successfully installed.