SSPI Authentication on Windows 2012 (for Win. Clients)

From: Dave Manginelli <dave(dot)manginelli(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: SSPI Authentication on Windows 2012 (for Win. Clients)
Date: 2013-02-04 01:51:07
Message-ID: CABsBUZX4r5dxCs4HUaYFczK9=dvGtYh--X3uHk8=X6q=meZbog@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I'm running PostgreSQL 9.2 on Windows Server 2012 and I've attempted to
follow these instructions for single sign-on:
http://wiki.postgresql.org/wiki/Configuring_for_single_sign-on_using_SSPI_on_Windows

I followed the simplified instructions for 9.2 and successfully executed
the setspn command recommended there. However, I believe I still need to
follow the advice from the 9.1 section indicating that "you need to create
some login roles that have the same name as your domain users, and an entry
in pg_hba.conf with authentication method "sspi"."
I'm familiar with editing the pg_hba.conf file but I have no idea how to
add the required login roles on Windows Server 2012.

I'd very much appreciate it if someone could provide me with more detail or
point me to some additional documentation on how to add the required login
roles using Windows Server 2012's management tools.

Thanks

Browse pgsql-admin by date

  From Date Subject
Next Message Marko Rihtar 2013-02-04 07:55:17 Re: Avoid casting NULLs in UNION...
Previous Message Sergey Konoplev 2013-02-02 07:56:05 Re: Massive table bloat