Entra backup / restore

[cw1972]

I just updated to 12.3.2 and decided to try out the new Entra backup feature.

After much fiddling about I eventually got the backup to run by configuring the Entra ID Repository with the username postgres, whereas the connection to the main database is configured with username@machinename.

So the backup ran succesfully, but now I cannot restore as when I start the process I get the error "GSS/SSPI authentication but IntegratedSecurity not enabled"

PostgreSQL Logs show:

2025-06-25 08:36:43.486 BST [30568] [user=postgres,db=veeamrepository_4ca09150-26b4-4fd0-8277-xxxxx,app=[unknown]] FATAL: SSPI authentication failed for user "postgres"
2025-06-25 08:36:43.486 BST [30568] [user=postgres,db=veeamrepository_4ca09150-26b4-4fd0-8277-xxxxx,app=[unknown]] DETAIL: Connection matched pg_hba.conf line 90: "host all

I have no prior experience with PostgreSQL so after googling I found that I need to create entries in the files pg_ident.conf and pg_hba.conf.

In pg_ident.conf I needed the line:

veeam username@machine name postgres

Just to get the backup running in the first place. This maps my logged in username to the PG name postgres.

To try and get the restore name I added the following to pg_hba.conf (above the catch all entries):

host all postgres 127.0.0.1/32 sspi map=veeam

Though the catch all IPv4 entry should have worked, from my understanding:

# IPv4 local connections:
host all all 127.0.0.1/32 sspi map=veeam

Has anyone got this fature working for both backup and restore, anyone have any pointers?

I'm going to keep tapping away with this today as it could be a very useful feature.

Thanks all

[Mildur]

Hi Christian

Unfortunately we cannot troubleshoot such technical issues over a forum post as explained in our forum policies. Please contact our customer support and share your case number here.

Maybe you are affected by the same issues discussed in this topic. But we need our support team to confirm it after they had the chance to analyze the log files.

Thank you,
Fabian

[cw1972]

Hi Fabian,

Thank you for that link (veeam-backup-replication-f2/microsoft-e ... 96778.html), I had only search in the HyperV section.

Just to confirm, that advice in that post has resolved my issue, specifically:

Erase the value of the registry key EntraIdSqlPassword from "Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Veeam\Veeam Backup and Replication" and leave it blank.

Both backups and restores now work.

Feels a bit hacky and certainly wasn't an intuitative step to take, but thank you