Forum Discussion

samuelf's avatar
samuelf
Frequent Visitor
9 years ago
Solved

Error Message Connecting to PostgreSQL using SSPI

Hello,   I'm using Power BI Desktop 2.39.4526.362 64-bit (September 2016) and trying to connect to a PostgreSQL 9.4 database using SSPI authentication.   I can connect just fine using other clien...
Need Help
  • arify's avatar
    arify
    9 years ago

    We'll look into adding Windows Authentication support for PostgreSQL soon, it'll take a few months for it to get released publicly.

     

    Thanks for reporting this to us!

arify's avatar
arify
Microsoft Employee
9 years ago

Hi samuelf, what's your npgsql driver version?

 

Thanks

  • samuelf's avatar
    samuelf
    Frequent Visitor
    9 years ago

    Hi arify , I downloaded the latest one from github, hence Npgsql 3.1.8

    • arify's avatar
      arify
      Microsoft Employee
      9 years ago

      Is your server set up to use Kerberos Authentication (Integrated Security/SSPI/Windows Authentication) or Database Username/Password?

      • samuelf's avatar
        samuelf
        Frequent Visitor
        9 years ago

        It's setup for SSPI Windows Authentication - everything else connects without any issues i.e. Tableau or python using psycopg2