HRPro Brief Installation Procedure

This article outlines the brief installation procedure for setting up HRPro, suitable for IT administrators who prefer to perform the installation themselves.

1. Install Microsoft SQL Server (Express or higher)

• If Microsoft SQL Server is already installed and configured for HRPro, you can skip this section.

• Before installing SQL Server, ensure Windows has all security updates and service packs applied via Windows Update.

• Download the appropriate Microsoft SQL Server Express with Tools installer from the Microsoft website that matches your Windows version (for example, ENU\x64\SQLEXPRWT_x64_ENU.exe for 64‑bit English Windows).

• Run the installer and follow the on‑screen instructions to complete setup.

• When prompted for Feature Selection, selecting Data Engine Services alone is sufficient to complete the HRPro installation.

• When prompted for authentication mode, choose Mixed Mode Authentication and assign a strong password to the sa (system administrator) account.

• For detailed SQL Server installation steps tailored for HRPro, see How to install Microsoft SQL Server Express Edition for HRPro.

2. Copy HRPro setup files to the server

• Copy all files and subfolders from your HRPro Setup Package to the new server.

• Use a simple local path such as C:\HRPro (or another preferred folder) to store the HRPro application files and sample data.

3. Restore HRPro databases in SQL Server

• Use SQL Server Management Studio (SSMS) to restore the HRPro databases.

• Start SSMS and connect to the SQL Server instance using an account with sufficient rights.

• In Object Explorer, right‑click Databases and select Restore Database….

• Restore the following two databases from the backup files in the Sample Database folder under C:\HRPro:

  • dbSystem – system database storing users, security groups, and access rights.

  • dbHRPro – application database containing the HRPro demo company data.

• Confirm that both databases are successfully restored and appear under the Databases node in SSMS.

4. Verify/enable SQL Server TCP/IP connections (required for remote access)

• If HRPro Client, Web Application Server, or Employee Portal will connect to SQL Server over the network, TCP/IP must be enabled.

• Open SQL Server Configuration Manager and enable the TCP/IP protocol for the SQL Server instance used by HRPro.

• If the SQL Server and IIS/Web Application Server are on different machines, add necessary firewall exceptions for SQL Server executables and ports.

• Restart the SQL Server service after making protocol changes.

• For step‑by‑step instructions, see How to enable TCP/IP connection for the SQL Server Express edition?

5. Confirm server‑side setup completion

• At this point, SQL Server and the HRPro databases are ready for use by HRPro clients and web components.

• Verify that you can connect to dbSystem and dbHRPro using SSMS with the chosen authentication mode.

• Keep the SQL Server instance name, authentication mode, and credentials available, as you will need them when configuring HRPro Client, Web Application Server, and Employee Portal.

6. Install HRPro Web Application Server

• For HRPro Web Client or Employee Self‑Service, you must install the web components on a supported Windows Server with IIS. Follow the HRPro Web Application Server Deployment on Windows Server for the deployment.

• These guides cover IIS configuration, application deployment, authentication, and connectivity to the HRPro databases.

7. Getting help and next steps

• If you require assistance during installation or encounter issues that you cannot resolve, you can contact your HRPro support representative or authorized service provider for on‑site or remote support services.

• This brief procedure covers the essential steps needed to prepare SQL Server and restore the HRPro databases, forming the foundation of a functional HRPro environment.