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
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