When opening the Process Overview report in K2 Workspace, the following error appears:
Service: K2GenericSettings Service Guid: f832fc2c-55eb-4635-8837-61879cb1feff Severity: Information Error Message: Cannot open database "K2" requested by the login. The login failed. Login failed for user 'sa'. InnerException Message: at SourceCode.Workspace.OOBReports.K2ReportSettingsHelper.GetReportConfigString(String reportID) at SourceCode.Workspace.OOBReports.K2ReportSettingsHelper.LoadReportConfigEventArgs(String reportID) at SourceCode.Workspace.OOBReports.K2ReportViewer.LoadReportConfig(Boolean mustSetValue, Boolean isDrillThrough, LocalReport localReport)
To resolve the issue, please follow these steps:
1. Open the SmartObject Service Tester and go to ServiceObject Explorer > K2 Generic Settings Service.
2. Right-click on the 'K2 Generic Settings Service' instance and choose 'Edit Service Instance'.
3. In the ConnectionString key, ensure that the Data Source is pointing to the correct SQL server name.