Configure Jasper with SSL Encryption Enabled SQL Server

Document ID : KB000127977
Last Modified Date : 26/02/2019
Show Technical Document Details
Issue:
This article describes the steps to configure Jaspersoft Server with SSL Encryption enabled SQL Server. 
Environment:
Jaspersoft Server 7.1
Resolution:
1. Gather root, intermediate and server certificates of your encryption enabled SQL Server instance.
2. Navigate to $JDK_HOME/jre/lib/security where we find the default Java keystore named cacerts.
3. Import the certificates gathered in step 1 to cacerts keystore. Following is a generic example.
    keytool -importcert -file certificate_path -keystore cacerts -alias alias_name_of_certificate -trustcacerts
4. Stop Jaspersoft server tomcat.
5. Navigate to $JASPER_TOMCATHOME/webapps/reportservice/META-INF and make a copy of context.xml file.
6. Edit context.xml and change JDBC url as shown in the following example.
    <Resource name="jdbc/jasperserver" > is the tag which contains connection information of Jasperserver database.
     Change
     url="jdbc:sqlserver://hostname:1433;databaseName=ppm_jaspersoft;SelectMethod=cursor;sendTimestampEscapeAsString=false"
     To                                 
     url="jdbc:sqlserver://hostname:1433;databaseName=ppm_jaspersoft;SelectMethod=cursor;sendTimestampEscapeAsString=false;
     encrypt=true;trustServerCertificate=false;trustStore=$JDK_HOME\jre\lib\security\cacerts;trustStorePassword=changeit".

7. Save context.xml and Start Jaspersoft server tomcat. 

 
Additional Information:
To learn how to configure Clarity PPM with SQL Server encryption use KB000113547
 

How to install TIBCO JasperReports® Server to a SSL Enabled SQL Server database