One Star

Set MS SQL Connection

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.
Host ""
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
Exception in component tMSSqlConnection_1
java.sql.SQLException: Network error IOException: Connection refused: connect
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(
at net.sourceforge.jtds.jdbc.Driver.connect(
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at kontor_crm.kontorvtiger_0_1.KontorVtiger.tMSSqlConnection_1Process(
at kontor_crm.kontorvtiger_0_1.KontorVtiger.runJobInTOS(
at kontor_crm.kontorvtiger_0_1.KontorVtiger.main(
Caused by: Connection refused: connect
at Method)
at Source)
at Source)
at Source)
at Source)
at Source)
at Source)
at 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(
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(
... 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:

Re: Set MS SQL Connection

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