Postgres Pro
Downloads
Home   >   mailing lists

Re: 8.3 problems with sspi authentication - Mailing list pgsql-bugs

From Christian Ullrich
Subject Re: 8.3 problems with sspi authentication
Date
Msg-id 610595-q1m2.ln1@xander.fuerth.chrullrich.de
Whole thread Raw
In response to 8.3 problems with sspi authentication  ("Matthias Mohr" <Matthias@Mohrenclan.de>)
List pgsql-bugs
Tree view 
* Matthias Mohr wrote:

> I tried to use the new sspi authentication in PostgreSQL 8.3 to directly
> use a Windows user for PostgreSQL authentication. So for a test I changed
[...]
> I'm using Windows XP Professional with SP2 and a lot of additional

Do you have "Simple File Sharing" enabled? If so, the client user is always
authenticated as Guest. The Guest user is usually disabled, which makes
authentication fail.

For details see <http://www.ngssoftware.com/papers/database-on-xp.pdf>.

--
  Christian Ullrich  .  Expect a letter from a friend who will ask
                     .  a favor of you.
    Registrierter    .
 Linux-User #125183  .

pgsql-bugs by date:

Previous
From: "Mike Leahy"
Date:
Subject: BUG #3983: pgxs files missing from binary installation
Next
From: "Matthias Mohr"
Date:
Subject: Re: 8.3 problems with sspi authentication