Windows Authentication in Sender Jdbc Adapter

[former_member187437]

Hi,

We have a sender jdbc scenario where there is no user id/passowrd maintained for the database. ONly the windows user id/password is used.

Is it possible to connect to such a database through JDBC adapter. If so, please tell how to do that?

[former_member4985 · Accepted solution]

Hi Aarthi,

Please check note #831162 - FAQ: XI 3.0 / PI 7.0 / PI 7.1 JDBC Adapter for more information

Regards,

Caio

[Former Member]

Hi Aarthi,

As per my knowledge there is not posssible to do that.

Assumption :

Database : MSSQL Database

Authentication : Window only

Solution :

You need to change authentication type become mixed.

There is some workaround for .NET webservices using windows domain authentication but not for JDBC.

Regards

Fernand

[former_member200962]

Is it possible to connect to such a database through JDBC adapter.

User-name and password are not mandatory.....just that your PI should be able to poll the DB....if it is able to poll then it will be even able to get the data from the DB.

Regards,

Abhishek.

[former_member187437]

Thanks for your response Abhishek.

Is it possible to give the windows user id and password somewhere?

[former_member200962]

Is it possible to give the windows user id and password somewhere?

What is the need to do so?