112
en | Hints and Tips
DICENTIS
2021.06 | V3.7 |
Configuration manual
Bosch Security Systems B.V.
14.8
Deleting a database
Deleting a database will remove the database files. The system will not work anymore unless a
new database is created or a previous database is restored. This function can be used to
delete the database if you need to downgrade to a previous version.
1.
Stop DICENTIS
services
using the DICENTIS
Server Console
.
2.
Open a command prompt in
Administrator mode
.
3.
Go to:
C:\Program Files\Bosch\DICENTIS.
4.
To delete the database, run
DcnmDatabaseConsole.exe -x
.
Note:
Without a database, the DICENTIS system will not function properly. A database needs
to be created or restored to make the system functional again.
14.9
Connecting DICENTIS to a (remote) SQL server
The DICENTIS system uses environment variables to access the database. The default values
are used when environment variables are not present.
The following environment variables are used for the database name and database server:
MMCN_DB_SERVER
The Database server PC name and server instance name.
Format:
MachineName\instanceName
(the instance name can be
omitted when the default instance is used. The machine name can
be a dot ('.') when the local machine is used)
Default:
.\SQLDICENTIS2014
MMCN_DB_USER_ID
SQL server user-Id (SQL authentication). When absent, integrated
authentication is used.
MMCN_DB_PW
SQL server password (SQL authentication). Only valid in
combination with MMCN_DB_USER_ID
MMCN_DB_DATABASE DICENTIS database name. Default:
DcnmDatabase
Note:
DICENTIS uses two databases:
DcnmDatabase
for storing all configuration and
DcnmLoggingDatabase
for storing the logging. Using the environment variables, the
DcnmDatabase
can be redirected to another server/database. However, there is currently no
possibility to redirect the
DcnmLoggingDatabase
. The logging database is always located on
the default server (.\SQLDICENTIS2014).
Creating a new environment variable
To create a new environment variable:
1.
Right click “This PC” \ Properties \ Advanced system settings \ Environment Variables \
System variable \ New
2.
Enter the required variable name
3.
Enter the required variable content
Creating the database on the SQL server
–
The console tool DcnmDatabaseConsole.exe is used to create the database. When
necessary to copy the tool, the following files have to be copied:
DcnmDatabaseConsole.exe
