topic Re: Connect to a Microsoft SQL DB with Windows Authentication from talend cloud in Talend Studio

Connect to a Microsoft SQL DB with Windows Authentication from talend cloud

Anonymous — Sat, 16 Nov 2024 05:57:11 GMT

From Talend Studio I am able to connect to connect with SQL server in windows authentication mode (set IntegratedSecurity = true )

I am running the same job from talend cloud using remote engine in the same VM but it gets fail.

Checked the error log and its taking some random username to connect so its getting failed.

Please Share your thoughts .

Error :

Java Exception;tMSSqlConnection_1;java.sql.SQLException:Login failed for user '.\CAVDIMCS177$'.;1

Re: Connect to a Microsoft SQL DB with Windows Authentication from talend cloud

Anonymous — Mon, 20 May 2019 07:20:52 GMT

Hello,

Can you please clarify in which Talend cloud version/edition you are? Are you using local VM resources?

Best regards

Sabrina

Re: Connect to a Microsoft SQL DB with Windows Authentication from talend cloud

Anonymous — Sat, 25 May 2019 06:16:40 GMT

Hello

I am using the Talend cloud trial version and the studio is 7.1.The job is running on remote engine .

Yes the job uses the local VM resources.

I figured out a solution which fixed my error, while I trigger the job from cloud it was trying to connect SQL server with some random username because of which the authentication was getting failed.

I found there is a Talendremote service is installed on the machine but the logon user belongs to default user created by the service, so I changed the user to my username from logon screen for that service.

After restarting the service I triggered the job now it runs without any error.

Hope this helps