My Java servlet connects to both an Oracle database (running on Unix) and a SQL Server database. We have a keystore set up successfully on the servlets' server with root, intermediate certificates etc that encrypt the connection to Oracle. The server team maintaining the server hosting the SQL Server database have supplied me with an SSL certificate. I am assuming it is a public key certificate.
I am trying to apply this certificate to encrypt the network traffic to the SQL Server database. I have attempted to import the certificate into the keystore mentioned above using the Java keytool but this does not work so I deleted the certificate from the keystore again. I found the URL below which I have followed to install the certificate through MMC but cannot find how to now force Tomcat to encrypt the network traffic.
Can someone please tell me what I am missing here please? There is loads of guidance on setting up keystores with root and intermediate certificates etc, but I cannot find any guidance on waht to do in Tomcat to use a single provided SSL certificate. Do I use the Java cacerts file and import the certificate in there?