Failed attempt to upgrade Vembu BDR Server due to encountering a database connection problem.

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.

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".

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.