Enabling JasperReport and MSSQL Enforce Encryption communication
search cancel

Enabling JasperReport and MSSQL Enforce Encryption communication


Article ID: 10503


Updated On:


CA Identity Manager CA Identity Governance CA Identity Portal CA Risk Analytics CA Secure Cloud SaaS - Arcot A-OK (WebFort) CLOUDMINDER ADVANCED AUTHENTICATION CA Secure Cloud SaaS - Advanced Authentication CA Secure Cloud SaaS - Identity Management CA Secure Cloud SaaS - Single Sign On


For performances it is assumed JasperReport Server and its Database Server are both installed on same machine.

However in environment where both are remote, it could be inquired to secure communication between JasperReport Server and its MSSQL Database by implementing SSL / Enforce Encryption.

JasperReport Server is based on Jaspersoft 6.2.0 Third-Party Software, CA Technologies provides following information only as guidance and it is recommended to involve Jaspersoft support for further details and troubles to implement this feature.


Release: CAIDMB99000-12.6.8-Identity Manager-B to B


A/ Enable MSSQL SSL for JasperReports 

To use the MSSQL Enforce Encryption option, the JDBC url for JasperReports needs to be edited 


1. Stop TomCat

2. Go to D:\Program Files\Tomcat 8.0\webapps\jasperserver-pro\META-INF 

3. Create a backup of context.xml 

4. Edit context.xml 

5. Look for the JDBC url for resource jdbc/jasperserve 

6. At the end of the url add ;EncryptionMethod=SSL;ValidateServerCertificate=false 

7. Save the file 

8. Turn on Enforce Encryption on the MS SQL Database 

9. Restart the SQL Instance 

10. Start Tomcat 


B/ Enable MSSQL SSL on Reports JDBC Data sources 

1. Edit the JDBC Data sources within the JasperReports Portal 

2. Logon to JasperReport using SuperUser 

3. Go to Data Sources -> View List 

You will see a list of data sources. 

4. Right click IMReportsDS and click on edit 

5. Click Test Connection on the bottom 

You should see an SSL error 

6. At the end of the url add ;EncryptionMethod=SSL;ValidateServerCertificate=false 

7. Click Test Connection 

8. Click Save twice