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