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)
   
   

   <Please see attached file for image>

   

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)

<Please see attached file for image>

<Please see attached file for image>

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)
   
   

   <Please see attached file for image>

   

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.

Release:
Component: PPMENV