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

[Anonymous]

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

[Anonymous]

Hello,

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

Best regards

Sabrina

[Anonymous · Accepted solution]

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