OPERATIONAL DEFECT DATABASE
...
...
In Veeam Backup & Replication When installing updates, restoring configuration, or directly interacting with the database (e.g., using pgAdmin), the following error occurs: SSPI authentication failed for user
This error occurs when the account used to interact with the PostgreSQL instance is not authorized. When PostgreSQL is deployed by the Veeam Backup & Replication or Veeam ONE installer, that PostgreSQL database engine is configured to use SSPI Authentication, allowing for authentication using Windows accounts. During the installer's configuration of the PostgreSQL instance, only two Windows accounts are automatically added for access: The Windows account that was used during the initial install. The NT AUTHORITY\SYSTEM account (The account used by the Veeam services.) If the SSPI authentication error occurred during an upgrade of the product, and PostgreSQL is already installed, the user account used to run the upgrade is likely not configured within the PostgreSQL settings for access.
To resolve this issue, identify which accounts have access to PostgreSQL, and use one of those. If you cannot use one of those accounts, add your user account to the PostgreSQL configuration to gain access to the PostgreSQL instance.
Veeam Integration
Learn more about where this data comes from
Bug Scrub Advisor
Streamline upgrades with automated vendor bug scrubs
BugZero Enterprise
Wish you caught this bug sooner? Get proactive today.
