Hello All,
We're standing up Jasperreports Server (JRS) 6.1, using MS SQL Server as our database server.
I'd like to configure the database connectors (data sources in JRS) to use SSL between JRS and the SQL databases, but I can't seem to find documentation in the Jaspersoft Docs library. The JRS data sources interface in the UI doesn't expose this, so I'm quite sure there are beans to configure somewhere.
Can someone please point me in the right direction?
Thanks much.
Rich
1 Answer:
Posted on August 14, 2015 at 10:27am
For completeness:
The solution is really outside of Jaspersoft in that SSL encryption to the database is managed through the connectionUrl string that JRS users access via Data Sources.
The string to add is a permutation of ";encrypt=true;trustServerCertificate=true" (how you set these values will depend on the level of trust between JRS and the database).
Hopefully this will help others out.
