Thank you for your feedback.

Was this useful?

Installing SQL Server Express

Article ID
installing-sql-server-express
Article Name
Installing SQL Server Express
Created Date
8th November 2021
Product
IRIS Accountancy Suite
Problem
Require guidance on installing SQL Server for IRIS Accountancy Suite
Resolution
  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 screen, 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 the top link, New SQL Server stand-alone installation or add features to an existing installation.
  1. Accept the license terms when prompted and click Next.
  1. Click Next once the SQL Installer has completed the Install Rules 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 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 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. Click ‘Add Current User’ to ensure the Windows login running the installer will also be an SQL Server administrator, then, click Next.


SQL Server 2019 will now be installed.

  1. If notified that a computer restart is required, click OK.
  1. SQL Server 2019 is 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://docs.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 the Install button:


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

Thank you for your feedback.

Was this useful?