MSSQL connection fails after update project to 6.5.5

After update my projecto to version 6.5.5 the connection to database fails.
"
[15:38:00.813] Connection failed
The TCP/IP connection to the host 192.168.1.6, port 1433 has failed. Error: “Connection refused: no further information. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”."
In version 6.4.5 the same configuration works fine.

Regards.

In 6.5, the native Microsoft JDBC driver is used instead of jTDS. Please make sure that connection URL in context.xml is in the following format: jdbc:sqlserver://host;databaseName=sample

Studio does this conversion automatically upon migration.

Hi Konstantin,
The connection fails persist please check my configuration. before de upgrade is running well. after migration the connection always fails.
Capturar
Regards.
João Gomes

Could you provide more details? At least an exception stack trace.

[08:03:27.460] Database server connection error
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 192.0.10.4, port 1433 has failed. Error: “Connection refused: no further information. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”.
[08:03:27.903] Ready

Please provide context.xml content from version 6.4 (with jTDS) and from the latest version (with MS JDBC driver). Just don’t forget to remove user name and password.

Hi Konstantin, now I understand the problem, in JDBC the parameter instance should be changed for instanceName.
CapturarNewConfig.

In context help the information is to use ;instance.help.

Thanks for your help.
Regards.
João Gomes

Hi João,
Thank you for posting the solution. We’ll make a correction in the help.