Introduction > Installing Server Components for Version 6.X

For information on installing the Version 5 server components click here.

Overview

PDA Professional system setup for Version 6 is a manual process and involves using the SQL Server Management System to add the server users and attach the provided databases. This needs to happen before any of the clients can be installed. This installation is done on the server machine and is carried out by CPR Technologies installation personnel.

PDA Professional does not need an application server, but if dictated by your organizational policies, we can install server files on a server other than the server where SQL Server is hosted. In such a case the application server merely acts as a file server. Our most typical installs host the server files and SQL server on the same server.

Prerequisite

SQL Server 2016 / 2017 installed with its own instance preferably an instance called 'PLATO'

.Net Framework 4.6.1+

Backup

Although not a requirement, it is highly recommended that a backup strategy be employed to ensure the ability to restore the critical Plato Data Analyzer Professional databases should the need arise. It is recommended that the in house facility backup strategies be employed.

Backing up and restoring is the responsibility of the customer.

Plato DBCC

Plato DBCC (Database Consistency Check) performs consistency checks on SQL database and logs results in the windows event log. Optionally it can also email you the results. This will ensure that the Plato data is in good health and there is no corruption. Once configured the application runs as a service and does not require any user intervention. The application can be scheduled to run daily, weekly, monthly or one time.

Plato DBCC needs to be installed on the same server where SQL Server is running. Download the installation program from the link provided to you and install it with the default options. This requires the installation of .NET Framework version 4.0+ and the install program will notify you if it is not already installed on your server. (Installation of .NET framework may require a reboot). Once installed Plato DBCC is installed as a service and its configuration program can be accessed from the Start Menu->Program Files->Plato DBCC Configuration and its help file can be accessed from the help button.

You will need the following information prior to install.

▪SMTP Server: Your email server, which will be used to send notification emails.

▪SMTP Username (optional): If your SMTP Server requires authentication, its username.

▪SMTP Password (optional): If your SMTP Server requires authentication, its password.

▪Email Address 1: Email address of 1st person who wishes to be notified of the results.

▪Email Address 2 (optional): Email address of 2nd person who wishes to be notified of the results.

If Plato DBCC returns errors consult your DBA immediately. Since your facility owns the Plato databases, you will be responsible for maintaining their integrity. Plato DBCC is a CPR Technologies offered tool to assist you in this task. However, CPR Technologies is not responsible for any database corruption that may happen due to external hardware or software failures.