Cannot connect to MS SQL Server

Seven Stars

Cannot connect to MS SQL Server

Hi

 

I cannot connect to a Microsoft SQL Server. Using tMSSqlInput I get the following error:

 

Exception in component tMSSqlInput_1
java.sql.SQLException: Unknown server host name 'EDGEPASTEL\EDGEPASTEL2016'.
at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:427)

How can I resolve this?

 

Thanks


Accepted Solutions
Community Manager

Re: Cannot connect to MS SQL Server

Try adding .....

 

instance=EDGEPASTEL2016

....to your additional JDBC Parameters on the Advanced settings tab. Leave your host as ....

EDGEPASTEL

All Replies
Community Manager

Re: Cannot connect to MS SQL Server

Try adding .....

 

instance=EDGEPASTEL2016

....to your additional JDBC Parameters on the Advanced settings tab. Leave your host as ....

EDGEPASTEL
Seven Stars

Re: Cannot connect to MS SQL Server

Thanks it worked!!

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download