Skip site navigation (1) Skip section navigation (2)

Re: Can't create DSN using SSPI authentication WinXP to WinXP

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Roger Quincy <Roger(dot)Quincy(at)twdb(dot)state(dot)tx(dot)us>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Can't create DSN using SSPI authentication WinXP to WinXP
Date: 2008-03-31 03:36:08
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
Roger Quincy wrote:
> I have PostgreSQL 8.3.1 w32 running on Windows XP sp2 server.
> I want to authenticate using sspi for my Windows XP clients (domained) but while creating a DSN, I get an "authentication method 9 not supported" error message. However, connecting with the pgAdmin III works fine.
> Here is a screenshot of the error message on the client while trying to create a DSN: 
> The error message dialog box pops up after clicking the Test button.
> If I change the entry in the pg_hba.conf file to from "sspi" to "trust", I can create the DSN with no problem. But, using trust for multiple users is not secure enough. I am using the latest psqlODBC verson (
> I am not a programmer so I need to know if there is an easy fix for this.
> Can anyone help me?

Could you try to select the *allow* SSL Mode ?

Hiroshi Inoue

In response to

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2008-03-31 04:10:25
Subject: Re: Default schema in DSN
Previous:From: AndreasDate: 2008-03-30 01:00:18
Subject: Re: Access issue again

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group