custo diagnostic 5.x based on a Client-Server-Architecture. If you want to use custo diagnostic 5.x (multi Workstation or Stand-alone does not matter) you have to install the custo diagnostic server 5 at first. The custo diagnostic server 5 is an Tomcat based Application Server with Connection to an local or networkbased Database. At this time 'H2 Database' (included in Tomcat) or 'MS-SQL Database' is supported. The H2 Database should be installed on the same Computer as the custo diagnostic server 5. For MS-SQL Database a local installed or installed on another Computer SQL Server can be used (Please rever also to the custo diagnostic 5 Hardware and Software Requirements).
...
Installation with H2 Database
Preparation
No preparations necessary for this installation.
...
The Content of the CustoCfg.ini is the Target Information for the custo diagnostic client about the custo diagnostic server.
...
Installation with MS-SQL Database
Preparation
custo diagnostic server 5 Setup does not install any Database Server and dont create any Logins oder Databases inside the MS-SQL Database Server. You have to preparate your MS-SQL Database System by yourself.
Please be aware about note the following factsthings:
- Microsoft SQL Server Version 2008 or higher allowed
- all Editions possible
- the SQL Server have to configured with TCP/IP on a fixed Port (Default: 1433)
- Windows User Authetification Authentification is not permitted, you have to switch the SQL Server into Mixed Mode Authentification
- You have to create a SQL Login with Password
- You have to create a Database with a Collation depending on the Language is used for Patient Demographics
- You have to insert the Login as Database User in the Database
- You have to set 'db_owner' Rights onto the Database User
Attention:
If you plan an Upgrade from custo diagnostic 4.x to custo diagnostic 5.x you have to create a new separate Database for custo diagnostic 5.x. Its not possible to "convert" the custo diagnostic 4.x SQL Database to custo diagnostic 5.x into the same SQL Database!
Installation
After the Database is ready to run you can start the Setup. During the Setup you can select 'MS SQL Server':
Please Please perform all Steps from the "Installation with H2 Database" up to Step 5.
In Step 6 please fill the Fields with the following Information:
| Option | Description |
|---|---|
| MS SQL Server Hostname | the Hostname of the SQL Server Computer without the Instance Name |
| MS SQL Server Port | the fixed Port of the SQL Server |
| MS SQL Server Database Name | the Database Name created by you |
| MS SQL Server SQL User | the Database User with db_owner Rights (created from the Login) |
| MS SQL Server Password | the Password of the SQL Database User |
After Step 6 perform the Steps from Step 7 of the "Installation with H2 Database".
Attention:
The Setup does not Test during the Installation if the Database is writable or not.