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?
 
integraadminConnect With a Mentor Commented:
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
 
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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
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
 
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
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0
All Courses

From novice to tech pro — start learning today.