HRPro Brief Installation Procedure

Here is the brief installation procedure for HRPro, suitable for IT users who wish to install it themselves:

1. Install Microsoft SQL Server Express Edition (skip if already installed):

   • Before installing, apply all security updates and service packs from Windows Update.

   • Download the appropriate Microsoft SQL Server Express with Tools from the Microsoft website based on your Windows version (e.g., ENU\x64\SQLEXPRWT_x64_ENU.exe for 64-bit English Windows).

   • Follow the on-screen instructions to complete the setup.

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

   • For SQL Server installation instructions tailored for HRPro, refer to specific guides if needed. How to install Microsoft SQL Server Express Edition for HRPro

2. Copy HRPro Setup Files:

   • Copy all files, including sub-folders, from your HRPro Setup Package to your new server, for example, to C:\HRPro or another preferred location.

3. Restore Databases on SQL Server:

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

   • Log in, right-click on Databases, and select Restore Database.

   • Restore two databases:

     1. dbSystem (system database holding user, group security, and access rights).

     2. dbHRPro (application database for the HRPro demo company).

   • The backup files are located in the Sample Database folder within the C:\HRPro.

4. Configure SQL Server for TCP/IP Connections:

   • Enable TCP/IP protocol in SQL Server Configuration Manager.

   • Add firewall exceptions for SQL Server executables if necessary (especially if IIS and SQL Server are on different machines).

   • Restart the SQL Server service after enabling TCP/IP.

   • See How to enable TCP/IP connection for the SQL Server Express edition?

5. Server Setup Completion:

   • At this stage, SQL Server and the databases are ready for HRPro.

6. Install Employee Portal and Web Application Server (optional, for web client setup):

   • Follow HRPro Web Application Server Deployment (for Web Client) on Windows Server

   • HRPro Employee Portal Installation Procedure on Windows Server

For further assistance, HRPro also offers on-site support services. Contact your HRPro support representative or authorized service provider for more details or if you encounter any issues.

This procedure covers the essential steps for setting up HRPro and its database backend, ensuring proper configuration of SQL Server and database restoration for a functional HRPro environment.