Symptoms

Trying to activate all features for a SharePoint site and getting an error
 

Diagnoses

I am currently trying to run the "Activate all K2 Features and K2 Configuration Settings" for a stage sharepoint site. I'm following the same steps I normally do (and have been successful with)

I select the site collection
check "Update settings for all sites in this site collection"
uncheck the "Add group provider for site collection"
Click on OK

I get the following error:

The operation has completed but with errors:

Error occurred trying to set required K2 database permissions for the Deployment Application PoolThe required database permissions could not be granted to the Deployment application pool account for K2 on server Name.Ensure that either the central administration application pool account or the logged on user has sufficient rights to do so.Please note that the required permission could already exist on the database but verification is not possible with the current user permissions.


 

Resolution

Grant the Sharepoint System Account dbo rigts to the K2 database. We remoted into the Central Adminstration server and ran the Activate All K2 Features from there. After performing these steps, we were able to successfully activate the K2 Features in the site.

The K2 Features activiation needs to exectue in the server where Central Admin is installed.

This are the right needed to successfully activate K2 for SharePoint:

1) K2 service account - db_owner and security_admin on K2 db, SharePoint config db, and SharePoint content db
2) Central Admin application pool account - same level of rights as K2 service account
3) Installation account (the one used to activate features) - db_security_admin on K2 db, and SharePoint config.

Make sure all WFE's hve the same K2 For sharepoint Version.