Unable to connect to Ms SQL Server

Highlighted
One Star

Unable to connect to Ms SQL Server

I have spent two days trying to connect to Ms SQL  ,using SQL 2012 but I have check that  Talend is still supporting SQL Server 2012 but after putting the required settings still getting :






















      ... 9 more      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:186)      at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)      at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)      at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:371)      at net.sourceforge.jtds.jdbc.TdsCore.login(TdsCore.java:632)      at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)      at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)      at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:372)  Caused by: java.sql.SQLException: Login failed for user 'STEVENMURHLA\steven'.      at java.lang.Thread.run(Unknown Source)      at java.util.concurrent.FutureTask.run(Unknown Source)      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$46.runWithCancel(DatabaseForm.java:1)      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$46.runWithCancel(DatabaseForm.java:3173)      at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:289)      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)      at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1089)      at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)  java.lang.RuntimeException: java.sql.SQLException: Login failed for user 'STEVENMURHLA\steven'.Connection failure. You must change the Database Settings.
Four Stars

Re: Unable to connect to Ms SQL Server

Have you confirmed that the user/pass you are using works?  Have you been able to use that user/pass combination to log in from outside of Talend?

I ask because of this:

java.sql.SQLException: Login failed for user 'STEVENMURHLA\steven'.Connection failure. You must change the Database Settings.


If I saw that error, the first thing I would do is try to log in with a SQL tool (SQL Workbench or something) so I could confirm that it's a Talend problem and not a DB-side thing.  

If the connection worked outside of Talend, I would next compare my configuration for the Talend component to the configuration in my SQL tool to make absolutely certain that I didn't misconfigure. 

If I still had issues, my next stop would be to ensure Talend has the right driver for SQL Server 2012 (I'm not sure if you have to manually provide it for SQL Server or not, but for some DB types you do, and the problem might be that you grabbed the wrong one or something).

If I went through all that and still had issues, well, I'd probably be posting on this forum too, haha.  Good luck!

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read