https://community.qlik.com/t5/Talend-Studio/Cannot-connect-to-MS-SQL-Server/m-p/2328337#M97627 <P>Thanks it worked!!</P> Thu, 22 Mar 2018 17:34:07 GMT Anonymous 2018-03-22T17:34:07Z https://community.qlik.com/t5/Talend-Studio/Cannot-connect-to-MS-SQL-Server/m-p/2328335#M97625 <P>Hi</P><P>&nbsp;</P><P>I cannot connect to a Microsoft SQL Server. Using tMSSqlInput I get the following error:</P><P>&nbsp;</P><P><FONT color="#FF0000">Exception in component tMSSqlInput_1</FONT><BR /><FONT color="#FF0000">java.sql.SQLException: Unknown server host name 'EDGEPASTEL\EDGEPASTEL2016'.</FONT><BR /><FONT color="#FF0000">at net.sourceforge.jtds.jdbc.JtdsConnection.&lt;init&gt;(JtdsConnection.java:427)</FONT><BR /><BR /></P><P><FONT color="#000000">How can I resolve this?</FONT></P><P>&nbsp;</P><P><FONT color="#000000">Thanks</FONT></P> Sat, 16 Nov 2024 08:31:06 GMT https://community.qlik.com/t5/Talend-Studio/Cannot-connect-to-MS-SQL-Server/m-p/2328335#M97625 Anonymous 2024-11-16T08:31:06Z https://community.qlik.com/t5/Talend-Studio/Cannot-connect-to-MS-SQL-Server/m-p/2328336#M97626 <P>Try adding .....</P> <P>&nbsp;</P> <PRE>instance=<SPAN>EDGEPASTEL2016</SPAN></PRE> <P>....to your additional JDBC Parameters on the Advanced settings tab. Leave your host as ....</P> <PRE>EDGEPASTEL</PRE> Thu, 22 Mar 2018 15:43:38 GMT https://community.qlik.com/t5/Talend-Studio/Cannot-connect-to-MS-SQL-Server/m-p/2328336#M97626 Anonymous 2018-03-22T15:43:38Z https://community.qlik.com/t5/Talend-Studio/Cannot-connect-to-MS-SQL-Server/m-p/2328337#M97627 <P>Thanks it worked!!</P> Thu, 22 Mar 2018 17:34:07 GMT https://community.qlik.com/t5/Talend-Studio/Cannot-connect-to-MS-SQL-Server/m-p/2328337#M97627 Anonymous 2018-03-22T17:34:07Z