AWR Installation with New Database

Owned by Erick Meijer
Mar 27, 2023
5 min read

Step 1

On the workstation where Web Recruitment has never been installed, the Database settings page appears:

Now, proceed with the following steps:

  1. Enter the SQL server address, user credentials with corresponding permissions and choose to Create new database.

  2. Check the connection to the database by clicking the Test DB connection button. If the database server name and credentials are correct, the Test OK message appears.

  3. Click Next to proceed.

Enter the SQL Server name as it is displayed in the SQL Server. Entering an IP address instead of the SQL server name may cause a failure while connecting to the database.

 

Step 2

On the next step, you will see the Create New Database dialog:

In the dialog, proceed with the following steps:

  1. Enter a new database name and a password for the AD_UPGRADE login

  2. Enter the AWR login name and password. The password must be strong.

  3. Click Next to proceed.

Please consider the following important information:

  • If the AD_UPGRADE login already exists on the SQL Server where the database of Web Recruitment is created or used, the Web Recruitment installer uses the AD_UPGRADE login and will not create a new one. So, before the installation, it is necessary to check whether AD_UPGRADE already exists on the SQL Server.

  • If the AD_UPGRADE login does not exist on the target SQL Server, Web Recruitment will create it. Enter a strong password which must contain uppercase and lowercase characters, digits and special characters. It may be critical if the Password must meet complexity requirements security policy setting is enabled on your workstation. In this case, the Setup Wizard will not create the AD_UPGRADE login in the database and will display an error message which interrupts the installation process.

 

Step 3

 Now, you can create the default users for Adonis Web Recruitment. They are:

  • apm is a user with a manager role who will work with applicants and process their applications

  • adm is a user with an administrator role who will add vacancies, edit content, etc.

Within the dialog, proceed with the following steps:

  1. Enter the passwords for both administrator and manager users.

  2. Click Next to proceed.

 

Step 4

To define general settings, it is necessary to enter PIN numbers and the path to an output folder. Successful applicants will be registered in Adonis Personnel Manager and identified by PINs (personal identifier numbers). You can define the range of PINs to be used for registering applicants:

The PIN start value must be greater that the PIN end value.

PIN is required to be unique. Avoid entering the PIN range which may include already existing PINs. Otherwise the system will prevent Adonis Web Recruitment from adding the records of a new employee to the database.

The Output folder is a folder shared to internet users. The folder is intended for uploading files which may be imported or processed by Adonis Web Recruitment. If you want to change the path by default, click Browse and specify the desired directory.

You can install several instances of Adonis Web Recruitment by providing different installation names. By default, the Installation name is set to Adonis Web Recruitment. If you attempt to install a second instance and skip defining a new name, the system prompts you:

 

Step 5

On this stage, you can set up a mail client. For this, it's necessary to configure an SMTP server that will take care of the email delivery:

Enter the settings for the SMTP server:

  1. The SMTP server address and its port.

  2. Autoreply Sender email that will be shown as a sender for a recipient.

  3. Contact e-mail to allow users to reply to any emails sent to them.

  4. Requires authentication (optional). Enable the option to make sure the connection is secure. Enter a username and password.

Once completed, click Next to proceed.

 

Step 6

 In order to enable the possibility to send SMS messages, select the Enable SMS option:

In the dialog, proceed with the following steps:

  1. Enter an SMS login, SMS password and SMS Sender name.

  2. Click Next to proceed.

 

Step 7

Set up the website in Internet Information Services (IIS):

When finished, click Next to proceed.

 

Step 8

Select the destination folder for the Adonis Web Recruitment installation:

Confirm the default destination folder for the application or select a different folder using the Browse… button. Initiate the installation process by clicking the Install button.

 

Step 9

You will see the installation in progress:

During the installation process, the application needs to create a set of tables. For this, in the Adonis Script Executor dialog, click the Execute button:

On the Database Login dialog, enter the AD_UPGRADE password and click OK to confirm.

The script executor will proceed with changes to the database. After it completes, click Exit in the Adonis Script Executor dialog. The installation continues and proceeds to finish:

Click Finish to exit the setup wizard.