Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
#Configuration created by installer
diag.dataDirectory=C:/diagserverdata/
diag.searchDirectory=C:/diagserverdata//search
diag.dbCollation=GERMAN
diag.dbDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver
diag.dbUser=custodiagnostic
diag.dbPass=custodiagnostic
diag.dbUrl=jdbc:sqlserver://localhost:1433;databaseName=custodiagnostic;user=custodiagnostic;password=custodiagnostic;
diag.dbDialect=de.customed.orm.UnicodeSQLServerDialect
diag.dbShowSQL=false


Configuration - SQL Login with Integrated Security (available from custo diagnostic server version 5.8.2 on)

Before configuring the SQL authentication this way make sure that you have both the MS SQL server and the custo diagnostic server within the same Active Directory Forest or within at least a trusted domain environment. On top you will need a service account needing full rights on the custo diagnostic server and needing DB owner rights on the custo diagnostic DB on the SQL server.

...

Restart the custo diagnostic service and check the logs.


In case of problems with the SQL server certificate (you will see error messages like "javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target." in the custo diagnostic server log) and if it is acceptable for the customer's IT security (e.g. because the MS SQL server is on the same server as the custo dianostic server) you may configure as well a not encrypted DB connection:


diag.dataDirectory=D:/diagServerData/
diag.searchDirectory=D:/diagServerData/search
diag.dbDriver=com.microsoft.sqlserver.jdbc.SQLServerDriver
diag.dbUser=
diag.dbPass=
diag.dbUrl=jdbc:sqlserver://<Servername>:1433;encrypt=false;databaseName=<database>;integratedSecurity=true
diag.dbDialect=de.customed.orm.UnicodeSQLServerDialect
diag.dbShowSQL=false
diag.dbCollation=GERMAN