Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1srD6k-00G7Pi-Au
	for pgsql-admin@arkaria.postgresql.org; Thu, 19 Sep 2024 09:05:50 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1srD6i-007XOr-IC
	for pgsql-admin@arkaria.postgresql.org; Thu, 19 Sep 2024 09:05:48 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <mukherjee.sabyasachi@outlook.com>)
	id 1srD6h-007XOb-VP
	for pgsql-admin@lists.postgresql.org; Thu, 19 Sep 2024 09:05:48 +0000
Received: from mail-vi1eur02olkn2090.outbound.protection.outlook.com
 ([40.92.48.90] helo=EUR02-VI1-obe.outbound.protection.outlook.com)
	by makus.postgresql.org with esmtps  (TLS1.2) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <mukherjee.sabyasachi@outlook.com>)
	id 1srD6b-001wua-9i
	for pgsql-admin@postgresql.org; Thu, 19 Sep 2024 09:05:46 +0000
ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none;
 b=Zw5/hgAy1f3k2q2bN6n0ElKQwbf9qI5GHjWIC5wSym3H5YyvdHDWhqpBNlg8o4fi43olQkv8h0OmhSLkS/Yosw3uCxG5bfpzlVXddmNrjkAfS+nAOx+bnPlgks6h/vN7j3scSADMnwJZiQORXi/4QU4C6poPTzHFFc7tpOx6rIB8IEGpWySRmilV2IZC0q1a+Sny2lPwbgP02Yw1eVI8h/M2Sj61yAE0D5iiHLfDK9pBchxPQMF/Jh977XI4FBZMdkglto8RAbySsn4nOJRbn9KhYHk1enT58iWtYVgZJoWJCvKg9580H9U20je/E8PKmi+zhWtDLF1Kt8gPIkc1kg==
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com;
 s=arcselector10001;
 h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1;
 bh=+VYn75bjOZQdapGt1tOWemaga3fnDzd+Y3e6y70la8E=;
 b=lBm5XVmgukSDhmzj15pyt58AkrlYjrtI2qfLgqNyPXTRFs4wkkxVBd71flpxXdooaOV6WHXgec0IBlpuXt9n0BXq4AUm6KgdYSk5PuG/bduTRrHwcNHEt6PcK8DG3K2HQcEkL53iOz8mP2JiUuQkwjUvaykdsBQcK1orA0XWbDyyDZ+q4mRR8BrP6kW/o4h5KaSNDRLri7pWHqH0AECbGJGu9RkU2fthW9ZHCfUUFo4EFGXty3t5Ji0alPp1jF7MtOSVGcrqwrKodUE5/SWrGBlGpxLuTfHR4IVSNE6KXmILZN3EiScTWijwtxJo1pt+0vBb9QihKOdmvZE1Jm3/mA==
ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=none; dmarc=none;
 dkim=none; arc=none
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=outlook.com;
 s=selector1;
 h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck;
 bh=+VYn75bjOZQdapGt1tOWemaga3fnDzd+Y3e6y70la8E=;
 b=d40zLwj3JMS4PWwKBb+sUABce9JmwvyXgMd+kOaKvcXmIORaWLeR/Dcb2gRcaj7njPWBm1d1ar06kVcZs9lYWOiKf1kwv4C7IIrIdpZWIdMXse2wfnRJTwE3RYIWRzobWEsc58slFmur4KC29ScX0i8LT2fTDO2+q+38ldBqUBjnQ+ORFT3Kvbw/j7lYDsv/6ya/0is81knc0xt1eBC1ITTmnUw0WgH3xIrawwA3fmEIIbwzpE3i+3rZiCk10QgwoZ8F35Vv1eQdTYEDcr6j+eWV6unik0GFBkLLbFWx4JllMOeAwriF0pOGIcnq718x01h0j7GbKho35jtmjHWFJg==
Received: from DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM (2603:10a6:10:3cf::15)
 by GV1PR10MB6326.EURPRD10.PROD.OUTLOOK.COM (2603:10a6:150:5e::7) with
 Microsoft SMTP Server (version=TLS1_2,
 cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.7962.28; Thu, 19 Sep
 2024 09:05:37 +0000
Received: from DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM
 ([fe80::e113:72f1:4ad7:3c24]) by DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM
 ([fe80::e113:72f1:4ad7:3c24%3]) with mapi id 15.20.7982.018; Thu, 19 Sep 2024
 09:05:37 +0000
From: Sabyasachi Mukherjee <mukherjee.sabyasachi@outlook.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Connecting Postgres SQL from Power BI
Thread-Topic: Connecting Postgres SQL from Power BI
Thread-Index: AQHbCnE8eby3RkP7Y0i8bD0EnoSbNg==
Date: Thu, 19 Sep 2024 09:05:37 +0000
Message-ID: 
 <DB4PR10MB7469D02DCFBC3B63788FEF1E8C632@DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM>
Accept-Language: en-IN, en-US
Content-Language: en-IN
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
msip_labels: 
x-ms-exchange-messagesentrepresentingtype: 1
x-ms-publictraffictype: Email
x-ms-traffictypediagnostic: DB4PR10MB7469:EE_|GV1PR10MB6326:EE_
x-ms-office365-filtering-correlation-id: 09c77b8d-412a-4fc0-e5c2-08dcd88a3a37
x-microsoft-antispam: 
 BCL:0;ARA:14566002|8060799006|19110799003|461199028|15030799003|7092599003|15080799006|102099032|3412199025|440099028;
x-microsoft-antispam-message-info: 
 QHu6N1DzOjY4jGNri90ZFwDBHJzCIDRghSVffz5Ppz+z62JVDfNbCZwbM4R1a4DuyugSUmXwFf5VtBJ4WDc+DYGTj7iUDQ+yC9LhroA+gLz29zEQ4cbZnm466OTCxZHbqZ4AKwu6TFyFosY3ll9riBiGRNakC8U5dwWKAAbiMoKvs2OXCw3o9ikp8SOsuvQ/QDCOg/n2+rNgmCajkuWMKWRIgsz1HR2+ADfzs2EXB93jQqLn7NG1j53wll+ipzED7whLtZ5xAQUUKE6gdrV1XWYJRKavXq9ZuHjZ091GPK/MpjUrgKlEM5OIiXApnYpH/h2E8ERZjj2VE28xKVjGCswB9a/Fm/97Z158YpOQtIUTuUVAa6BWKEnHs35Hf+nNm/IGPATuSL+FLS391cBgnW7nC++Wvao2GZ0+0+FqAW8q3NZzxhXC4WEVcBXkN/gQe1MQU34rrc1Im8l4sQPrhwfRhFTTXMB6xL5xO1roqDDLFx+8XS9wp0vhQpbILVgwR91pz68enoCowbslyoOWfrkzVRITDMFM4yBgBs0dm9LLKQcC97BnB52KmScjM7fXIh73WB1uvUCMr0WeMmGGp2EdQ+RgM81sNG108kbAzKTDaFH9+NvVlGKDqasu402HGRBV3ZwsEGYoDnX4BAE213mIo5AfagzGd26R9Rq3Aj5uE82oOyD5ojse409NPpLwXjBlH69BLzG9N7BUenxqlWlIVtCvWg0XL9lz/4xfDFo=
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?iso-8859-1?Q?C3durThZ+fQNz5soW5cTJq1mVT00adZlfsMnRMUML+u/C6Vu1CdWc+3o6r?=
 =?iso-8859-1?Q?LvWOfKOQiMEeJchFzpKPID0MMA/tjj6jJhtEqwuvsBvijapqs8R5ammaxY?=
 =?iso-8859-1?Q?d3ENi324gv+spSo+4gYQWLykh6tfIK7fV6+lNBj9EEZZaqwmBqYVoybxJc?=
 =?iso-8859-1?Q?vWjL7INEzPXcY+Bkah9Kowi2ZhmsE1CNxQGPFGwmzrOnI/qNsM7H//1Nq7?=
 =?iso-8859-1?Q?NDYEqrT7W5IMYIZc8QkbeQ/QgBjGCf/6hkuBT2IZWzxntDqlriF1kwlQYR?=
 =?iso-8859-1?Q?g3d3fOO181Hn3VfylSd0/k+O0sLa1qZ2u3ft1hR5yoJ6xfI7W2zNxgilE9?=
 =?iso-8859-1?Q?rNicUlJYxLxJV0XUJH9E/0vW6EqrGOKsQbwhPcfF7a6tBQ3/whvLdd/h1I?=
 =?iso-8859-1?Q?4HDDfEduWJ/90w3uxCo7u+bZQtpgKtMKZWqNOVUGaoQaT6s831VUQ3AIF3?=
 =?iso-8859-1?Q?4vSPbiOalEZkjUGIw3jhxhQeclDsEUo9qUoC4fTtRydrYFpqXwbMnhY97b?=
 =?iso-8859-1?Q?StKv7n968+ifVQEVguwsZGZfXZHJeMYVP1o/YapJ30YyNAOPgAOw7bCpby?=
 =?iso-8859-1?Q?lHdPygfsJlExhLd54/qhyhNnzYrjekacIdly+vdyY+BEYhQpLrNMsld+E7?=
 =?iso-8859-1?Q?57z99aJDIrs7+aZv00KdkXe2k4zhkXQgiALapZ7XQKKdnK3OQbUNmfW6Qa?=
 =?iso-8859-1?Q?FFBSNoBMA3WYzqmC6u8QYxoHQlIvmnGCOz3LYWyyWsi15q/nSDeiuc+Ddd?=
 =?iso-8859-1?Q?LQEw0qW7OvGkUgVRvlMM9dZRKhM3qbuOyPpGlqrkjAFv7r5cgmHD0MXZpz?=
 =?iso-8859-1?Q?KU+2O36Yn8ayhkgn923IoV4ks4WJ05kMnQJV95AS2beeQjK8ZTNv8N/JoT?=
 =?iso-8859-1?Q?sGEXTTjFQICaMTtQC0VCHAVM3TX/U4SGdROJZWPea4OShVyvPcGJsFdCcv?=
 =?iso-8859-1?Q?fTIg5uFkp5N858Tn5PZqTgnNHdYYuyve2w06leB0/KCyBv8bAE/W3jgAVX?=
 =?iso-8859-1?Q?O/iVErG7F6XDrL5Z0bG9drpuRfzGXs+fJjn9Zq9LFj4aANkfSO+MBnNCha?=
 =?iso-8859-1?Q?sS0g5Qw47b87v47TQxAzeOdCy0YRiKujgyAOAtw+SlztmsbJFUvAaFzST9?=
 =?iso-8859-1?Q?nqE9C+WRXbAPwCVxgmejztjg59uOp9KZKXLrD6/Q2QBrlBNqbyizpR+4Ur?=
 =?iso-8859-1?Q?fmu5nrrT0v5xfdw8+zG7JIQapxFlSHbUxdKju85sI7cqFg03v1t9noZqqD?=
 =?iso-8859-1?Q?FcbRzls3bAH08whWjv4AXRDh60pQGU72Xh/GufBZaMDgtlFwT7d5m4iTka?=
 =?iso-8859-1?Q?Ncyc?=
Content-Type: multipart/alternative;
	boundary="_000_DB4PR10MB7469D02DCFBC3B63788FEF1E8C632DB4PR10MB7469EURP_"
MIME-Version: 1.0
X-OriginatorOrg: outlook.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg: 
 00000000-0000-0000-0000-000000000000
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 09c77b8d-412a-4fc0-e5c2-08dcd88a3a37
X-MS-Exchange-CrossTenant-originalarrivaltime: 19 Sep 2024 09:05:37.3207
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-rms-persistedconsumerorg: 
 00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped: GV1PR10MB6326
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/DB4PR10MB7469D02DCFBC3B63788FEF1E8C632%40DB4PR10MB7469.EURPRD10.PROD.OUTLOOK.COM>
Precedence: bulk

--_000_DB4PR10MB7469D02DCFBC3B63788FEF1E8C632DB4PR10MB7469EURP_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 use=
rs - 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 th=
e following message.

Details: "PostgreSQL: SSPI authentication but IntegratedSecurity not enable=
d"

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=3Dmapname"

Can any body advise please?

Sabyasachi Mukherjee

--_000_DB4PR10MB7469D02DCFBC3B63788FEF1E8C632DB4PR10MB7469EURP_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Diso-8859-=
1">
<style type=3D"text/css" style=3D"display:none;"> P {margin-top:0;margin-bo=
ttom:0;} </style>
</head>
<body dir=3D"ltr">
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Dear All,</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
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 use=
rs - so that the windows user do not have to authenticate every time.</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I can connect using the DBeaver to the database using the user.</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
However - when I try to connect from Power BI using the same user, I see th=
e following message.</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Details: &quot;PostgreSQL: SSPI authentication but IntegratedSecurity not e=
nabled&quot;</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
In the log I see the following -&nbsp;</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
2024-09-19 10:38:50.497 CEST [7628] FATAL: &nbsp;SSPI authentication failed=
 for user &quot;username&quot;<br>
2024-09-19 10:38:50.497 CEST [7628] DETAIL: &nbsp;Connection matched file &=
quot;path/pg_hba.conf&quot; line 124: &quot;host&nbsp; &nbsp; hostname&nbsp=
; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;username&nbsp; &nbsp; &nbsp; &nb=
sp;0.0.0.0/0 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;sspi map=3Dmapname&qu=
ot;</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Can any body advise please?</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div class=3D"elementToProof" style=3D"font-family: Calibri, Helvetica, san=
s-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Sabyasachi Mukherjee</div>
</body>
</html>

--_000_DB4PR10MB7469D02DCFBC3B63788FEF1E8C632DB4PR10MB7469EURP_--