Database Credentials Tool
MetaDefender Managed File Transfer systems integrated with a remote Microsoft SQL Server are prompted at install time to provide login credentials (username and password) for the database server connection.
Administrators may periodically update these credentials for security compliance.
The feature to update database credentials is only available for Managed File Transfer installations that use the recommended Microsoft SQL Server integration option at install time.
This feature is not available for Microsoft SQL Server Express LocalDB or Microsoft SQL Server - Windows Authentication.
Update Database Credentials
Ensure the new Microsoft SQL Server account has the required roles. The SQL Server login must have at least the dbcreator server role. The login must map to users for the master, sft_data, and sft_conn databases. Users must have the db_owner role.
Open Command Prompt (cmd):
- Navigate to the Installation folder where the
SftDatabaseConfigurationTool.exefile is located. (e.g.: C:\Program Files\OPSWAT\MetaDefender Managed File Transfer\Tools)
- Navigate to the Installation folder where the
Open CmdRun the Tool with Arguments:
- Enter the following command structure:
SftDatabaseConfigurationTool.exe [--username <username_value> --password <password_value>] [--port <port_number>] [--encrypt] <true/false>
- Enter the following command structure:
SftDatabaseConfigurationTool command line arguments:
If
--usernameis set,--passwordis required, and vice versa.- Example:
--username admin --password pass123
- Example:
Specify a valid port number if required.
--port <port_number>- Example:
--port 1433
- Example:
Enable encryption by choice. Do not use alongside
--port:- Example:
--encrypt true
- Example:
Provide a new login account when updating the database credentials.
The new account must be different from the one currently in use to prevent invalidating the current connection string.
To update the password of the existing login account only, create an intermediate login account to maintain the database connection while updating the password.
Once the password of the first account is updated from the SQL Server, update the database credentials from MetaDefender Managed File Transfer to the first login.
For potential errors during the update procedure, refer to the opswat.mft.database.configuration.log file located in the MetaDefender Managed File Transfer™ installation folder under the path Services\Logs.