SSPI authentication failed for user "xxx"

From: Albert Praveen <albertpraveen(at)live(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: SSPI authentication failed for user "xxx"
Date: 2023-05-29 06:18:12
Message-ID: BY5PR14MB40363204B6BF1F36A7F45B89D44A9@BY5PR14MB4036.namprd14.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

Following the upgrade from version 12.5 to 12.14, you have encountered an issue where the windows application fails to connect, and the log messages indicate the following:

FATAL: SSPI authentication failed for user "xxx".
DETAIL: Connection matched pg_hba.conf.

The application establishes a successful connection when the connection string contains:
"Host=localhost;Port=18083;Database=DBName;Username=xxx;Timeout=60;Command Timeout=60;Integrated Security=True;"

However, it fails when the string contains "SSL Mode=Require;Trust Server Certificate=True;", and reverting back to version 12.5 resolves the issue.

It is worth noting that pgAdmin uses the same usermap and connection is successful. You have also attempted to add the Active Directory user to the usermap, but the connection remains unsuccessful.

We appreciate your detailed explanation of the situation and will provide assistance accordingly.

Thanks
Albert Praveen

Browse pgsql-general by date

  From Date Subject
Next Message vignesh C 2023-05-29 12:46:22 Re: Support logical replication of DDLs
Previous Message Yu Shi (Fujitsu) 2023-05-29 06:15:28 RE: Support logical replication of DDLs