ASP.NET Error when installing Knowledgebase on a Domain Controller

almost 14 years ago | Article no. 1896

0 ratings

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