With the release of Geneious Prime 2026.0.2 we have upgraded the Microsoft SQL Server library we use for database connections in Shared Database. By default the connection to Microsoft SQL Server will now be encrypted and requires the server certificate to be signed by a trusted authority. If you have a self signed certificate or if the certificate can not be verified your connection may fail with an error message like bellow:
As a workaround you can specify a custom connection URL and add a parameter trustServerCertificate=true to the URL.
jdbc:sqlserver://[HOST]:[PORT];databaseName=[DATABASE NAME];trustServerCertificate=true;
replace HOST,PORT,DATABASE NAME in the above with your host, port and database name.
Note: This only affects customers connecting against Database Type = Microsoft SQL Server.
The new driver is compatible with SQL Server 2016, 2017, 2019, 2022, and 2025, as well as Azure SQL Database and Azure Synapse Analytics.
Reference : https://learn.microsoft.com/en-us/sql/connect/jdbc/microsoft-jdbc-driver-for-sql-server-support-matrix?view=sql-server-ver17
<hostname>\<instancename>. In this case you will need to add the instance name to the custom connection URLjdbc:sqlserver://ServerName\InstanceName;integratedSecurity=true;databaseName=dbName;trustServerCertificate=true;