This step requires that the user logging in to SQL Server Management Studio has sufficient permissions to grant permissions to other user accounts.

Setting Database Permissions

The account running the K2 installation requires permissions on the SharePoint_AdminContent_[GUID ID] database. These permissions must be set before the installation is started and may be set automatically if the same K2 Service Account has already been used by the MOSS Installer.

To verify the permissions have been set, or if they need to be set the database can be found in the following location:

1. Open Microsoft SQL Server Management Studio
2. Open the node Databases  > SharePoint_AdminConent_[GUID]
3. Locate the Security > Users node > [domain] \ [K2 Service]
4. Verify the permissions for the [K2 Service] account
   1. If the permissions have not been set, then they must be set
   2. If they are set there is nothing further to do

While infrastructure changes are required by K2, each environment is different and has its peculiarities which must be taken into account. Modifying the infrastructure could have unforeseen results if the changes are not appropriately understood or managed. Given the broad spectrum of underlying infrastructure utilized, it is recommended that a panel or committee with appropriate skill in each area concerned be assembled to outline the underlying infrastructure changes and gauge the impact of the required changes.