How to install Microsoft SQL Server 2019 Express Edition for HRPro

1. Download and Install Microsoft SQL Server 2019 Express Edition

On Server Configuration page, Security Mode, select Mixed Mode Authentication and provide a password for the built-in SQL Server system administrator account (sa).

2. Download and Install SQL Server Management Studio (SSMS)

If you wish to allow network access

1. Open SQL Server Configuration Manager

2. SQL Server Network Configuration, Protocols for SQL Server 2019 - Make TCP/IP Enabled

3. Restart SQL Server

4. Add Firewall Exceptions for these 2 programs (If the Internet Information Server and SQL Server are installed inside the same Windows, Firewall Exceptions may not be required to be created)