Hi @johnw66,

Yes, you could change the password by going to Crystal Server Application Directory and reflecting the changes in the ifs-crystal-config.xml file.
C:\inetpub\wwwroot\<YOUR_CRYSTAL_INSTANCE>\ifs-crystal-config.xml

<?xml version="1.0" encoding="utf-8"?>
<CRYSTAL_REPORT>
  <DB_USER>ifssys</DB_USER>
  <DB_PASSWORD>YOUR_ENCRYPTED_IFSSYS_PASSWORD_HERE</DB_PASSWORD>
  <PRINT_USER>IFSPRINT</PRINT_USER>
  <PRINT_PASSWORD>YOUR_ENCRYPTED_IFSPRINT_PASSWORD_HERE</PRINT_PASSWORD>
  <ORACLE_TNS>YOUR_TNS_NAME_HERE</ORACLE_TNS>
  <APP_OWNER>IFSAPP</APP_OWNER>
  <IAL_OWNER>IFSINFO</IAL_OWNER>
  <FAILOVER_RETRIES>10</FAILOVER_RETRIES>
  <LOGS>FALSE</LOGS>
  <LOG_LEVEL>HIGH</LOG_LEVEL>
  <LOG_FILE_NAME>C:\inetpub\wwwroot\IFSCRWebSetup\logs\IFSCRWebSetup_logs.log</LOG_FILE_NAME>
</CRYSTAL_REPORT>

You can get the encrypted passwords from the configuration.xml file inside <YOUR_IFS_HOME>\instance\<YOUR_INSTANCE_NAME>\
YOUR_ENCRYPTED_IFSSYS_PASSWORD_HERE = <ifs.system.password.encrypted>
YOUR_ENCRYPTED_IFSPRINT_PASSWORD_HERE = <ifs.ifsprint.password.encrypted>

Cheers !
Dhananjaya.

@dhlelk 

I changed the passwords using the method you suggested and this hasn’t resolved the issued.

Details:  sDatabase Vendor Code: 28000 ]   at CrystalDecisions.ReportAppServer.Controllers.DatabaseControllerClass.SetTableLocation(ISCRTable CurTable, ISCRTable NewTable)
   at CrystalDecisions.CrystalReports.Engine.Table.set_Location(String value)
   at Ifs_ReportService.SetDatabaseLocation(String databaseLocation, Table table) in c:\inetpub\wwwroot\IFSCRWebSetup_IFSR\App_Code\Service.cs:line 1409
   at Ifs_ReportService.SetTableLocation(Table crTable, String UserId, String AppOwner, String IALOwner) in c:\inetpub\wwwroot\IFSCRWebSetup_IFSR\App_Code\Service.cs:line 1386
   at Ifs_ReportService.LoadInfoServiceReport(String path, String DBUser, String DBPassword, String DBServerName, String AppOwner) in c:\inetpub\wwwroot\IFSCRWebSetup_IFSR\App_Code\Service.cs:line 1204
3/24/2021 12:01:42 PM2IFSCRWebSetup_IFSR]-eDecryptPassword] Decrypting Password : CgQIsyLijtE7ndiG9mYG5MCTnRIKuHVs+b6D
3/24/2021 12:01:42 PM2IFSCRWebSetup_IFSR]-eGetDbInfoFromXml] Decrypted.
3/24/2021 12:01:42 PM2IFSCRWebSetup_IFSR]-eDecryptPassword] Decrypting Password : CgQI1bJRhoi8QqKK+2ObReIU12HKIOA1Xlqk
3/24/2021 12:01:42 PM2IFSCRWebSetup_IFSR]-eGetDbInfoFromXml] Decrypted.
3/24/2021 12:01:42 PM2IFSCRWebSetup_IFSR]-eGetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSRPDB AppOwner-IFSAPP IALOwner-IFSINFO
3/24/2021 12:01:42 PM2IFSCRWebSetup_IFSR]-eGetSavedPDFReport] Exporting the report in PDF format.
3/24/2021 12:01:42 PM2IFSCRWebSetup_IFSR]-eGetSavedPDFReport] File Name : TM_Sales_Quotation_04.rpt
3/24/2021 12:01:42 PM2IFSCRWebSetup_IFSR]-eGetSavedPDFReport] ParameterValues : 94728.0 ,LangCode = gb
3/24/2021 12:01:42 PM2IFSCRWebSetup_IFSR]-ebase64Encode] for 94728
3/24/2021 12:01:42 PM2IFSCRWebSetup_IFSR]-ebase64Encode] Encoded value : OTQ3Mjg=
3/24/2021 12:01:42 PM2IFSCRWebSetup_IFSR]-ebase64Decode] for OTQ3Mjg=
3/24/2021 12:01:42 PM2IFSCRWebSetup_IFSR]-ebase64Decode] Decoded to 94728
3/24/2021 12:01:42 PM2IFSCRWebSetup_IFSR]-eOpenReport] File Name : gb\TM_Sales_Quotation_04.rpt
3/24/2021 12:01:42 PM2IFSCRWebSetup_IFSR]-eGetAppSetting] Get the value for OpenReportPath from Web.config.
3/24/2021 12:01:42 PM2IFSCRWebSetup_IFSR]-eOpenReport] The file F:\IFS\IFSCrystal\IFSR\gb\TM_Sales_Quotation_04.rpt is found
3/24/2021 12:01:42 PM2IFSCRWebSetup_IFSR]-eGetAppSetting] Get the value for OpenReportPath from Web.config.
3/24/2021 12:01:42 PM2IFSCRWebSetup_IFSR]-eLoadInfoServiceReport] Loading infoServe report : F:\IFS\IFSCrystal\IFSR\gb\TM_Sales_Quotation_04.rpt
3/24/2021 12:01:42 PM2IFSCRWebSetup_IFSR]-eLoadInfoServiceReport] DBUser = IFSPRINT ,DBPassword : ******* ,DBServerName : IFSRPDB ,AppOwner : IFSAPP
3/24/2021 12:01:42 PM2IFSCRWebSetup_IFSR]-eLoadInfoServiceReport] Setting up logon information for each database object.
3/24/2021 12:01:42 PM2IFSCRWebSetup_IFSR]-eSetTableLocation] Set appropriate post-fixes for ORDER_QUOTATION_REP
3/24/2021 12:01:42 PM2IFSCRWebSetup_IFSR]-eSetDatabaseLocation] Generating fully qualified database object name for ORDER_QUOTATION_REP
3/24/2021 12:01:42 PM2IFSCRWebSetup_IFSR]-ERROR in FLoadInfoServiceReport] Error in loading infoServices report.
3/24/2021 12:01:42 PM2IFSCRWebSetup_IFSR]-Logon failed.
Details:  rDatabase Vendor Code: 28000 ] Logon failed.
Details:  bDatabase Vendor Code: 28000 ] Error in File TM_Sales_Quotation_04 3208_29212_{E117B3DF-110A-45CB-9640-E823DE52C6FB}.rpt:
Unable to connect: incorrect log on parameters.

Any ideas?

John

Alternatively, you can run IFS reconfiguration as this will generate anew CWS build ZIP file.  You can extract the new ifs-crystal-config.xml and replace the current one. You need to restart IIS Application to pick the new configuration.

Hi @johnw66,

Could you check if the System Parameters are updated to reflect the TEST Crystal Server Application Directory?

Cheers !
Dhananjaya.

Best approach is to change the ifssys password in the reconfiguration screen so that it can reflect with the database. then get the crystal zip file and reinstall CR web server. that way, it will point the CR config file to correct database and correct credentils to  IFSPRINT and IFSSYS as well.

@dhlelk It turns out one of the passwords was incorrect.

We copied Live to Test as mentioned.  And changed the passwords.

Although I used the configuration.xml and copied / paste the encrypted passwords AND re-started IIS, on attempting to log into the database using the passwords I had 1 worked and one didn’t, once the IFSPRINT password was reset and unlocked Crystal Reports started working displaying data.

When attempting to resolve the issue earlier I unlocked IFSPRINT and set it to the password I had noted which was incorrect.  

Thank you so much for your help.

p.s. prior to requesting help I had already updated the System Parameters as they were pointing to the wrong server and crystal web service.

Regards

John

Hi @johnw66,

You are welcome and I'm happy to help

Cheers !
Dhananjaya.