One Star

Connection Error For Microsoft SQL Server 2000

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
5 REPLIES
Moderator

Re: Connection Error For Microsoft SQL Server 2000

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Connection Error For Microsoft SQL Server 2000

Hi Sabrina,
Yes i am able to connect to Microsoft SQL Server 2000 through client without using Talend Tool.
Please Find the attachment as requested.
 
Moderator

Re: Connection Error For Microsoft SQL Server 2000

Hi,
Can you upload again the screenshots you wanted to show, please? For some reason it didn't make it to your post.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: Connection Error For Microsoft SQL Server 2000

Hi 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. 

Thanks & Regards
Syed
Moderator

Re: Connection Error For Microsoft SQL Server 2000

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.