ASP.NET Error when installing Knowledgebase on a Domain Controller

THIS ARTICLE APPLIES TO:

All versions of Knowledgebase.

ISSUE DESCRIPTION:

Unable to add Knowledgebases to the system.

ROOT CAUSE:

ASP.NET Error when installing Knowledgebase on Domain Controller.

SOLUTION OR WORK AROUND:

The minimal set of permissions for the ICM user after installation in SQL Server 2005 is the following:  

  • Read and write permissions on the ICM database (db_datareader and db_datawriter roles).
  • Server permission "VIEW SERVER STATE" (this is required to query the "sysprocesses" dynamic management view.

Be sure to add Server permission "VIEW SERVER STATE" to resolve this issue.

      Specifically:  
            No need for server roles (e.g., no sysadmin)
            No need for explicit read or write permissions on database "master" (no db_datareader and db_datawriter roles)
            No need for db_owner or db_securityadmin roles (or any other roles except reader+writer) on the ICM database

ICM only accesses the "sysprocesses" dynamic management view in the master database (and this view is of course read-only)

AFFECTED SYSTEMS & USERS:

Administrators

ADDITIONAL INFORMATION:

ESCALATION PROCEDURE:

If you continue to encounter this issue after performing these steps, please contact our Support group at 877-373-7848 or via email at cimsupport@moxiesoft.com