From Thursday, July, 9, 3:00 PM Pacific,
our Community site will be in
read-only mode
through Sunday, July 12th.
Thank you for your patience.

Connection Issue to MSSQL with JDBC Provider "Microsoft"

Highlighted
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
Highlighted

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

Highlighted
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.

 

Highlighted

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 GARTNER 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

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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog