Jaspersoft database server migration
search cancel

Jaspersoft database server migration


Article ID: 16788


Updated On:


CA Service Operations Insight (SOI)


Jasper 6.1

SOI 4.0 SP2

Moving existing Jasper DB to a new SQL Sever and need to setup existing Jasper to use the new SQL server.

Our DBA team is migrating all MS SQL 2008 R2 servers to 2012. Can you please provide me procedures or documentations on how to point Jaspersoft to a new database server?


Jasper 6.1SOI 4.0 SP2


1) Stop CA_JasperReports_Server(tomcat)

2) You need to edit \CA\SOI\Reports\jr\apache-tomcat-7.0.68\webapps\jasperserver-pro\META-INF\context.xml
In this file, you will see the url where the SQL server hostname located.

3) If the password had changes, you will need to use \CA\SOI\Reports\jr\ca_install\encryption_utility\encrypt.bat utility to encrypt a new password.

4) Start Stop CA_JasperReports_Server(tomcat)