Enabling JasperReport and MSSQL Enforce Encryption communication

Document ID:  TEC1415209
Last Modified Date:  06/08/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Identity Manager

Releases

  • CA Identity Manager:Release:12.6.6
  • CA Identity Manager:Release:12.6.7
  • CA Identity Manager:Release:12.6.8

Components

  • IdentityMinder(Identity Manager):IDMGR
Introduction:

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.

Instructions:

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 

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >