This chapter describes the client connectivity to Querona.
Querona emulates Microsoft SQL Server. Therefore client connectivity works using drivers built-into the client.
To be able to connect you have to know the Querona server name and port that was configured for data access.
Information about the server and port is available from the dashboard, section “Interfaces” or it can be read from dashboard section “How to connect data tool to Querona.” Port 1433 is a default port for connectivity, and it can be omitted in a client connection dialog of your tool. For more information, please refer to the section below and your tool documentation.
Here is the list of popular client software along with instructions on how to connect them to Querona:
Configure the client to use Strict connection encryption#
If Querona is configred to require Strict connection encryption, all clients have to support it, or connection will be refused by Querona.
If you see SSL certificate validation failed, validate that:
Server certificate is valid on the machine you’re using for testing
At least one of the following is true:
Provider SQL Server matches CA name or one of the DNS names in the certificate.
HostNameInCertificate connection string property matches CA name or one of the DNS names in the certificate.
To configure the Microsoft JDBC driver see Connecting with encryption.