Summary

After installing PayGlobal, you must create a blank database for each company. Before you start, see Create a PayGlobal SQL Database - Install Wizard.

Create a new Company database

1. Click on the Windows Start button and select Run.
2. If you can currently see HR.exe in Windows Explorer, left-click and drag it to the Open field on the Run window. Alternatively if you know the HR.exe path, type it into the Open field.
3. When you have entered the path of HR.exe, type a space, then /initsql. For example:

   "C:\Program Files\PayGlobal\HR.exe" /initsql If the full path to the HR executable contains spaces you must enclose it in double quotes.

4. Click OK.

Fields in the Company Setup form

Company Name:

This is the existing Company name copied from the PayGlobal application: Administration | Modify Company Settings | General | Features | Secured Modules tab.

New serial numbers are generated according to the Company name and Client number. It is important to copy the Company name, Client number and Company serial number from the original Company settings to the corresponding fields in the Company Setup form. To copy these fields from Company Settings, use Ctrl+C to copy and Ctrl+V to paste into the corresponding field.

Path:

Enter the path of the HR.exe, (but do not include HR.exe in the path), followed by the new database name.

PayGlobal will create a folder for the new database, so you must ensure that a folder of the same name does not already exist in the entered path or you will receive an error message notifying you that it already exists.

When you Tab or click into the next field, the new folder is created in the specified path.

Serial Number:

Enter your PayGlobal serial number when creating a new PG database.

Database type:

Select 'SQL Server'.

Country:

Select the relevant country.

Server name:

This is the name of the SQL Server machine or DNS entry where the database files will be created and stored. If you are running HR.exe on the SQL Server machine you wish to create the database on and you are unsure of the Server name, leave the default of (local) in place of the actual machine name.

Database Name:

You should name the new database PayGlobal unless the name conflicts with an existing database on the server.

PayGlobal User:

By default a PGUser is created. This is the system user that PayGlobal will use to log into the SQL Server to access the PayGlobal database.

In order to create this user/login, the server must be set to use Mixed Mode Authentication. Where it is set to use NT Authentication remove the user name from the edit box.

The PGUser is used by the application to login to SQL Server. The PGUser user has very limited access to SQL Server and cannot access any of the data in PayGlobal, or any other database. Once logged on, the application uses an application role. The application role created in the database is 'PGApprole'. A strong password has been assigned to this role, which is encrypted and stored in the SQL.DAT file. There is no requirement for anyone to know this password.

The PGApprole application role is added to the following database roles:

• Db_backupoperator
• Db_datareader
• Db_datawriter
• Db_ddladmin

This provides the PayGlobal application enough database access to do everything it needs to and no more.

Secure existing database

Use the Secure existing database button to generate a new PayGlobal user for the existing SQL Server database. Details of how to connect to the database will be written to a new SQL.DAT file created in the perm sub-folder specified in the Path field.

Securing the PG database requires the user performing the secure to at least have 'db_owner' and the explicit permission to 'Alter any login'. Alternatively if the user has 'sysadmin' then they will be able to secure the database, but it is no longer required.

In MSSQL Server Management Studio, 'db_owner' can be granted to a user login via the User Mapping section. 'Alter any login' can be granted as an explicit permission under the Securables section.

Administrator login

Use the Administrator login button to check that the Login used for database configuration is valid. It checks this login has the appropriate sysadmin rights to create a new database and a login/user for the application.

Database file settings

By default Use defaults is tagged. Generally you should always accept this setting. The SQL Server Administrator can change these paths after installation in the database properties.

If you click to untag the Use defaults check box, the Data file and Log file fields will become active. This enables you to enter an alternative path for the Data file and Log file to be created. As exact pathing on the SQL Server is required. This option is recommended for experienced users only.

Approx no. of employees:

PayGlobal will calculate a recommended database size using the number of employees entered. The database size you specify impacts on the amount of physical hard drive, which is allocated to the database. This option is recommended for experienced users only.

See also

Create a SQL Database - Outcome

Create a SQL Database - Install Wizard