[resolved] PB to etablish a connection with JDBC to mssql 2012

[mparmentier]

Hi everybody,
I'm using TOS 6.3 and I tried to connect a job to a database SQL Server 2012, but I can't it.
My composant tMssqlConnection, I post directly error, it's more simple.
I confirm to have an instance of SQL server 2012 that is running on my PC with IP protocol open.
Thanks for your attention
Regards
Type de propriete : Built-In
JDBC Provider : Microsoft
Hote : "192.168.111.1\\SQLSERVER_MPAR"
Schema : "dbo"
Database : "DATAWARE"
Utilisateur : "sa"
JDBC parameter supplementary  : ""
--
ERROR -----------------------------------------------------------
--
Démarrage du job CNX_SqlServer2012 a 19:30 30/12/2016.
connecting to socket on port 3441
connected
Exception in component tMSSqlConnection_2
com.microsoft.sqlserver.jdbc.SQLServerException: Échec de la connexion TCP/IP à l'hôte 192.168.111.1, 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:1962)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1627)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1458)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:772)
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 formationmpa_v6.cnx_sqlserver2012_0_1.CNX_SqlServer2012.tMSSqlConnection_2Process(CNX_SqlServer2012.java:496)
at formationmpa_v6.cnx_sqlserver2012_0_1.CNX_SqlServer2012.runJobInTOS(CNX_SqlServer2012.java:1140)
at formationmpa_v6.cnx_sqlserver2012_0_1.CNX_SqlServer2012.main(CNX_SqlServer2012.java:985)
disconnected
Job CNX_SqlServer2012 terminé à 19:31 30/12/2016.

[Anonymous · Accepted solution]

Input the IP address or host name in the Host field. Make sure an instance is running and you are able to ping to the server, execute the below command in a command terminal to check if you are able access oport 1433.
..>telnet  192.168.111.1 1433.

[mparmentier]

Hi Shong,
Good intuition, the return of Telnet cmd is :
Connexion à 192.168.111.1...Impossible d'ouvrir une connexion à l'hôte, sur le port 1433: Échec lors de la connexion
My "SQL Server" is on dynamic port 50259,   and on this port it's work fine.
Thanks a lot
Regards
PS : I don't know how I close this post.