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

Document ID : KB000049582
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

"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)

    Figure 1

Solution:

Resolution Steps:

A:
In CMC :

GoTo:

  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)

Figure 2

Figure 3

B:
In the Universe Designer

GoTo:

  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)

    Figure 4

C:
On the Client Machine where Crystal Reports is installed

GoTo:

  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.