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?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Do they all use the sme ddatabase connection?

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.
Same tables?

Do you use the same ODBC from Crystl?

Does the BO user have permissions to all tables?

PMI ACP® Project Management

Prepare for the PMI Agile Certified Practitioner (PMI-ACP)® exam, which formally recognizes your knowledge of agile principles and your skill with agile techniques.

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.
Any subreports?
If so did you change those connections?

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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.