Clarity: "Logon Failed" error when using Crystal Reports to access CA Clarity universe


Article ID: 49582


Updated On:


CA Identity Manager CA Identity Governance CA Identity Portal Clarity PPM SaaS Clarity PPM On Premise



"Logon Failed" error when using Crystal Reports to access CA Clarity universes for Business Objects Reporting with database as MS SQL Server.

Cause: This error can occur due to a mismatch in DSN names defined in the system and the service name defined for the universes in the BO Designer.

Steps to reproduce:

  1. Launch Crystal reports
  2. Click on a new blank report
  3. Database Expert Opens. Click on Create New Connection
  4. Click on Universes. Give the necessary credentials.
  5. CA Universes > CA Clarity > Select the universe wished to be accessed.
  6. Select any field from the tables listed . Click on OK.
  7. Error > Logon Failed (ref fig error)

    <Please see attached file for image>

    Figure 1


Resolution Steps:

In CMC :


  1. Universes > CA Universes> CA Clarity .

    1. Here you will see a list of universes

  2. Select the Universe to be accessed.

  3. Right Click on the Universe > Properties > Connections.

  4. It will show a connection name. In this case CA_Clarity (ref fig 1 and fig 2)

<Please see attached file for image>

Figure 2

<Please see attached file for image>

Figure 3

In the Universe Designer


  1. Tools > Connections
  2. Look for a connection named CA_Clarity or create one (This matches the name from group 1 steps. The connection name for the universe)
  3. If the connection exists , select the connection > Click on Edit else if creating new make a note of the Service Name used.
  4. Keep a note of The Service Name . In this case its "clarity" (ref fig 3)

    <Please see attached file for image>

    Figure 4

On the Client Machine where Crystal Reports is installed


  1. DataSources(ODBC)
  2. ODBC Data Administrator - GoTo System DSN
  3. ADD SQL Server - Click on Finish
  4. Create the DataSource to SQL Server with name "clarity". This matches the Service Name taken from the Universe Designer, connection name for the Universe.


Component: PPMENV


1558710098372000049582_sktwi1f5rjvs16rqx.gif get_app
1558710096549000049582_sktwi1f5rjvs16rqw.gif get_app
1558710094568000049582_sktwi1f5rjvs16rqv.gif get_app
1558710092474000049582_sktwi1f5rjvs16rqu.gif get_app