Postgress Connecter SSPI Settings on Windows

KNIME Analytics Platform
1

On my Windows 2019 Server (on a Windows Domain) i set up Posgre Local Database with SSPI. Everything Works. I can open pgAdmin and i am log in without Passwort because of my Windows Login.

I do not manage the same (on the same server) with knime.

First i need a the Connector Setting from someone who get it done.
So i know that i have the right settings and the right java connection string in the connector.

Thank You
Sebastian

2

Hi @preuss,

sorry to ask tbu can you rephrase your question please? I have a hard time comprehending your scenario.

Best
Mike

2 Likes
3

Hi,

Hi,
thanks for respond to my question.
I do this:

Create a Service User.
Making correkt entrys in pg_hba.conf

And now i can connect without pw the database on the postgre server.
Because my Windows Login pass through.

Postgree and PGAdmin and Knime are on the same server. “Localhost”.

I need help to build the correct Java Connection String to have the same functions. So i do not have to leave password in the node.

Sebastian

4

Ist this Mail a Auto Mail?
Hi @preuss,

sorry to ask tbu can you rephrase your question please? I have a hard time comprehending your scenario.

I explain it very good i think.

In Other Words: How to make a JAVA ODBC String to Connect with my logedin User, without Password.

Thanks Sebastian