SAP Knowledge Base Article - Preview

1670457 - BI 4.x auditing error: No CMS is configured as an auditor

Symptom

When configuring  auditing section in Central Management Console (CMC) and enter below configuration

  • Connection Name:
  • Type:
  • User Name:
  • Password:

It throws the following error:  "No CMS is configured as an auditor"

  • Error in CMS logs:

|CMS_BI|(AuditDatabaseSubsystem_impl.cpp:218) DatabaseHolder - (AuditDB) - Caught retryable error with Code 262, Msg: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]CREATE TABLE permission denied in database 'BI_Auditing'..  Number of retryable errors on this connection is 1 (at AuditDatabaseSubsystem_impl.cpp:3918)

|cms_BI|Unable to load audit database subsystem: Database access error. Reason [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]CREATE TABLE permission denied in database 'BI_Auditing'.. Error creating Audit Event table.


Read more...

Environment

  • SAP BusinessObjects Business Intelligence 4.x
  • MS SQL Server as Auditing database
  • MS Windows Server Operating System

Product

SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Business Intelligence platform 4.3

Keywords

auditing BI, BOE, no cms, BI, 4.x, 4.2, 4.3, auditeen auditer, ADS, auditor, No CMS is configured as an auditor, ODBC, table, DSN, event, permission , KBA , BI-BIP-SRV , CMS / Auditing issues (excl. 3rd Party Authentication) , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.