public inbox for [email protected]
help / color / mirror / Atom feedFrom: Sabyasachi Mukherjee <[email protected]>
To: pgsql-admin <[email protected]>
Subject: Connecting Postgres SQL from Power BI
Date: Thu, 19 Sep 2024 09:05:37 +0000
Message-ID: <DB4PR10MB7469D02DCFBC3B63788FEF1E8C632@DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM> (raw)
Dear All,
I need some advises here. I have an OnPrem postgres installation (v16). The DB has SSPI enabled. One user is created and it is mapped with windows users - so that the windows user do not have to authenticate every time.
I can connect using the DBeaver to the database using the user.
However - when I try to connect from Power BI using the same user, I see the following message.
Details: "PostgreSQL: SSPI authentication but IntegratedSecurity not enabled"
In the log I see the following -
2024-09-19 10:38:50.497 CEST [7628] FATAL: SSPI authentication failed for user "username"
2024-09-19 10:38:50.497 CEST [7628] DETAIL: Connection matched file "path/pg_hba.conf" line 124: "host hostname username 0.0.0.0/0 sspi map=mapname"
Can any body advise please?
Sabyasachi Mukherjee
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: Connecting Postgres SQL from Power BI
In-Reply-To: <DB4PR10MB7469D02DCFBC3B63788FEF1E8C632@DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox