Resolving BDRSuite Backup Server Upgrade Failure Caused by Database Connection Issue

Troubleshooting BDRShield Backup Server Upgrade Failure Due to Database Connection Issue

KB ID: 115101
Issue:
Failed attempt to upgrade Vembu BDR Server due to encountering a database connection problem.
Possible Causes:
This error occurs when there are difficulties in connecting to the database. Potential reasons include:
1. The database service might be stopped.
2. The database password in the configuration file (SGConf) is not encoded.
Solution:
a) Database Service Stopped:
To ensure the proper status of your database service, follow these steps:
1. Navigate to the "RUN" dialog and open "Services.msc".
2. Search for the relevant service: SGMySQL55 / PostgreSQL [PostgreSQL Server 9.6 / VembuPostgreSQL].
3. Confirm that the service is running; if not, manually start the service by clicking "Start".
b) Database Password Encoding:
(Applicable to Vembu BDR versions 3.9.1 and 3.9.1 Update 1)
1. Locate the installation directory of the Vembu BDR Server (Example: C:\Program Files\Vembu\Vembu BDR\Conf).
2. Open the "SGConfiguration.conf" file.
3. Search for the Database Tag section, which appears as follows:
<Database UseODBC="1" DSName="SGDBConnection" DatabaseName="SGDatabase" HostName="localhost" UserName="root" Password="admin" ConnectionPooling="1" SplitDatabase="1" SplitLevel="2" DumpType="1" /> 
4. If the password is visible in readable format, replace it with an encoded version.
   Caution: Create a backup copy of SGConfiguration.conf before making changes.
5. Encode the password using a tool like https://www.base64encode.org/.
6. Replace the password in encoded format in the SGConfiguration.conf file within the ODBC tag.
Example:
<Database UseODBC="1" DSName="SGDBConnection" DatabaseName="SGDatabase" HostName="localhost" UserName="root" Password="YWRtaW4=" ConnectionPooling="1" SplitDatabase="1" SplitLevel="2" DumpType="1" />  
7. Restart the appropriate service (VembuBDR / VembuODR) to apply the configuration changes.
Proceed with Upgrade:
After completing the above steps, you can proceed with upgrading your current BDRShield Backup Server build.
For additional support or assistance, please contact BDRShield technical support.

    • Related Articles

    • BDRShield - Release Notes

      BDRShield 9.0.0.U2 (Cloud) Release Date: March 12, 2026 Improvements and Fixes Improved validation of email notification settings Enhancements made to chunk file id reset handling for more consistent backup . Internal improvements implemented to ...

    • Connection Failure with BDRShield Backup Server

      KB ID: 101008 Cause: The error of connection failure with the BDRShield Backup Server occurs when the BDRShield Client for File & Application Backup, BDRShield Client for VMware/Hyper-V Backup/Windows/Linux is unable to establish a connection with ...

    • Connection Failure with BDRShield Backup Server

      KB ID: 101008 Issue: When attempting to establish a connection with the BDRShield Backup Server, users may encounter a connection failure error. This prevents the BDRShield Client for File & Application Backup, and BDRShield Client for ...

    • Troubleshooting Database/Instance Connection Issues

      KB ID: 231001 Summary: Error code 231001 indicates a connection issue between the Database/Instance and the backup server. This critical error message reads, "Unable to establish the connection between the Database/Instance and the backup server." ...

    • Troubleshooting Guide: Error 102198 - Connection Issue with BDRShield Portal

      Overview Error 102198 indicates a failure in establishing a connection with the BDRShield Portal due to an issue with the curl library initialization. This error typically occurs when the required shared dynamic link libraries (DLLs) for the curl ...