Veeam V12 PostgreSQL Config DB SQL Queries fail

Hello,

we are monitoring the customer backups via PRTG.

Till now, we had a SQL Skript, wich got the latest result and reported it to PRTG:

SELECT latest_result FROM bjobs WHERE name = @prtg;

That worked fine with MSSQL Express, but now with PostgreSQL we have to use a PostgreSQL Sensor in PRTG. Thats no problem, but it always failes with: “GSS/SSPI authentication but IntegratedSecurity not enabled” when I try to use the postgres user, or with: 28000: SSPI-Authentication for user Administrator failed”. For debugging I tried to change the access settings in the pg_hba.conf file but nothing seems to work.

Is there a way I can still run queries to the config database? Or do I have to go via the PowerShell Snappin from Veeam?

PS: We don’t use the Enterprise Manager, because you need the Enterprise Plus license for that and our customers don’t have that license.

Thanks alot.