We need to change the MSSQL user password for Jaspersoft 6.3. Is there any way that I can update the password through configuration files and not going through a re-install?
At the bottom of the post, you'll notice the answer section which has the solution, the only thing to add is to update the password in the default_master.properties to the new password in plain text as the first step. Here are the complete steps:
On Apache Tomcat the encryption of password can be easily achieved by following steps:
Go to your Jaspersoft Install files: $jasper_install\jasperreports-server-5.6.1-bin\buildomatic\default_master.properties
Enter the correct value for Jasper DB Password in plain text
change the encryption tag to true in default_master.properties.
This will give you the encrypted password in default_master.properties.
Replace that password with the plain text password in C:\Jaspersoft\jasperreports-server-6.3.0\apache-tomcat\webapps\jasperserver-pro\META-INF\context.xml.
Make sure the username and password in both the files(default_master.properties and context.xml) should be same. In case of an external db configuration, create an entry in the file: