topic Re: Connecting to local MS SQL in Talend Studio

Connecting to local MS SQL

JSey — Sat, 16 Nov 2024 00:38:37 GMT

I'm trying to connect to a local MS SQL database, but not having any luck. It's giving me this error:

Connection failure. You must change the Database Settings.

java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'Desktop-6CVODP3\Johnny'. ClientConnectionId:734730f0-439e-41c0-aa4e-07bdd2098f5f

Here are my MS SQL connection settings:

I know I have the wrong data base name in there (I was testing something and I have the instance name in there). I have tried with the db name and that didn't work either. I'm running 32 bit Talend TOS_DI-Win32-20200219_1130-V7.3.1 and

Java JRE 8. I'm not sure if I need JRE 11 or Talend Open Studio DI 64 bit for MS SQL connection to work.

In MS SQL management I have mix authentication enabled. I have tried to authenticate using window user credentials. The user I'm using has sysadmin role within MS SQL

The first time I tested the connection, Talend requested sqljdbc to be install, and I gave it the wrong version and didn't renamed it to sql_jdbc.jar. I have since manually added the correct version of sdljdbc from the view module screen (but I'm not 100% if it's now installed correctly).

Any help would be appreciated.

Re: Connecting to local MS SQL

Prakhar1 — Wed, 10 Feb 2021 05:20:41 GMT

the value you have entered in "Login" , try to change it to only "Jhonny".

Re: Connecting to local MS SQL

JSey — Wed, 10 Feb 2021 07:16:47 GMT

Thanks for the suggestion, but unfortunately it didn't work. I still get login failed.

Re: Connecting to local MS SQL

JSey — Wed, 10 Feb 2021 07:22:02 GMT

On a hunch, I made my own user in MS SQL using MS SQL authentication, and that seems to have worked. I think if I wanted to use windows authentication, I probably need a different connection string or parameter.

Re: Connecting to local MS SQL

Prakhar1 — Wed, 10 Feb 2021 09:14:56 GMT

yes @Johnny Sey you are right, there are some parameters like "IntegratedSecurity" which we need to pass in the jdbc to authenticate using Windows Login.

Great you find a solution