I'm running PostgreSQL 9.2 on Windows Server 2012 and I've attempted to follow these instructions for single sign-on:
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