2423626 - Error: 'Failed to retrieve cluster name from the database. Reason SAP BusinessObjects Bi Platform CMS: Unable to connect to the CMS system database "XXXX". Reason [Microsoft][ODBC SQL Driver][SQL Server]Login failed for user 'DUMMYTRUSTEDUSER', when changing cluster key.

Symptom

Cannot change the cluster key.
Getting the following error message in Central Configuration Manager: "Failed to retrieve cluster name from the database. Reason SAP BusinessObjects Bi Platform CMS: Unable to connect to the CMS system database "XXXX". Reason [Microsoft][ODBC SQL Driver][SQL Server]Login failed for user 'DUMMYTRUSTEDUSER'.."

Cluster error.png

Event Viewer log shows following: "Server Intelligence Agent: CMS XXXX.Central Management has failed and Server Intelligence Agent has not been able to connect to the cluster. Please verify CMS port and Database settings are correct."

Event Log.png

Environment

SAP BusinessObjects Business Intelligence Platform 4.x
SQL Server 2008,2012,2014
Windows Server 2008/2012

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2 ; SAP Crystal Server 2011 ; SAP Crystal Server 2013 ; SAP Crystal Server 2016

Keywords

cluster key error, DUMMYTRUSTEDUSER, cluster change 4.x, Failed to retrieve cluster name from the database , KBA , cluster key , dummytrusteduser , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , BI-BIP-CCM , Central Configuration Manager , 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.