Hi All,
Can any one suggest how to connect to SQL Server 2000 Database.
Using the Talend Version 6.1.1
When defining the Db Connections For Microsoft Sql Server 2000 Got Below Error
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:314)
at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:272)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:2674)
at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.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
----
The Sql Server that we are using is Personal Edition, also provided the Additional Parameters as instance=MSSQLSERVER.
Thanks & Regards
Syed
Hi, Are you able to connect to Microsoft SQL server 2000 successfully through client without using Talend Tool? Could you please upload your screenshot of DB connection in metadata into forum? Best regards Sabrina
I tried to Upload the image, its showing in the editor box and upload box but when i am trying to preview its not showing the image.
As the image is not uploaded i will copy the details that i have passed in the DB Connection.
DB Type : Microsoft SQL Server
String of Connection : jdbc:jtds:sqlserver://192.168.9.1:1433/AmnDb007;insatnce=MSSQLSERVER
Login : sa
Password : ****
Server : 192.168.9.1
Port : 1433
DataBase : AmnDb007
Schema :
Additional Parameters : insatnce=MSSQLSERVER
Above are the details that i have passed.
Hi, Is there a firewall blocking port 1433 on the server? Can you connect to your server successfully by using telnet 192.168.9.1 1433? Best regards Sabrina
