Talend unknown server host name connection with SQL Server

Question

I want to make talend metadata dbconnection with repository I have entered these as credentials

Login: sa
Password: ******
Server: Localhost\SQLEXPRESS
Port: 1433
Database: mydb
Additional Parameter: instance=SQLEXPRESS

but I get an error of unknown server host name localhost\sqlexpress, as I already connected to SQL Server Management Studio with these credentials.

Any suggestion would be appreciated.

Thanks

Possibly `Additional Parameter: instance=SQLEXPRESS` is redundant since you already have it in the Server parameter — Nick.Mc, May 16 '16 at 13:36
yes i have tried empty additional parameter but having same issue — Hassan Farooq, May 16 '16 at 13:46
@HassanFarooq hallo farooq, did you manage to solve this issue ? — cantona_7, May 12 '20 at 07:33

score 3 · Answer 1 · answered Feb 21 '17 at 13:42

3

I know this is old, but I've the same problem and solved it doing (using the connection used at the topic as example) this way:

Login: sa
Password: ******
Server: Localhost
Port: 1433
Database: mydb
Additional Parameter: instance=SQLEXPRESS

answered Feb 21 '17 at 13:42

rafaelrvital

31
3

score 0 · Answer 2 · answered May 16 '16 at 14:01

Unlike when using SQL Server Management Studio, MS SQL Connections in TOS Data Integration go through JDBC. So, the server (or host) must either be an IP address or a DNS address which resolves.

In your case, I believe use the tMSSqlConnection component and the host should just be "localhost".

https://help.talend.com/display/TalendOpenStudioComponentsReferenceGuide62EN/tMSSqlConnection

Talend unknown server host name connection with SQL Server

2 Answers2