Problem with connection in Business Objects ReportViewer

Hello, I hope you can help...

I have Business Objects Enterprise XI R2 installed on a server, we are using Crystal Reports to report off a SQL Server database.  We have built several Business Views and published them to the repository on the server.  We can create reports in Crystal (XI R2) using the Business Views and the reports run fine as standalone reports on client machines.

However, if we publish the reports to the repository and try to run them through InfoView, the report fails and we gett he following error:

Failed to open the connection. Cannot open database. Failed to open the connection. C:\WINDOWS\TEMP\{CA6754B9-0342-4776-9E9F-71A6CA9D24C0}.rpt

ERROR: Failed to open the connection. Cannot open database. Failed to open the connection. C:\WINDOWS\TEMP\{CA6754B9-0342-4776-9E9F-71A6CA9D24C0}.rpt  

I have set the connection for the Business View to use integrated security, with single sign on (tried with & without this option) using OLE DB SQL Server driver. InfoView is configured to use AD authentication using NTLM with single sign on.

If I try to build a report directly in InfoView I get the following error:

WebReporting.dll '0x800002F4'
Failed to open the connection.
Cannot open database.
Failed to open the connection.
UNKNOWN.RPT
line: 14349

Interestingly, if I build a report directly off the database (i.e. bypassing the Business View) if I use an RDO connection, I get a similar message:

Failed to open the connection. Failed to open the connection. C:\WINDOWS\TEMP\{699B5125-A1EA-4E14-9A51-07E739380546}.rpt

ERROR: Failed to open the connection. Failed to open the connection. C:\WINDOWS\TEMP\{699B5125-A1EA-4E14-9A51-07E739380546}.rpt  

However, if I use ADO, it does work, although it (annoyingly) prompts me for the user credentials.

Any ideas?
 
Morrelli_1Asked:
Who is Participating?
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.

mnyeCommented:
are you certain the SQL Server driver are loaded on that server? also, I doubt its the culprit but what account are you running the BOE services under?  running the services under a network login with admin privileges on the server is best practices.
0
Morrelli_1Author Commented:
Hi thanks for the reply, I am certain the drivers are on the server, I can browse the data from within the Business View Manager (on the server) when I am designing it, so I guess they must be.  Also, there is actually a full installation of SQL server on the same server.  In terms of the services, they are all running under the local system account with the exception of the Central Management Server service, which is running under a domain account (ServiceCMS) becuase this was required to get SSO working.  I tried changing it to Local System, but it had no effect.
0
mnyeCommented:
are there any clues in the log files? might want to try runing the Profiler to monitor all login attempts to see what user is trying log in and why its being denied.
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

mlmccCommented:
SOunds like a privilege error in MS SQL.  Check the permissions to ensure all users have permissions to the tables, views, SPs.

mlmcc
0
Morrelli_1Author Commented:
Hi, it isnt a privilege problem, i am sysadmin on the SQL server, and I can refresh the reports from within Crystal, just not via the CrystalReportViewer in InfoView. I think it has something to do with passing the credentials from InfoView through to the database.
0
Morrelli_1Author Commented:
mnye, thanks for the advice, I have looked at the IIS logs, but cant see anything obvious. Not sure where else to look really. Nice idea about the Profiler, I will try that later today.
0
integraadminCommented:
InfoView doesn't work with Business Views. I'm not sure how to self-serve  a report that does. I received the following from the "help" desk:

Regarding your problems opening the report with CR Viewer, this is a known issue because Business Views is not a valid source for Viewer. Please refer to pag.14 of the documentation for Crystal Reports Viewer available at:

http://support.businessobjects.com/documentation/product_guides/default.asp

From this link please select:
- Select Version = Business Objects XI Release 2
- Select Product = Crystal Reports Viewer
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
Computer101Commented:
Forced accept.

Computer101
EE Admin
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.