...
palCentre also requires that your SQL Server is configured to allow SQL Logins (as opposed to Windows Authentication). Mixed mode authentication will also work, but palCentre uses SQL Logins to connect to the server.
Creating and configuring the
...
palCentre Database
palCentre has a built-in database configuration wizard for creating and configuring the palCentre database in order to streamline the installation process. The installation package also includes the SQL Scripts for creating the database, SQL Server logins, tables and structural table data which you can modify and run manually if you prefer.
...
palCentre stores connection information for client machines in a local settings file. This file stores the database server name, SQL Login names, SQL Logins passwords and the encryption key. The security-critical items in this file (SQL passwords and the encryption key itself) are encrypted with a constant encryption key. This means that people with access to the file system on client machines will not have access to SQL Login passwords or the ‘identifiable data encryption key’.
Installing and Configuring
...
palCentre
Installation of palCentre is intended to be simple and safe. The built in database configuration wizard can create and configure the SQL database and logins for you with a bare minimum of customisable data entry. Once the database configuration wizard has been run once, the client configuration wizard can be run to connect a client machine to the palCentre database. Alternatively, the configuration wizards create a configuration file which can be deployed to client machines, eliminating the need for running the client configuration wizard.
...