Connection Issue to MSSQL with JDBC Provider "Microsoft"

Seven Stars

Connection Issue to MSSQL with JDBC Provider "Microsoft"

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

 

Tags (1)

Accepted Solutions

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

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

 

 

BR Bp


All Replies

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

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

Seven Stars

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

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"

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

 

 

BR Bp

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Downloads and Trials

Test drive Talend's enterprise products.

Downloads