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.