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
Highlighted
Sixteen Stars

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
Highlighted
Sixteen Stars

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!!