Skip to Content
author's profile photo Former Member
Former Member

Logon Failed when Crystal report connect to Universe

Hi

When i create a crystal report base on an universe and come across an error message: logon failed;

on database expert, i connect to BOE with Administrator crenditial then go through the available universe; after selected one universe, i drag necessary object into result object pane; when i click the OK button, pop up the error message "logon failed" .

crystal report version : 2008 SP5

BOE version : XI3.1 SP5

your quickly reponse would be highly appreciated.

thanks in advance!

Dragon

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    Posted on Aug 01, 2012 at 05:13 PM

    Hi Dragon,

    The DB connection is now going through your local PC so you need to install the DB Client and configure it to use the same type of connection as when it was published to BOE.

    Once Open then you can set Location to the DB Server and it should all work now.

    Thank you

    Don

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2012 at 07:04 PM

    Hi Dragon,

    I totally agree with Don.

    Well your Crystal Reports is trying to search the same Database Configuration that you have done for Universe. If your Universe is based in Oracle database and its using Oracle Client connection, then on your machine where we have Crystal Reports Designer we should have the Oracle Client installed along with same TNS entry configured, as it is configured on the Enterprise Server.

    So I would suggest you open your Universe in Universe Designer and check the database configuration using File -> Parameter and do the exact database configuration on your local machine where Crystal Reports is installed and from where you are trying to create Crystal Report based of Universe.

    You can also have a look at this forum post, it might help you:

    http://scn.sap.com/thread/935821

    Hope this would help 😊.

    - Kuldeep

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 02, 2012 at 03:11 PM

    Hi Don & Kuldeep

    Thanks for your advice for this!

    it's very help information and i will configure DB client on my local PC.

    Dragon

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.