Migrate the internal database to MSSQL database using the migration tool. Configure the MSSQL database user before using the migration tool to migrate. A user name and password are required to complete the process. The user must have sufficient permissions to create a database.
Make sure that you have administrator rights to run the migration tool.
The Database Security Server must be stopped before you try to set up the external database.
It is recommended to copy the file server-custom.properties located in the
<installation directory>/conffolder and save it under another name, for example, Trellix-custom.properties.1.
If you do not want to grant create database permissions to the database user to access the Database Security server database, you can migrate the database manually.
Manually create the databases SNTRSRV and SNTRSRV_BACKUP using a user with create database permissions.
Run the migration script and provide it with a database user that is now only required to have these permissions on the SNTRSRV and SNTRSRV_BACKUP databases:
db_datareader
db_datawriter
db_ddladmin
Start the migration tool in one of these ways:
On a Windows system, open a command prompt (cmd), then go to the bin directory under the root install directory.
For example:
C:\Program Files\McAfee\Trellix Database Security\binThen, run the bat file, migration_tool.bat.
On a Linux system, run:
/etc/init.d/mfe-dbs-server db-migrate
Select an action, type
migrate.Select the database type, type
mssql.Type in the MSSQL username and password that you defined.
Type in the IP address of the host server where the database is located.
Note
If the external database is on the local host, the external IP address or host name of the server should be used. Do not use local host or 127.0.0.1.
When prompted to enter the MSSQL Listening Port, type in the number of the MSSQL port of the database host used for listening, for example, 1433. Verify that TCP/IP communication is enabled for that IP address and port.
After the process is completed, a message is displayed indicating the duration of the process and whether the process completed successfully.
When the process completes successfully, the server-custom.properties file is modified to contain properties that enable Database Security to connect to the external database.
Note
If the process fails, examine and verify that the properties listed on the screen are correct. For further assistance, contact support with the process output.