topic Re: Connection Error For Microsoft SQL Server 2000 in Installing and Upgrading

Connection Error For Microsoft SQL Server 2000

Syed4 — Sat, 16 Nov 2024 10:43:07 GMT

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

Re: Connection Error For Microsoft SQL Server 2000

Anonymous — Thu, 31 Mar 2016 07:12:33 GMT

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

Re: Connection Error For Microsoft SQL Server 2000

Syed4 — Thu, 31 Mar 2016 19:47:55 GMT

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.

Re: Connection Error For Microsoft SQL Server 2000

Anonymous — Fri, 01 Apr 2016 07:54:13 GMT

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

Re: Connection Error For Microsoft SQL Server 2000

Syed4 — Sat, 02 Apr 2016 10:37:57 GMT

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

Re: Connection Error For Microsoft SQL Server 2000

Anonymous — Tue, 05 Apr 2016 09:35:46 GMT

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