Resolve 'ODBC Permission Issue' for BDRSuite Backup Server and Offsite DR Server with PostgreSQL Database: Step-by-Step Manual Configuration Guide

Configuring ODBC Connection Manually to Resolve 'ODBC Permission Issue' for BDRSuite Backup Server\BDRSuite Offsite DR Server with PostgreSQL Database

KB ID: 115047
Cause:
Users may encounter an ODBC permission issue with the BDRSuite Backup Server\BDRSuite Offsite DR server that utilizes PostgreSQL as the database. This KB provides step-by-step instructions to manually configure the ODBC connection and resolve the issue.
Solution:
To resolve the ODBC permission issue for the BDRSuite Backup Server\BDRSuite Offsite DR server with PostgreSQL as the Database, follow these steps:
1. Open ODBC Driver - 32 bit:
a. Use the "Run As Administrator" option to open ODBC Driver - 32 bit. You can find it in Control Panel -> System and Security -> Administrative Tools.
2. Navigate to System DSN tab:
a. Click on the System DSN tab.
3. Handle the Error Prompt:
a. If you receive a popup error stating "You are logged on with non-administrative privileges, system DSN could not be created or modified," click on OK.
4. Add a New Data Source:
   a. Click on the "Add" button to add a new data source.
5. Choose PostgreSQL Unicode Driver:
   a. Select the option "PostgreSQL Unicode Driver."
6. Enter Connection Details:
   a. Data Source Name: Enter "PostGreDBConnection."
   b. Server Address: Use "localhost."
   c. User Name: Provide "postgres."
   d. Password: Use "admin" (or the password chosen during PostgreSQL installation).
   e. Database: Choose "SGDatabase." You can find these details in the       "VembuBDR_Home/conf/SGConfiguration.conf" file under the "Use ODBC" tag.
7. Test Connection:
   a. Click on the "Test" button to verify the connection. Ensure it is successful.
8. Save Settings:
   a. Once the connection test is successful, click on OK to save the settings.
9. Repeat for ODBC 64-Bit Drivers:
   a. Repeat the same steps for ODBC 64-Bit drivers and verify the results.
Following these steps will configure the ODBC connection correctly, resolving the 'ODBC Permission Issue' for the BDRSuite Backup Server\BDRSuite Offsite DR server using PostgreSQL as the database.

    • Related Articles

    • Troubleshooting BDRSuite 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 ...

    • Adding PostgreSQL Database Server for Backup

      PSQL Server can be backed up using the BDRSuite Backup Server. You can simply add the source to the BDRSuite Backup Server and configure backups. Navigate to Data Sources tab and choose Add PostgreSQL Database Server. When a PostgreSQL Database ...

    • Backup aborted

      KB ID: 101005 Product: BDRSuite Backup Server Cause This will occur due to the following reasons: Backup configuration stored in the server and client is incompatible. When the Backup storage location is inaccessible to the backup server. If you ...

    • Configuring PostgreSQL Database Backups

      Step 1: Adding Basic Job Details Enter the following details; Backup Job Name: Provide any proper name for your backup job. Backup Repository: Select the backup repository type. You can choose either Block Storage or Object Storage. Repository Name: ...

    • Steps to Change the PostgreSQL Data Storage Location in BDRSuite Backup Server/BDRSuite Offsite DR Server

      KB ID: 115042 Challenge: You need to migrate the internal PostgreSQL database files of the BDRSuite Backup Server/BDRSuite Offsite DR from one location to another due to increased storage space requirements resulting from the growing backup data ...