When we copied our Live DB to Test DB the crystal web service stopped working due to incorrect password IFSSYS password.
Is there an easy way to change the Crystal Web Service password?
Would I need to remove and install the Crystal Web Service again?
Thank you.
Best answer by dhlelk
View original
+15
Hi
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.
I changed the passwords using the method you suggested and this hasn’t resolved the issued.
Details: [Database 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 PM[IFSCRWebSetup_IFSR]-[DecryptPassword] Decrypting Password : CgQIsyLijtE7ndiG9mYG5MCTnRIKuHVs+b6D
3/24/2021 12:01:42 PM[IFSCRWebSetup_IFSR]-[GetDbInfoFromXml] Decrypted.
3/24/2021 12:01:42 PM[IFSCRWebSetup_IFSR]-[DecryptPassword] Decrypting Password : CgQI1bJRhoi8QqKK+2ObReIU12HKIOA1Xlqk
3/24/2021 12:01:42 PM[IFSCRWebSetup_IFSR]-[GetDbInfoFromXml] Decrypted.
3/24/2021 12:01:42 PM[IFSCRWebSetup_IFSR]-[GetDbInfoFromXml] Retrieved Information from XML : DBUser-ifssys DBPassword-******* PrintUser-IFSPRINT PrintPassword-******* DBServerName-IFSRPDB AppOwner-IFSAPP IALOwner-IFSINFO
3/24/2021 12:01:42 PM[IFSCRWebSetup_IFSR]-[GetSavedPDFReport] Exporting the report in PDF format.
3/24/2021 12:01:42 PM[IFSCRWebSetup_IFSR]-[GetSavedPDFReport] File Name : TM_Sales_Quotation_04.rpt
3/24/2021 12:01:42 PM[IFSCRWebSetup_IFSR]-[GetSavedPDFReport] ParameterValues : 94728.0 ,LangCode = gb
3/24/2021 12:01:42 PM[IFSCRWebSetup_IFSR]-[base64Encode] for 94728
3/24/2021 12:01:42 PM[IFSCRWebSetup_IFSR]-[base64Encode] Encoded value : OTQ3Mjg=
3/24/2021 12:01:42 PM[IFSCRWebSetup_IFSR]-[base64Decode] for OTQ3Mjg=
3/24/2021 12:01:42 PM[IFSCRWebSetup_IFSR]-[base64Decode] Decoded to 94728
3/24/2021 12:01:42 PM[IFSCRWebSetup_IFSR]-[OpenReport] File Name : gb\TM_Sales_Quotation_04.rpt
3/24/2021 12:01:42 PM[IFSCRWebSetup_IFSR]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
3/24/2021 12:01:42 PM[IFSCRWebSetup_IFSR]-[OpenReport] The file F:\IFS\IFSCrystal\IFSR\gb\TM_Sales_Quotation_04.rpt is found
3/24/2021 12:01:42 PM[IFSCRWebSetup_IFSR]-[GetAppSetting] Get the value for OpenReportPath from Web.config.
3/24/2021 12:01:42 PM[IFSCRWebSetup_IFSR]-[LoadInfoServiceReport] Loading infoServe report : F:\IFS\IFSCrystal\IFSR\gb\TM_Sales_Quotation_04.rpt
3/24/2021 12:01:42 PM[IFSCRWebSetup_IFSR]-[LoadInfoServiceReport] DBUser = IFSPRINT ,DBPassword : ******* ,DBServerName : IFSRPDB ,AppOwner : IFSAPP
3/24/2021 12:01:42 PM[IFSCRWebSetup_IFSR]-[LoadInfoServiceReport] Setting up logon information for each database object.
3/24/2021 12:01:42 PM[IFSCRWebSetup_IFSR]-[SetTableLocation] Set appropriate post-fixes for ORDER_QUOTATION_REP
3/24/2021 12:01:42 PM[IFSCRWebSetup_IFSR]-[SetDatabaseLocation] Generating fully qualified database object name for ORDER_QUOTATION_REP
3/24/2021 12:01:42 PM[IFSCRWebSetup_IFSR]-ERROR in [LoadInfoServiceReport] Error in loading infoServices report.
3/24/2021 12:01:42 PM[IFSCRWebSetup_IFSR]-Logon failed.
Details: [Database Vendor Code: 28000 ] Logon failed.
Details: [Database 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
+18
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.
+15
Hi
Could you check if the System Parameters are updated to reflect the TEST Crystal Server Application Directory?
Cheers !
Dhananjaya.
+10
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.
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
+15
Hi
You are welcome and I'm happy to help 😊
Cheers !
Dhananjaya.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.