How to set the SPN for Postgres SSPI

Posted by chotchki on Server Fault See other posts from Server Fault or by chotchki
Published on 2011-01-22T02:04:20Z Indexed on 2011/01/28 23:28 UTC
Read the original article Hit count: 540

Filed under:
|
|

I am trying to setup Postgres to support SSPI/Kerberos, however I think that I have not found out what the correct SPN that is needed to get it working.

The background details:

  • Service account for postgres: 'postgres'
  • Domain Name: 'testdomain.com'
  • Domain Controller: 'dc.testdomain.com'

I have tried the following SPNs and have had zero luck:

  • setspn -A HOST/testdomain.com postgres
  • setspn -A HOST/testdomain postgres
  • setspn -A POSTGRES/testdomain.com postgres
  • setspn -A POSTGRES/testdomain postgres
  • setspn -A POSTGRES/dc.testdomain.com postgres

Does anyone have some suggestions?

© Server Fault or respective owner

Related posts about active-directory

Related posts about postgresql