I tryed Dbvizualizer and with this software, I can connect me with tcp port 1354.
But with geoportal, this error appear :
Cannot create PoolableConnectionFactory (�?chec de l'ouverture de session de l'utilisateur ''. L'utilisateur n'est pas associé à une connexion SQL Server approuvée.)
I use exactly the same user, password, database, driver ... I don't understand why it work with dbvizualizer but not SQL Server ...
I would strongly recommend you stick to a JDBC driver and JDBC url connection. Another tool to try (with the goal of getting the JDBC driver/url combination correct for your system) is DbVisualizer. It would allow you to choose a driver and quickly test different connection strings. Still, I think the primary focus needs to be determining which TCP port your SQLServer database machine is configured to accept outside connections.