In order to change the login password for Crystal reports in ServiceDesk it is necessary to select the report under Crystal Reports, in Administration, then select Configure Report, and under General settings, select the password and change.
If you have a number of reports in ServiceDesk that use the same login and you change passwords on a regular basis, this can be a time consuming task each time a change is made.
Below is a SQL script that you can use to change the passwords. You will need to replace OLDPASSWORD with the password you wish to replace and NEWPASSWORD with the new password. Please test first on a test system and only apply after taking a full backup.
set tps_value = REPLACE(cast(tps_value as nvarchar(max))
where tps_name = 'CRYSTALCONFIG'
--End of script