Business Objects XI: Incorrect log on parameters

I have many reports currently published to the Business Objects site that access a SQL Server database using an ODBC connection using SQL authentication.  This ticket database is now being replicated to another server and I am trying to publish reports that access the replicated database using a ODBC connection using windows authentication.  Using Crystal Reports, I can utilize the ODBC connection with windows authentication without any problem.  After publishing the report to Business Objects and utilizing the same windows credentials, I receive the following error: Error in File d:\temp\procSched\servernamehere.report\~tmp1efc572dc97c20a5.rpt: Unable to connect: incorrect log on parameters.  The Job Server is set up to use local system account.
almalerAsked:
Who is Participating?

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

x
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.

crgary_txCommented:
Set the job server to use your windows account if you have the access to the server box.. Once I had an issue with the LOVs and it worked after I changed the LOV job server to use a different login as per the BO support. There was no explanaition given for why it had to be changed when it worked before!
0

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
almalerAuthor Commented:
The solution was modifying each of the BO services to logon with a domain user account instead of the localsystem account.
0
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.