Skip to content

PostgreSQL SSPI (Windows SSO)

Overview

Team Edition comes with SSPI (Security Support Provider Interface) authentication support, allowing secure access to PostgreSQL databases. This authentication type enables Windows Single Sign-On (SSO), allowing users to authenticate using their existing Windows account credentials.

Settings

To configure SSPI authentication in Team Edition, follow these steps:

  1. From the Authentication dropdown menu, select the PostgreSQL SSPI method.

  2. For the authentication process, your system will utilize the relevant credentials automatically. On Windows systems, your current login credentials are used, and on non-Windows platforms that support GSSAPI, the integrated authentication system will apply.

    Note

    Your system (whether it's Windows or a non-Windows platform with GSSAPI support), and PostgreSQL server must be correctly configured for SSPI authentication. If you encounter any issues during this process, please follow the official PostgreSQL documentation.

  3. Click Test Connection to confirm your settings. If the test is successful, your setup is complete.