Viewing a Report from Infoview generate Error: The Database logon for this

[Former Member]

I have deployed several Crystal Reports onto Crystal Reports Server 2008. When I try to view these reports from Infoview or CMC I get an error: "The database logon for this report is either incomplete or incorrect."

The reports are set up to use a ODBC connection using SQL native client driver. The database is SQL Server 2005 which resides on a different server. Do I need to configure the database (SQL) server in CMC??

[Former Member · Accepted solution]

The reports do run on the server by refreshing them from Crystal reports. Since the reports use a SQL database on a different server, do I need to configure some of the different servers (job, report, etc) to support this integration across servers?

[hitomi_takano · Accepted solution]

What is the error you are getting from Crystal Reports on the server? Is the ODBC dsn is configured on the server and test connection is successfull for the report in ODBC panel?

Hitomi

[Former Member · Accepted solution]

There is no error from Crystal Reports on the server. I have configured the ODBC dsn and successfully tested the connection from the server. The Report will just not run from Crystal Reports Server.

[hitomi_takano · Accepted solution]

The dsn on the server should be system dsn.

[Former Member · Accepted solution]

HI,

since one week i facing this same kin do f problem and getting same error ?

did somebody got solution on this error ?

any suggestion is appreciate.

Thanks.

[BasicTek · Accepted solution]

If you have configured the report in the CMC, the middleware(ODBC) on the server, then try to test the middleware by running CR on the server. If that is not available then open a case with support and trace the problem.

Regards,

Tim

[kalpesh_pandey · Accepted solution]

From Business Objects Enterprise perspective I would Try adding "-trace" in the command line of CMS and Page server. Start services and then try to run report again. See if it gives any meaningfull error message in the trace file. You view option must not be set to Advance DHTML else inthat case you have to set this in RAS server.

[Former Member]

I have configured the Report Properties in the CMC under Database Configuration. I specified the ODBC driver the report uses and the correct server on which the database resides. I have also successfully tested the ODBC connection the report uses. I'm now getting the error: "Failed to Load Database Information."

[hitomi_takano]

Hi Ernesto,

Could you test the report in Crystal Reports on the server? Try Database - Verify Database. Does the report successfully refresh in Crystal Reports on the server? If this doesn't work, it will not work when it is viewed from web.

Hitomi

[BasicTek]

Try CMC > report properties > processing, database. From here you can enter DB credentials. They are not auto sent to the server when you add a report unless using publishing wizard or import wizard (from another system where the report may have the same connection) You also must specify the client DB driver on the server (ODBC in the case of SQL).

Regards,

Tim