Connection Issue to MSSQL with JDBC Provider "Microsoft"

Fernandez — Fri, 09 Mar 2018 11:34:58 GMT

Hi,

When I try to connect to a database MSSQLSERVER with the JDBC Provider "JTDS open source", it's running fine.

But when I try to connect to a database MSSQLSERVER with the JDBC Provider "Microsoft", I get this error:

Exception in component tMSSqlConnection_1 (Test)
com.microsoft.sqlserver.jdbc.SQLServerException: Échec de la connexion TCP/IP à l'hôte FRNETDB01B, port 1433. Erreur : « Connection refused: no further information. Vérifiez les propriétés de connexion. Assurez-vous qu'une instance de SQL Server est en cours d'exécution sur l'hôte et accepte les connexions TCP/IP au port. Vérifiez que les connexions TCP au port ne sont pas bloquées par un pare-feu. ».
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:191)
at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:242)
at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2369)
at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:551)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1963)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1628)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1459)
[statistics] disconnected
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:773)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1168)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at lcl.test_0_1.Test.tMSSqlConnection_1Process(Test.java:352)
at lcl.test_0_1.Test.runJobInTOS(Test.java:629)

Do you know why ?

Thanks

Re: Connection Issue to MSSQL with JDBC Provider "Microsoft"

Anonymous — Fri, 09 Mar 2018 15:41:21 GMT

Hi Fernandez,

without seeing your different configurations it would be a guessing game.

Show us the different settings.

Do you try from the same source ?

BR Bp

Re: Connection Issue to MSSQL with JDBC Provider "Microsoft"

Fernandez — Fri, 09 Mar 2018 15:57:24 GMT

Hi,

Same configuration in the both cases:

host : "myHost"
port : ""
schema : ""
database : "myBase"
user : "myUser"
password : "myPassword"
JDBC parameters: "instance=myInstance"

I'm trying from the same source.

Re: Connection Issue to MSSQL with JDBC Provider "Microsoft"

Anonymous — Fri, 09 Mar 2018 16:02:55 GMT

Try to set the correct Port or make sure your MSSQL DB you want to reach listen on port 1433 (see exception)!

BR Bp

topic Re: Connection Issue to MSSQL with JDBC Provider "Microsoft" in Talend Studio

Connection Issue to MSSQL with JDBC Provider "Microsoft"

Re: Connection Issue to MSSQL with JDBC Provider "Microsoft"

Re: Connection Issue to MSSQL with JDBC Provider "Microsoft"

Re: Connection Issue to MSSQL with JDBC Provider "Microsoft"