Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Postgres OBDC SSL Issue

Hi,

  I'm having an issue with an OBDC connection. I've created (through PBI Desktop) and published to PBI service using various flat files and an external OBDC connection to a postgres database. For my OBDC connection, I just use the following OBDC connection string: 

 

Driver={PostgreSQL Unicode(x64)}; Server=XX.XX.XX.XX; Port=5432; Database=XXXX

 

The connection has worked perfectly fine for a few months until I received a connection error today.

After researching, I was just told by my one of the admins that they switched over to SSL recently for that database. With that information, I figured I would just add ";sslmode=require" to the end of the string

Driver={PostgreSQL Unicode(x64)}; Server=XX.XX.XX.XX; Port=5432; Database=XXXX;;sslmode=require;

 

However adding this string gives me a FATAL: connection requires a valid client certificate error message. How do I fix this issue? Any help is appreciated. Thanks!