Symptoms

"Cannot open database K2] requested by the login. The login failed. Login failed for user K2ServiceAccount]"
 

Diagnoses

We checked for errors relating to this issue on the following locations:

- HostServer logs
- Event viewer logs

The same error was logged in the above two locations. Additionally, we noticed that on event viewer this error is logged: "10702 An error occurred in the SharePointIntegration service instance. Cannot open database eK2] requested by the login. The login failed. "

Going through the closed tickets pointed out that this is due to K2 configuration not updating K2HostServer.exe.config database connection string.
 

Resolution

We used Decryption tool to decrypt database connection string and updated the values manually - see steps below:

- Copy Decryption.exe tool to HostServer/Bin directory
- Stop K2 HostServer service
- Run the tool
- It will create a backup of K2HostServer.exe.config file. The file will be something like K2HostServer.exe.config30234223
- Rename the original file.
- Edit the created backup file and update connection strings values.
- Save, then rename it to K2HostServer.exe.config
- Start K2HostServer service

Alternatively, the following steps can be followed:

- Copy the K2HostServer.exe.config file from the C:Program Files (x86)K2 blackpearlHost Serverin folder to C:Temp and rename it web.config.

- Open a command prompt and change the directory to C:WindowsMicrosoft.NETFrameworkv2.0.5727 and run the following command:
aspnet_regiis -pdf "connectionStrings" C:Temp

This decrypts the connection string section in the file.

- Update the Connection Strings
- Rename the file back to K2HostServer.exe.config and copy it back into the Host Server/bin directory (after renaming the current running configuration to K2HostServer.exe.config_old to prevent it from being overwritten)
- Restart the K2 service