Opening the Process Overview report in K2 Workspace returns a "Cannot open database 'K2' requested by the login. The login failed" error
kbt158326
PRODUCTIssue
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)
Symptoms
The error is coming from the 'K2 Generic Settings Service' service instance.Troubleshooting Steps
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.