In Business Objects XI receive message "Unable to connect: incorrect log on parameters. "

I am trying to load many Crystal Reports to a Business Ojects XI server.   All of these reports are based on the same SQL database.   When I load in some of them , and then look at Database Confiiguration sometimes the User Name is there and I just have to add in the password.   These reports run fine.   It seems for the ones I load where I have to add in both an id and password, when I run it I get an error message that says: Error in File ~tmp177c6db6bb83e00.rpt: Unable to connect: incorrect log on parameters.
What I don't understand is the reports that fail with the error message are based on the same database and are setup with the same login id and password as the ones that work.   How do I get them ALL to work?
ArkbyAsked:
Who is Participating?
 
meumaxConnect With a Mentor Commented:
You need to set the database user and passwords for all the reports in the Central Management Console. There's a trick to setting them up correctly so they keep working. Here's how.

1. Log onto the CMC
2. Browse to one of the reports through folders. Click on the title of the report
3. Click the Process tab, then click the Database on the sub menu
4. Type in the user name and password for the SQL database for all the data sources listed on the left hand side (there may be many if your report has sub reports in it)
5. Make sure "Use same database logon as when report is run" is selected and then click Update

Now to make this change permanent go to the Properties tab and

1. Click Refresh Options on the sub menu
2. Untick Default Database Logon Information
3. Click Update

It is critical to do this last step because if you don't do this, then the next time you save your Crystal report to InfoView, you will overwrite the default database user and password with blank and you'll need to enter the database logon details again.

Now repeat this process for all your reports

*tip* In Crystal Reports XI, there's a shortcut to getting to the CMC. Log onto your CMC using the Repository explorer. Browse to your report and right click it. Click "Manage Object" and it will pop up the relevant CMC area mentioned above so you can modify all the settings from within Crystal Reports.
0
 
mlmccCommented:
Do they all use the sme ddatabase connection?

mlmcc
0
 
ArkbyAuthor Commented:
Yes, they all use ODBC.  The only thing that could possibly be different is they all came from different sources.   I had to update them all to point our database, and in Crystal Reports they run fine.   It's just some of them won't run in BO.
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
mlmccCommented:
Same tables?

Do you use the same ODBC from Crystl?

Does the BO user have permissions to all tables?

mlmcc
0
 
ArkbyAuthor Commented:
No, not all the tables are the exact same, but they all come from the same database.   Yes, they all used the same exact ODBC connection to the database.   Yes, the BO user has permission to all tables.
0
 
mlmccCommented:
Any subreports?
If so did you change those connections?

mlmcc
0
 
mlmccCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.