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?
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)