How to install Microsoft SQL Server 2019 Express Edition for HRPro

1. Download and Install Microsoft SQL Server 2019 Express Edition

https://www.microsoft.com/en-us/sql-server/sql-server-downloads

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)

https://docs.microsoft.com/en-us/sql/ssms/download-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)

- C:\Program Files\Microsoft SQL Server\MSSQL15.SQL2019\MSSQL\Binn\SQLServr.exe
- C:\Program Files\Microsoft SQL Server\90\Shared\SQLBrowser.exe

External Reference:

Opening Windows Firewall for client connections to server🡕