Support‎ > ‎

How to install Microsoft SQL Server 2016 Express Edition for HRPro

1. Download and Install Microsoft SQL Server 2016 Express Edition
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)

If you wish to allow network access
1. Open SQL Server Configuration Manager
2. SQL Server Network Configuration, Protocols for SQL Server 2016 - Make TCP/IP Enabled
3. Restart SQL Server
4. Add Firewall Exception for these 2 programs
  •  C:\Program Files\Microsoft SQL Server\MSSQL13.SQL2016\MSSQL\Binn\SQLServr.exe
  •  C:\Program Files\Microsoft SQL Server\90\Shared\SQLBrowser.exe

See also