V12 Upgrade error: SSPI authentication failed for user

[RobertMu]

[UPDATE] See here for the solution > KB4542

Hello,

just wanted to upgrade my installation to 12.1 using latest version, and I'm having problems setting up the database. It's a local PostgreSQL installation and on a step where I'm supposed to setup database connection I select "Windows Authentication Credentials of the backup service account", which is what's configured according to pg_ident.conf. And after clicking "next" it throws me an error SSPI authentication failed for user "domain\<my current user>". I'm scratching my head here - wasn't it supposed to use NT AUTHORITY\System account for connecting and not my user account? What am I missing here? Thanks in advance for any info on this.

[Egor Yakovlev]

Hi Robert,
was that PG SQL instance installed by previous VBR installation or was it manually installed?
- check the currently used service account of Veeam Backup Service
- try logging that account to PG Admin UI

[Arcanis]

I had the exact same issue and opened a support ticket they sent me the following KB: https://www.veeam.com/kb1471
The instructions for troubleshooting that error on PSQL fixed it for me. The end result was it only has the user who initially did the install as enabled to log in. Adding the upgrading user account allows it to run.

[RobertMu]

Yup, that did it. Thank you very much!

[robnicholsonmalt]

Worked for me too. Veeam had been installed using the local administrator account and I was trying to upgrade via a domain admin account. Quick fix is to edit "C:\Program Files\PostgreSQL\15\data\pg_ident.conf" and add veeam username@domain postgres where username is the account you're using and domain is the NETBIOS domain, e.g. veeam it.support@BBC postgres where BBC is the NETBIOS domain. The existing entry had the domain in uppercase - not sure if that's critical.

[mlumsden76]

Quick fix is to edit "C:\Program Files\PostgreSQL\15\data\pg_ident.conf" and add veeam username@domain postgres where username is the account you're using

What you said fixed it. I had installed VBR it with the administrator account when the server was new. But since have created a dedicated admin account. updating the "C:\Program Files\PostgreSQL\15\data\pg_ident.conf" file to use the new admin account allowed me to complete the installation.

[chris.childerhose]

This one fixed things for me as well with the upgrade to 12.1. Great post to bookmark and the KB.

[Mildur]

The kb was updated. We have now a dedicated kb for this particular issue: https://www.veeam.com/kb4542

Best,
Fabian

[ewjake]

What you said fixed it. I had installed VBR it with the administrator account when the server was new. But since have created a dedicated admin account. updating the "C:\Program Files\PostgreSQL\15\data\pg_ident.conf" file to use the new admin account allowed me to complete the installation.

Yep this was my exact issue and this worked! Ty I was so confused