Set MS SQL Connection

One Star

Set MS SQL Connection

Hello!
I´m new in TOS Data Integration.
I want to read data from an MS SQL Database and write it to an MYSQL Database.
The connect to the MS SQL doesn´t work.
tMSSqlConnection_1:
Host "192.168.34.5"
Port "1433"
Schema "dbo"
Database "demo"
User and Passwort are correct
I can connect with other SQL Programm´s with the given User. But at the other Programms I choose the Instance of the SQL Server.
In TOS I doesn´t find the Instance.
The Instance of my database is "demo_net"
If I connect:
connecting to socket on port 4082
connected
Exception in component tMSSqlConnection_1
java.sql.SQLException: Network error IOException: Connection refused: connect
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:410)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at kontor_crm.kontorvtiger_0_1.KontorVtiger.tMSSqlConnection_1Process(KontorVtiger.java:357)
at kontor_crm.kontorvtiger_0_1.KontorVtiger.runJobInTOS(KontorVtiger.java:1067)
at kontor_crm.kontorvtiger_0_1.KontorVtiger.main(KontorVtiger.java:932)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(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 sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:307)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:257)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:311)
... 7 more
How I can connect or did I miss a local file?
One Star

Re: Set MS SQL Connection

Ok, found the answer now:
Additional parameter:
"instance=demo_net"
Moderator

Re: Set MS SQL Connection

Hi,
Thanks for posting your issue here. You can click F1 to get component reference in studio or navigate to online component reference TalendHelpCenter:tMSSqlConnection.
Let me know if there is any further help we can give.
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.