Loading...
Loading...
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 installer, the PostgreSQL database engine is configured to use SSPI Authentication, allowing authentication with 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 in PostgreSQL for access. Note: In Veeam ONE version 13 and higher, if the service account is different than the account that ran the initial installer, that service account will be added to the pg_ident.conf configuration file as a third account having a access to the database.
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.