Connection Issue to MSSQL with JDBC Provider "Microsoft"

[Fernandez]

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

[Anonymous]

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

[Fernandez]

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.

[Anonymous · Accepted solution]

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

BR Bp