Configure Jasper with SSL Encryption Enabled SQL Server

book

Article ID: 127977

calendar_today

Updated On:

Products

CLARITY PPM FOR ITG CLARITY PPM FEDERAL Clarity PPM SaaS - Application Clarity PPM On Premise

Issue/Introduction

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