topic Re: Impossible to create a MSSQL Server connection using "Domain\Instance" Server name or alias TCP/IP in Talend Studio

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

ATrezzi1662395935 — Fri, 15 Nov 2024 22:35:20 GMT

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

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

Anonymous — Tue, 06 Sep 2022 09:03:13 GMT

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

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

ATrezzi1662395935 — Tue, 06 Sep 2022 09:12:31 GMT

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?

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

Anonymous — Wed, 07 Sep 2022 02:09:42 GMT

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