Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Good morning,
I have already seen a few people with issues connecting to SQL Server. I am running Talend 7.2.1 on a Windows machine and have an SQL Server v18.4 instance on the same machine. I have used Windows authentication for connection, and it works just fine on other software (e.g. dBeaver). Yet, I cannot connect with Talend.
I have done everything specified on previous questions on the topic:
- Activated the SQL Server instance, changed the TCP/IP to enabled after defining TCP Port 1433
- Downloaded JDBC Driver package and moved sqljdbc_auth.dll to System 32
- Defined integratedSecurity=true in Additional parameters
My connection looks like the attached image.
Is there something I am still missing? I have been going on it for a while now and can't seem to find out what goes wrong, as the instance itself is working fine. Thanks!