How to install Microsoft SQL Server 2017 Express Edition for HRPro

1. Download and Install Microsoft SQL Server 2017 Express Edition

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

On Server Configuration page, Security Mode, select Mixed Mode Authentication and provide 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 2017 - Make TCP/IP Enabled

3. Restart SQL Server

4. Add Firewall Exception for these 2 programs

    • C:\Program Files\Microsoft SQL Server\MSSQL14.SQL2017\MSSQL\Binn\SQLServr.exe
    • C:\Program Files\Microsoft SQL Server\90\Shared\SQLBrowser.exe