MSSQL Connection Error

Anonymous — Thu, 05 Jan 2017 20:27:16 GMT

I started off with Talend 6.3 and was unable to connect to MSSQl I got the following error code:
Connection failure. You must change the Database Settings.
java.lang.RuntimeException: java.sql.SQLException: Network error IOException: Connection refused: connect
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:195)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataUtils.connect(ExtractMetaDataUtils.java:1089)
at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:315)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:289)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$46.runWithCancel(DatabaseForm.java:3173)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$46.runWithCancel(DatabaseForm.java:1)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Caused by: java.sql.SQLException: Network error IOException: Connection refused: connect
at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:436)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at org.talend.core.model.metadata.builder.database.DriverShim.connect(DriverShim.java:41)
at org.talend.core.model.metadata.builder.database.JDBCDriverLoader.getConnection(JDBCDriverLoader.java:186)
... 9 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.waitForConnect(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:288)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:251)
at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:331)
... 12 more
I have checked sql and it is up and running I was even able to establish a connection with the same SQL instance in Excel. I tried everything mentioned in talendforge and today I tried using 6.2.1 with no help. I still get the same error. Please assist

Re: MSSQL Connection Error

Anonymous — Fri, 06 Jan 2017 03:03:42 GMT

Hi,
What's your sql server version? Is your network Ok with you in your machine? Could you please show us your connection parameters(mask your sensitive data)? Did you create your DB connection in metadata?
Best regards
Sabrina

Re: MSSQL Connection Error

_AnonymousUser — Fri, 06 Jan 2017 05:22:16 GMT

What is Db Version in Database Connection Wizard of Talend 6.3?
If iam Select Microsoft , then connection is not establishing.
At the same time if i select Open Source JTDS,the connection establishing Successfully
But in both cases JOb is not Working

Re: MSSQL Connection Error

Anonymous — Fri, 06 Jan 2017 06:52:02 GMT

Hi,
Here is online document about: TalendHelpCenterupported systems databases and business applications by Talend components.
Best regards
Sabrina

Re: MSSQL Connection Error

Anonymous — Fri, 06 Jan 2017 13:37:30 GMT

Microsoft SQL Server Management Studio 11.0.2100.60
Microsoft Analysis Services Client Tools 11.0.2218.0
Microsoft Data Access Components (MDAC) 10.0.14393.0
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 9.11.14393.0
Nothing confidential it is an instance I have on my local machine and am trying to connect to talend 6.3 and 6.2.1 and have failed on both the occasions
Microsoft .NET Framework 4.0.30319.42000
Operating System 6.3.14393

topic MSSQL Connection Error in Talend Studio

MSSQL Connection Error

Re: MSSQL Connection Error

Re: MSSQL Connection Error

Re: MSSQL Connection Error

Re: MSSQL Connection Error