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

View solution in original post


All Replies
Highlighted

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

View solution in original post

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 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog