Installing SQL Server Express

installing-sql-server-express

Installing SQL Server Express

8th November 2021

IRIS Accountancy Suite

Require guidance on installing an SQL Server instance required for IRIS Accountancy Suite

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:

3. 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.

4. Click the top link, New SQL Server stand-alone installation or add features to an existing installation.

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

6. 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.

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

8. 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.

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

10. 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.

11. If notified that a computer restart is required, click OK.

12. SQL Server 2019 is installed, Click Close on the Completion screen .
    
13. Go back to the SQL Server Installation Center and select the option to Install SQL Server Management Tools or go to the following link to obtain the latest available version from Microsoft:
    
    https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15

14. Download the file   and click to run it on your PC.
    
15. When prompted, click the Install button:

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