Previous page

Next page

Create a New PayGlobal SQL Database - Outcome

Outcomes

After you have created a SQL database in PayGlobal, the following results are produced:

  • A single database is created. This database is owned by the SQL login sa. This is normal SQL Server best practice, as this login cannot be dropped.
  • All objects within the database are owned by DBO.
  • The new database and path is written to the HR.ini file.
  • A PG.udl file is created in the perm folder. This contains provider and connection information and should be used for troubleshooting.
  • A SQL.DAT file is created which stores the encrypted password of the PayGlobal application role - Pgapprole.

See also

SQL Database in PayGlobal

SQL Database After Installing PayGlobal