IBM Support

"An error occurred... Requested registry access is not allowed... ConnectionBusiness_SetSelectDb" when launching Controller, caused by incorrect Identity name

Troubleshooting


Problem

User launches Controller. User receives error message.

Symptom

Controller 10.2.x:http://www-01.ibm.com/support/docview.wss?uid=swg21680674&aid=1

An error occurred while trying to access the server

Details:


System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.ArgumentException: Requested registry access is not allowed.
at Microsoft.VisualBasic.ErrObject.Raise(Int32 Number, Object Source, Object Description, Object HelpFile, Object HelpContext)
at ControllerServerCommon.RaiseErrSrv.RaiseError(String sUser, Int32 lErrNo, String sErrSource, String sErrDesc, String sErrHelpFile, Int32 lErrHelpContext)
at FrServerB.LocalConnectionBusiness.SetSelectDb(String sGuid, String sUser, Boolean bSelectDb)
at FrServerB.ConnectionBusiness.SetSelectDb(String sGuid, String sUser, Boolean bSelectDb)
at Cognos.Controller.Proxy.CCRWS.ConnectionBusiness_SetSelectDb(String sGuid, String sUser, Boolean bSelectDb)
--- End of inner exception stack trace ---

Controller 10.3

Cause

There are several possible causes for this error.

  • TIP: See separate IBM Technote #1680674 for more examples.

This Technote specifically relates to the scenario where the cause is that the IIS Application Pool's "Process Model" is set to use the wrong "identity".

Resolving The Problem

Modify the relevant IIS application pool so that the “Identity” is set to “LocalSystem”.

Steps:

1. Inside IIS Manager, open the section 'Application Pools'

2. Locate the relevant application pool

  • TIP: This is the one that is running your ControllerServer virtual application

Controller 10.3 (or later):

By default, this is the one called ‘.NET v4.5’ (with a managed pipeline set to 'Integrated')

Controller 10.2.x:

By default, this is the one called ‘.NET v2.0’ (Integrated)'

3. Right-click on the relevant application pool (for example ‘.NET v4.5')) and choose 'Advanced Settings'


4. Modify the setting “Identity” to be “LocalSystem”:


[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.3;10.2.1;10.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
15 June 2018

UID

swg21691747