Impossible to create a MSSQL Server connection using "Domain\Instance" Server name or alias TCP/IP

[ATrezzi1662395935]

Hi everyone,

we've TOS 8.01 with JDK 18 installed on server, and we're trying to create a connection with our MSSQL Server Database.

The point is that istance is "Domain\Instance" type and it does'nt work on Talend; so I've tried to create an alias with SQL Server Configuration manager (both tcp/ip, with or without 1433 port specified, and np type). Alias works correctly on ODBC and also on SQL Server Management Studio, but not in Talend.

I've tried with Open Source JDTS or with Microsoft type, but nothing.

It always says that it is not possible to found server name or that it requires further details.

Anyone could help us?

Regards

[Anonymous]

Hello,

On MSSQL each instance runs on separate port.

The string of connection looks like:

jdbc:jtds:sqlserver://server:1433;databaseName=BS_DW;instanceName=XXXX

Feel free to let us know if it helps.

With talend 8, JDK 11 is required.

Here is online installation guide about: TalendHelpCenter:Compatible Java Environments

Best regards

Sabrina

[ATrezzi1662395935]

Hi xdshi, thanks for the answer.

I've tried but seems not to work:

You think that I've to change port? How can I get the correct one?

[Anonymous]

Hello,

You are able to connect your MSSQL server successfully through the third tool without using talend?

Please try the connection string like:

jdbc:jtds:sqlserver://BS_HPZ240:1433;databaseName=BS_DW;instanceName=SVILUPPO2012

Best regards

Sabrina