Symptoms
I need to change the URLs of the SP group providers to match the new SSL addresses. When I edit them in K2 Workspace, I get an error Cannot open database "K2HostServer requested by login. The login failed for DomainBob. I checked that user and it does not have any permissions to K2HostServer database. Should it? If so, what access is required?
Diagnoses
Insufficient user privileges in the Database.
Resolution
In SQL management studio, edit the login for DomainBob.
Map to the K2 database and add the following role memberships:
- db_datareader
- db_datawriter
- db_owner
- public