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

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.

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

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