Connecting to local MS SQL

[JSey]

Hi

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.

[Prakhar1]

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

[JSey]

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

[JSey]

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.

[Prakhar1]

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