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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Forteen 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
Rilhia Solutions
2 REPLIES
Highlighted
Forteen 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
Rilhia Solutions
Seven Stars

Re: Cannot connect to MS SQL Server

Thanks it worked!!