Connection Issue to MSSQL with JDBC Provider "Microsoft"

Six 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

Six 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