Cannot connect to MS SQL Server

[Anonymous]

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

[Anonymous · Accepted solution]

Try adding .....

instance=EDGEPASTEL2016

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

EDGEPASTEL

[Anonymous]

Thanks it worked!!