Skip to Content
0
Former Member
Mar 19, 2009 at 05:08 PM

Failed to Open the Connection in InfoView

50 Views

Hello,

I have been unable to get Crystal Reports to run on InfoView using a third database. I have successfully added and run reports on InfoView which use two other databases, and I cannot figure out why reports using the third database will not run. The database is called NetRMS and is a Motorola product. When I add a report to a folder in the Central Management Console and attempt to preview the report, I receive the message, u2018Failed to Open the Connection. Unable to Retrieve Objectu2019. The User Name and Password that I am using DOES allow me to access that database and preview reports from the Crystal Reports program, and to run queries in the SQL Server Management Studio.

The Login Properties in SQL for the login I am using are set to 'Grant Permission' to connect to the database engine, and the Database Source properties in the Crystal Report match those in the database I am trying to connect to.

I am at an impasse with this and will Greatly appreciate any help you can give me.

Thank you, Linda