java.sql.SQLException: I/O Error: GSS Failed: No valid credentials provided (Mechanism level: Failed to find any Kerberos tgt)

[tk3]

Hi,

I created a job in windows 10 and it runs successfully. Inside the job, i have two connections and one of it is using AD connection. In windows, i start Talen Open Studio with 'run as a different user' option and enter the AD name and password.

Now i move that job to a Ubuntu server that has already joined domain, and i login to that server using the same AD name and password. When i test run the job in command line , i encountered the error in the Subject.

Could someone guide me on how to check and fix this issue?

Thanks.

[Anonymous]

Hello,

What does your job look like? Are you getting this issue when executing a Job with HDFS source and target?

Do these KB articles help?

https://community.talend.com/s/article/A-Job-with-HDFS-source-or-target-fails-with-a-GSS-initiate-fa...

https://community.talend.com/s/article/GSSException-No-valid-credentials-provided-Exception-When-Exe...

Best regards

Sabrina

[tk3]

Hi, Thanks for your response.

This is how my job looks like. The 'DMS-Prod_Talend' is connected using windows authentication method. And my issue is not the same as in the KB articles.

For Microsoft SQL Server connection, is there any specific setup i need to do so that Talend Open Studio is able to pull credential info from domain? This is the direction i am looking into for now. Will share if i find anything.

[Anonymous]

Hello,

Are you trying to connect secured SQL server connection(Kerberos authorization needed to authenticate sql server using windows authentication)?

Please try these following steps

1. Changed jtds driver to mssql JDBC driver

2. Append "integratedSecurity=true;authenticationScheme=JavaKerberos" to jdbc url additional parameter

And feel free to let us know if this related topic and doc helps

https://community.talend.com/t5/Design-and-Development/Need-help-connecting-SQL-Server-using-Kerbero...

https://confluence.atlassian.com/bitbucketserverkb/use-integrated-authentication-over-kerberos-when-...

Best regards

Sabrina

[tk3]

Thanks. That's what i am trying to do.

[Anonymous]

Hello,

Don't hesitate to post your issue here.

Best regards

Sabrina