Hi,
I'm using pgAdmin 1.22.1 on Windows 7 and wanted to connect to a server using SSPI authentication. I managed it in the end, but the user experience could do with a lot of improvement.
It was unclear to me whether pgAdmin supports SSPI at all, because the UI says nothing about this and googling "site:
pgadmin.org sspi" returns 1 irrelevant results. Elsewhere I found advice about setting PGGSSLIB and PGKRBSRVNAME environment variables, so I did that - but then it still worked after I unset them, so apparently this was not necessary.
I'd like to suggest the following improvements:
*) Document which authentication methods are supported and how to use them.
*) Make this obvious in the "New Server Registration" dialog as well.
*) Allow the user to select in the "New Server Registration" dialog what authentication method they want to use.
*) Do not require a username to be entered when using SSPI (regardless of the previous point)! This was the most confusing part for me, because I didn't know whether I should enter "DOMAIN\username", "FQDN\username", "username@DOMAIN", "username@FQDN" or something else. And why would I need to enter it at all?
*) Do not prompt for a password when using SSPI. I was confused by this, too - should I re-enter my Windows password? A blank value worked, but it annoyed me for a while by prompting for a password every time (despite me checking "Store password"), but eventually I figured out that if I just enter any non-empty text the prompts disappear and it still works.
Regards,
Evgeny Morozov