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