Hi, we are just in the process of upgrading from v9 to v10, we have a number of test databases in v10, and running crystal reports from quick report navigator works ok except one database.
Operational reports are ok.
The password for IFSPRINT is correct and the account is not locked.
I see Chris Plant had this issue a year ago, but no resolution is posted, any help would be appreciated
looking at the CWS logs - Unable to connect: incorrect log on parameters.
where do I check the logon parameters? how do I change these?
4/20/2023 2:43:03 PM[IFSA10IT101]-[LoadReport] Loading report : F:\CrystalReports\WHLoadReport.rpt
4/20/2023 2:43:03 PM[IFSA10IT101]-[LoadReport] DBUser = IFSSYS ,DBPassword : ******* ,DBServerName : IFSA10IT1 ,AppOwner : IFSAPP
4/20/2023 2:43:03 PM[IFSA10IT101]-[LoadReport] Processing 7 parameters.
4/20/2023 2:43:03 PM[IFSA10IT101]-[SetTableLocation] Set appropriate post-fixes for JT_TASK_UIV_A
4/20/2023 2:43:03 PM[IFSA10IT101]-[SetDatabaseLocation] Generating fully qualified database object name for JT_TASK_UIV_A
4/20/2023 2:43:04 PM[IFSA10IT101]-ERROR in [ExportReportWithParametersAndlogonInfo] Error in exporting the report in rpt format.
4/20/2023 2:43:04 PM[IFSA10IT101]-Error in File WHLoadReport 2856_16352_{6EAB2D7A-CDB1-4818-9544-82C5E8077EC5}.rpt:
Unable to connect: incorrect log on parameters.
Details: [Database Vendor Code: 1017 ] 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\IFSA10IT101\App_Code\Service.cs:line 1410
at Ifs_ReportService.SetTableLocation(Table crTable, String UserId, String AppOwner, String IALOwner) in c:\inetpub\wwwroot\IFSA10IT101\App_Code\Service.cs:line 1382
at Ifs_ReportService.LoadReport(String path, String DBUser, String DBPassword, String DBServerName, String LogonInfoValues, String AppOwner, String IALOwner) in c:\inetpub\wwwroot\IFSA10IT101\App_Code\Service.cs:line 1285
at Ifs_ReportService.ExportReportWithParametersAndlogonInfo(String FileName, String WebUser, String SecuredReportRequired, String ParameterValues, String LogonInfoValues, String ExportType) in c:\inetpub\wwwroot\IFSA10IT101\App_Code\Service.cs:line 725